Viewing 15 posts - 14,761 through 14,775 (of 19,560 total)
Lynn Pettis (4/16/2010)
Test, test, and test again!
Absolutely. Do it on a non-prod system first if possible. Document the changes made and then check for improvement or degradation of...
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
April 16, 2010 at 3:17 pm
Roy Ernest (4/16/2010)
nah...Its pretty short. Just 4 to 5 pages in word doc..... 🙂
Posting it for SSC or somewhere else?
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
April 16, 2010 at 3:16 pm
Anybody out there have SQL 2000 installed?
If so, can you verify for me if ANSI_NULLS is off in sp_who2 on your server?
I believe it would be since that is the...
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
April 16, 2010 at 3:15 pm
Roy Ernest (4/16/2010)
Yep...I was able to do another 25% of the article... Maybe by the end of the week, I will have it ready for review..🙂
Long article or what?
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
April 16, 2010 at 2:58 pm
DTA will recommend bogus indexes. It also recommends good indexes from time to time. Depending on your queries, performance and execution plans - you may actually need 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
April 16, 2010 at 2:51 pm
Database backups are separate from filesystem backups.
If you want the database to be backed up you need to use a backup designed for use in SQL server, which requires SQL...
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
April 16, 2010 at 2:25 pm
Jack Corbett (4/16/2010)
CirquedeSQLeil (4/16/2010)
I agree that the technical posts do tend to take a longer time to write. I wonder how many of my posts I could turn into...
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
April 16, 2010 at 1:23 pm
I enjoyed revisiting this article. This is a job well done.
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
April 16, 2010 at 1:20 pm
I appreciate the thank yous and recognition. I also appreciate when that recognition is in the form of gifts, cards, money, incentives. It is good to know that...
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
April 16, 2010 at 1:18 pm
Kit G (4/16/2010)
Tom.Thomson (4/16/2010)
Hypopotamus 😀 (would that be: under water; or small water ; or by means of water ???)
What about the Hyperpotamus? A hippo after drinking...
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
April 16, 2010 at 1:11 pm
Gianluca Sartori (4/16/2010)
jcrawf02 (4/16/2010)
Can you imagine how tough your life would be if you didn't know Jack?I'll bet he's sick of that joke, but I thought it was funny :hehe:
I'm...
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
April 16, 2010 at 10:20 am
Jack Corbett (4/16/2010)
CirquedeSQLeil (4/16/2010)
jcrawf02 (4/16/2010)
Brandie Tarvin (4/16/2010)
Jeff Moden (4/15/2010)
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
April 16, 2010 at 10:18 am
Luke L (4/16/2010)
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
April 16, 2010 at 10:13 am
Roy Ernest (4/16/2010)
What was the original purpose of this THREAD?BTW, I broke free from the writes block... Yay...!!!!
Congrats - what did the trick for you?
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
April 16, 2010 at 10:11 am
Wayne - I like your new avatar.
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
April 16, 2010 at 10:06 am
Viewing 15 posts - 14,761 through 14,775 (of 19,560 total)