Viewing 15 posts - 16,681 through 16,695 (of 19,564 total)
Lynn Pettis (3/9/2010)
March 9, 2010 at 4:23 pm
Alvin Ramard (3/9/2010)
CirquedeSQLeil (3/9/2010)
Maybe change it to Dr. Lynn Pettis. 😎Dr. Lynn Pettis, MVP ?
Maybe Dr. Lynn Pettis, MCP (master control program) :Whistling:
March 9, 2010 at 3:50 pm
Maybe change it to Dr. Lynn Pettis. 😎
March 9, 2010 at 3:42 pm
Cyberspy (3/9/2010)
Thanks for the pointer. I had a look though the rest of the logs and there was no sign of further attempts, so the delay must have not happened...
March 9, 2010 at 3:40 pm
Alvin Ramard (3/9/2010)
It shouldn't be yellow if you're using Depends. 😛
It shouldn't be either color if you're using depends. Maybe we could ask an Astronaut?
March 9, 2010 at 2:52 pm
Alvin Ramard (3/9/2010)
CirquedeSQLeil (3/9/2010)
Lynn Pettis (3/9/2010)
Alvin Ramard (3/9/2010)
Will someone please bring a deck of cards? Oh, and air freshner.What fragrance, Pine or New Car? 😉
Eau de Toilette
That would...
March 9, 2010 at 2:48 pm
Lynn Pettis (3/9/2010)
Alvin Ramard (3/9/2010)
Will someone please bring a deck of cards? Oh, and air freshner.What fragrance, Pine or New Car? 😉
Eau de Toilette
March 9, 2010 at 2:41 pm
YSLGuru (3/9/2010)
If you have a brand new out of the box install of SQL Server 2005 and the only thing you do to it is set it to use Mixed...
March 9, 2010 at 2:40 pm
Vivek29 (3/9/2010)
It will.I witnessed it.See my post..I said after clearing cache, perform shrink operation.:smooooth:
I am somewhat skeptical about that.
Freesystemcache:
Releases all unused cache entries from all caches. The SQL Server 2005...
March 9, 2010 at 2:35 pm
Roy Ernest (3/9/2010)
CirquedeSQLeil (3/9/2010)
Can somebody explain this one to me?Was that poster who provided the freeproc solution being sarcastic or was that genuine advice?
I believe it to...
March 9, 2010 at 2:27 pm
Lynn Pettis (3/9/2010)
Of course you may join me. I did get the Deluxe model tent from Hogwarts! 😉
Awesome - everybody pile in.
March 9, 2010 at 2:25 pm
Vivek29 (3/9/2010)
Who said to run it production server? I am giving an alternative to shrink tempdb without restarting server as asked in the very first post.This will help I guess:cool:
Your...
March 9, 2010 at 1:46 pm
Alvin Ramard (3/9/2010)
Too many people out there with hammers looking for nails. :rolleyes:
My hammer comes preloaded with nails. 😎
I think they are trying to use a jackhammer while looking...
March 9, 2010 at 1:40 pm
Jack Corbett (3/9/2010)
CirquedeSQLeil (3/9/2010)
Vivek29 (3/9/2010)
Run this before performing shrink operation.Use tempdb
go
DBCC FREESYSTEMCACHE(ALL);
DBCC FREESESSIONCACHE;
then perform your shrink operation.
Thanks
Vivek
Why?
Because shrinking TempDB is going to slow everything down, you might as well refresh...
March 9, 2010 at 1:37 pm
Can somebody explain this one to me?
March 9, 2010 at 1:24 pm
Viewing 15 posts - 16,681 through 16,695 (of 19,564 total)