Comments for Eric Humphrey http://www.erichumphrey.com aka @lotsahelp Wed, 27 Feb 2013 17:44:47 +0000 hourly 1 http://wordpress.org/?v=3.5.1 Comment on Return value or 0 if negative by tucek http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/7RAiDVUJZqw/ tucek Wed, 27 Feb 2013 17:44:47 +0000 http://www.erichumphrey.com/2007/09/return-value-or-0-if-negative/#comment-240 just what i was looking for. thank you!

]]> http://www.erichumphrey.com/2007/09/return-value-or-0-if-negative/#comment-240 Comment on Change SQL Startup Parameters with PowerShell by lotsahelp http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/bwfRRb1Iohc/ lotsahelp Sat, 09 Feb 2013 03:14:39 +0000 http://www.erichumphrey.com/?p=152#comment-239 It’s possible. This script just isn’t written for it properly.

]]> http://www.erichumphrey.com/2011/03/change-sql-startup-parameters-with-powershell/#comment-239 Comment on Change SQL Startup Parameters with PowerShell by Derek http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/rqI1M41qVSA/ Derek Fri, 08 Feb 2013 16:03:14 +0000 http://www.erichumphrey.com/?p=152#comment-238 What about adding it remotely? I would like to use this to add the flag to multiple servers.

]]> http://www.erichumphrey.com/2011/03/change-sql-startup-parameters-with-powershell/#comment-238 Comment on Locking While Dropping or Altering an Index by Tony Lucero http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/93x4_Z7-pdo/ Tony Lucero Mon, 28 Jan 2013 18:21:11 +0000 http://www.erichumphrey.com/?p=208#comment-237 “hypothetical index since neither are used by active queries?”

I wouldn’t be quite sure about that. I seen hypothetical indexes referenced in execution plans. I believe that internally the optimizer must divert back to the PK but have no evidence to backup. However whats worse is proper stats arn’t kept on the tables and furthermore the optimizer can’t offer proper index choices to help you index correctly. This is junk the last “DBA” left me from a failed index tuning job across of course all the busiest environments in my data center. I came here in the situation your in and like you a downtime is in the near future….

]]> http://www.erichumphrey.com/2011/05/locking_drop_index/#comment-237 Comment on Change SQL Startup Parameters with PowerShell by lotsahelp http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/Tu2W7wcrm5Q/ lotsahelp Wed, 09 Jan 2013 20:01:46 +0000 http://www.erichumphrey.com/?p=152#comment-236 It’s currently coded to do one at a time. I might update it to accept more when I have spare time.

]]> http://www.erichumphrey.com/2011/03/change-sql-startup-parameters-with-powershell/#comment-236 Comment on Change SQL Startup Parameters with PowerShell by John http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/QUQjMb_do_s/ John Wed, 09 Jan 2013 19:59:20 +0000 http://www.erichumphrey.com/?p=152#comment-235 Does this also work for multiple trace like -T1117 and -T1118 at the same time or would i need to run it twice ?

]]> http://www.erichumphrey.com/2011/03/change-sql-startup-parameters-with-powershell/#comment-235 Comment on Extract CLR Assemblies from SQL Server by lotsahelp http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/JCRR0VYPmq0/ lotsahelp Mon, 07 Jan 2013 21:04:10 +0000 http://www.erichumphrey.com/?p=282#comment-234 Yes, this is powershell code.

]]> http://www.erichumphrey.com/2012/03/extract-clr-assemblies-from-sql-server/#comment-234 Comment on Extract CLR Assemblies from SQL Server by viktor http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/0VHVXi-oLOM/ viktor Mon, 07 Jan 2013 20:07:15 +0000 http://www.erichumphrey.com/?p=282#comment-233 Is it PowerShell?
Thank you.

]]> http://www.erichumphrey.com/2012/03/extract-clr-assemblies-from-sql-server/#comment-233 Comment on A Seat at Two Masters’ Table by So why do you want to come to our training? And the winner is… | Paul S. Randal http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/LRUNG9ddjCA/ So why do you want to come to our training? And the winner is… | Paul S. Randal Thu, 03 Jan 2013 15:17:27 +0000 http://www.erichumphrey.com/?p=61#comment-232 [...] Eric Humphrey: A Seat at Two Masters’ Table [...]

]]> http://www.erichumphrey.com/2011/01/a-seat-at-two-masters-table/#comment-232 Comment on SQLskills Immersion Event on Internals and Performance – Day 4 by Our February Immersion Event in Dallas, TX – Final Wrap-up | Kimberly L. Tripp http://feedproxy.google.com/~r/CommentsForEricHumphrey/~3/WbHkxx0wi8E/ Our February Immersion Event in Dallas, TX – Final Wrap-up | Kimberly L. Tripp Wed, 02 Jan 2013 14:54:01 +0000 http://www.erichumphrey.com/?p=138#comment-231 [...] SQLskills Immersion Event on Internals and Performance – Day 4 [...]

]]> http://www.erichumphrey.com/2011/02/sqlskills-dallas-feb2011-day4/#comment-231