Viewing 15 posts - 16,906 through 16,920 (of 19,560 total)
Greg Charles (3/2/2010)
Have you seen this one? http://www.sqlservercentral.com/scripts/SQL+Server+7%2c+2000/61878/. I've used it to document some of my instances.
That's a good script.
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 2, 2010 at 4:43 pm
Here's an article that helps with that
http://decipherinfosys.wordpress.com/2008/03/15/ssis-execute-sql-task/
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 2, 2010 at 4:34 pm
Seen it - before my time, but doesn't preclude from knowing it
Zippity Doo Da, Zippity Ay My oh my what a wonderful day
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 2, 2010 at 3:12 pm
compare execution plans between the poorly performing database and one that is performing as expected.
You are likely missing indexes if it is performing slowly (much the same as in 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 2, 2010 at 2:35 pm
Isn't that the same stuff that they used in HairSpray?
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 2, 2010 at 2:10 pm
Detonate
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 2, 2010 at 12:25 pm
Congrats Tim on getting your article published.
Good job.
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 2, 2010 at 12:22 pm
deteriorate
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 2, 2010 at 12:07 pm
Ray K (3/2/2010)
First, as someone who has technical communication experience, one of my big things is...
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 2, 2010 at 12:00 pm
debutant
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 2, 2010 at 11:44 am
Lynn Pettis (3/2/2010)
Julie Breutzmann (3/2/2010)
The Dixie Flatline (3/1/2010)
Keith,To handle concatenation of nulls, you need use either the ISNULL() or COALESCE() function. .
I recommend that you use COALESCE. ISNULL...
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 2, 2010 at 11:41 am
deterrability
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 2, 2010 at 10:38 am
Detergent
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 2, 2010 at 10:18 am
Steve Jones - Editor (3/2/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
March 2, 2010 at 10:17 am
Steve Jones - Editor (3/2/2010)
The Bears are kind of a football team. With Cutlet at QB, they're not a great imitation of one :w00t:
Yeah - thanks for offloading 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
March 2, 2010 at 10:14 am
Viewing 15 posts - 16,906 through 16,920 (of 19,560 total)