Viewing 15 posts - 17,011 through 17,025 (of 19,560 total)
Look at that, Barry needs 23 points for 9000 - big milestone.
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
February 24, 2010 at 3:17 pm
jcarney 24614 (2/24/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
February 24, 2010 at 2:25 pm
There was an update to the code - I didn't post it to the contest just in this thread.
That is interesting that it took that much longer for 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
February 24, 2010 at 1:58 pm
jcarney 24614 (2/24/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
February 24, 2010 at 1:49 pm
jcarney 24614 (2/24/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
February 24, 2010 at 1:25 pm
Elliott W (2/24/2010)
I think a fundamental problem with many dev and test environments is limited data, prod data may not belong, but prod...
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
February 24, 2010 at 1:22 pm
This may be of use
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
February 24, 2010 at 12:55 pm
Is the SSIS package running from a different workgroup or different domain?
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
February 24, 2010 at 12:53 pm
Prod data does not belong in development. There is no problem having the data scrubbed and used in dev - except for effort in scrubbing it.
I recommend developing a...
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
February 24, 2010 at 12:51 pm
Tara-1044200 (2/23/2010)
How can a user run Database Tuning Advisor without having db_owner previalges ?
I think you should start a new thread with this question.
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
February 24, 2010 at 11:57 am
jcrawf02 (2/24/2010)
Alvin Ramard (2/24/2010)
Just be careful about loving the one ewe're with. 😀
wow, I concede....whatever it is we're competing for.
No, I think you win.
By the way was that Dolly?
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
February 24, 2010 at 11:53 am
I belive Redgates tool can do it.
Idera can do it as well.
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
February 24, 2010 at 11:52 am
Since you already have the execute sql task and a query, why not alter it a bit and use sp_send_dbmail?
http://msdn.microsoft.com/en-us/library/ms190307(SQL.90).aspx
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
February 24, 2010 at 11:50 am
jcrawf02 (2/24/2010)
Just started playing with xQuery, just curious how it would compare (now I have to go find out) [rant] who stores xmldata...
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
February 24, 2010 at 11:46 am
tstaker (2/24/2010)
Lynn Pettis (2/24/2010)
I have to disagree here. This is a good way to see how some thinks. Do they write a cursor or while loop to complete...
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
February 24, 2010 at 11:24 am
Viewing 15 posts - 17,011 through 17,025 (of 19,560 total)