Viewing 15 posts - 16,681 through 16,695 (of 19,560 total)
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?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2010 at 1:37 pm
Can somebody explain this one to me?
FreeSystemCache before Tempdb Shrink
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2010 at 1:24 pm
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?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2010 at 1:23 pm
Lynn Pettis (3/9/2010)
CirquedeSQLeil (3/9/2010)
Lynn Pettis (3/9/2010)
I think it's time for trip to the desert. Anyone care to join me? I'll put the hippo on a leash. 😛
Care to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2010 at 1:16 pm
Fantastic - now that we advertise for hair curlers, what will be next?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2010 at 1:15 pm
Thanks for posting back. I presume this query solves your unwanted data issue.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2010 at 1:13 pm
Viewing 15 posts - 16,681 through 16,695 (of 19,560 total)