Viewing 15 posts - 18,346 through 18,360 (of 19,560 total)
homebrew01 (1/6/2010)
laddu4700 (1/6/2010)
Restore full backup with no recoveryrestore diff backup with no recovery
restore diff 2 backup with recovery
You only need to restore the most recent diff, then all the transaction...
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
January 6, 2010 at 11:43 am
Thanks for the article
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
January 6, 2010 at 11:33 am
john.arnott (1/6/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
January 6, 2010 at 11:32 am
Interesting article. More interesting thread. I am stunned by the "Professional" Community and by the some of the denizens of SSC. Way too much personal bias without...
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
January 6, 2010 at 11:29 am
Nice one
while i < 2
Begin
Print 'People Stop Buying things because people stopped buying things'
i=1
End
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
January 6, 2010 at 10:26 am
Nice Question - with or without the Northwind DB (which I do not have). A logical approach on this question should reveal the answer.
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
January 6, 2010 at 10:14 am
Thanks Gail. Once again you have taught me something.
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
January 6, 2010 at 10:00 am
Acai
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
January 6, 2010 at 9:53 am
Alvin Ramard (1/6/2010)
GilaMonster (1/6/2010)
Steve Jones - Editor (1/6/2010)
I see The Thread is alive and well. Happy 2010 to everyone.And to you Steve. Welcome back.
Ditto
And another Ditto
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
January 6, 2010 at 9:52 am
GilaMonster (1/6/2010)
GSquared (1/6/2010)
If you can't access it, try Tarot cards to figure out the password.I have a set, if you need me to do a reading.
That might be a handy...
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
January 6, 2010 at 9:49 am
Lynn Pettis (1/6/2010)
Dave Ballantyne (1/6/2010)
GilaMonster (1/6/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
January 6, 2010 at 9:48 am
Dave Ballantyne (1/6/2010)
GilaMonster (1/6/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
January 6, 2010 at 9:46 am
Lankford
Mattingly
Dale Murphy
McGwire (don't care about the alleged steroid use - too many baseball players use them for that to be a fair argument)
Dawson
Maybe Larkin
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
January 5, 2010 at 6:29 pm
As John said, using the NOLOCK will not guarantee that a deadlock does not occur. It is a strong suggestion to the query optimizer - but may not be...
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
January 5, 2010 at 5:20 pm
It is the same process. The reason you may run into problems is due to Policies that may or may not be place at the OU level. Another...
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
January 5, 2010 at 4:09 pm
Viewing 15 posts - 18,346 through 18,360 (of 19,560 total)