Viewing 15 posts - 1 through 15 (of 58 total)
What a contribution. What a link! What's next?
October 1, 2015 at 8:18 am
Everyone else looks at stats table I knew there was a datetime in the indexes system table... Why do I even go out on google anymore. Thanks SSC 😀
July 18, 2013 at 2:35 pm
My thoughts exactly.
SET ROWCOUNT
March 6, 2013 at 1:35 pm
This sets your article back to active. :w00t:
December 27, 2012 at 10:14 am
I hope you don't mind but I posted this about you on facebook 🙂
"I like this guys code very robust and feature complete....."
December 6, 2012 at 11:32 am
Lost and have been chasing this CPU query down for several days THANKS!!!:w00t:
December 3, 2012 at 4:04 pm
Oh and I would also add that the real reason you make a second log file yes is for space emergencies. But I'm not talking after the fact I'm...
January 25, 2012 at 2:05 pm
I believe EMPTYFILE is the better idea then truncate in your script .
BOL says the following.
EMPTYFILE
Migrates all data from the specified file to other files in the same filegroup....
January 25, 2012 at 1:52 pm
I have also read the article and it makes since that at the OS level only one thread can look a file at a time.
There for if you...
July 19, 2011 at 9:59 am
Oxygen thank you for the post your code got me 80 % of the way there. I modified your cursor to look for PK in the db that are...
March 17, 2011 at 1:13 pm
Ali,
I am using SSMS. the query window.
Have a good weekend and a beer on me.
MudLuck out
September 24, 2010 at 2:36 pm
Blade you the man. Tried to do an ad hoc update which is not allowed without a single mode Séance which can't be done.
I had to change...
September 23, 2010 at 2:52 pm
The issue wasn't the scripits they work te problem was the authentifiation mode it was set to NT only...
Dumb dumb dumb
September 23, 2010 at 11:10 am
Found out what the true problem was I didn't have the authentification mode set to windows auth only.
After that was able to get the passwords to work correctly..
Doh I hate...
September 23, 2010 at 10:31 am
Viewing 15 posts - 1 through 15 (of 58 total)