Viewing 15 posts - 12,196 through 12,210 (of 22,214 total)
Ninja's_RGR'us (7/11/2011)
Hey grant I've surfed to http://www.scarydba.com/2008/07/02/code-from-dissecting-sql-server-execution-plans/ to download the code of the book and I just can't seem to find the download button.Care to help a blind man?
Not sure....
July 11, 2011 at 5:18 pm
SQLkiwi (7/5/2011)
July 7, 2011 at 6:58 am
Ninja's_RGR'us (7/4/2011)
July 4, 2011 at 7:02 am
GilaMonster (7/3/2011)
What Paul mentions is MVP-specific stuff that come straight to us (eg spending time in the 'ask the experts', hosting a 'birds of a feather' lunch...
July 4, 2011 at 6:44 am
opc.three (7/2/2011)
opc.three (7/2/2011)
Lynn Pettis (7/2/2011)
July 3, 2011 at 5:56 am
TST1 (7/1/2011)
Thanks Gail, but the guy closed his session so I guess he'll have to re-write!
I did the same thing myself a couple of weeks back. This little query[/url] saved...
July 1, 2011 at 11:20 am
Jim Murphy (7/1/2011)
Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!
DITTO!
July 1, 2011 at 11:13 am
Just using a SQL Query? No.
You can program it, but you'd want to look into using something like Powershell in combination with SMO in order to do it.
June 30, 2011 at 8:08 am
Speaking honestly, there is no best tool. There is a best tool for your situation and the amount of money you're prepared to spend and the type of monitoring you...
June 30, 2011 at 7:15 am
sqlnaive (6/29/2011)
Here is the attachment. I've scratched my head blue and black. 🙁
The optimizer is timing out on this query, so whatever plan you have is less than optimal.
Why all...
June 30, 2011 at 7:03 am
Just remember, those costs are just estimates, not actual measurements. This means there is no correlation between index fragmentation and what you're seeing in the execution plan and what is...
June 30, 2011 at 6:55 am
In SQL Server Management Studio, right click on the database in question and select "Tasks" - "Generate Scripts" and follow through the process there. You should be able to script...
June 30, 2011 at 6:53 am
Add another file to the log on tempdb on a different drive. Then you should get a log truncation at the next checkpoint and then you can shrink the file...
June 30, 2011 at 6:45 am
SQLkiwi (6/30/2011)
Trey Staker (6/29/2011)
I wish there were ratings on posts, maybe a thumbs up or down on answers like on Ask SCC.
Interesting idea. One effect might be that the...
June 30, 2011 at 5:25 am
I don't know licensing for crap. Because I don't know licensing, I always refer licensing questions to sales people & lawyers. Seems safer.
Regardless, can you do this thing, splitting up...
June 29, 2011 at 12:03 pm
Viewing 15 posts - 12,196 through 12,210 (of 22,214 total)