Viewing 15 posts - 7,411 through 7,425 (of 19,560 total)
Welsh Corgi (12/23/2011)
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
December 24, 2011 at 12:27 am
Here is another method
http://spaghettidba.com/2011/09/09/a-better-sp_msforeachdb/
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
December 24, 2011 at 12:24 am
bhaveshp.dba (12/23/2011)
I want to disply last day of the month in SSRS .
I have year and Month parameter as well as Field aslo.
How can i display last day 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
December 24, 2011 at 12:20 am
This occurs as soon as SQL Server starts, or as soon as you try to connect to SQL server through SSMS?
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
December 24, 2011 at 12:16 am
JoeA (12/23/2011)
The original 1960's Batmobile with real working batcessories (and new tires)
I'd settle for any of the Batmobiles.
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
December 24, 2011 at 12:11 am
lkokeunda (12/22/2011)
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
December 23, 2011 at 8:46 am
rcargas (12/23/2011)
IRON MAN suite case or Tony Stark's holographic computer system... you said "have fun and dream a little".
That would be a really cool gift.
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
December 23, 2011 at 8:31 am
Steve-3_5_7_9 (12/23/2011)
Red Ryder BB Gun.Merry Christmas
Nice - don't shoot an eye out though.;-)
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
December 23, 2011 at 8:29 am
Mike Dougherty-384281 (12/23/2011)
Just to clarify for those confused by the eating association to these animals, we don't eat black cats for Halloween either.
Well, maybe. Ever heard the song Cat's...
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
December 23, 2011 at 8:25 am
Dev (12/23/2011)
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
December 23, 2011 at 12:15 am
Another idea, do you still have the query window open from which you made all of the changes?
Try hitting undo a bunch of times from there until it gets back...
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
December 23, 2011 at 12:08 am
Dugi (12/23/2011)
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
December 23, 2011 at 12:07 am
You may get lucky with that query. Keep in mind that the old proc definition is not guaranteed to be in the cache - but it's worth a shot.
I...
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
December 23, 2011 at 12:03 am
If you have no backup, and the proc is not in source control, and you did not save the proc definition prior to making your changes, then you can try...
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
December 22, 2011 at 11:56 pm
Can you describe the SSIS package to us?
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
December 22, 2011 at 11:54 pm
Viewing 15 posts - 7,411 through 7,425 (of 19,560 total)