Viewing 15 posts - 16,846 through 16,860 (of 19,560 total)
If you run a report that retrieves massive amounts of data then you run the risk of contention and blocking. However, you should tune your queries and database such...
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 4, 2010 at 6:05 pm
masterpiecebeta2 (3/4/2010)
How to check my current schema that im staying right now
Not sure what you mean.
Could you clarify what it is you are trying to find out?
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 4, 2010 at 6:01 pm
Nice article and well presented.
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 4, 2010 at 5:54 pm
Chris Morris-439714 (3/4/2010)
Gabriel P (3/3/2010)
Comments posted to this topic are about the item <A HREF="/articles/Moving+Average/69389/">Calculating Moving Averages with T-SQL</A>
Excellent article, Gabriel. I reckon it's time to start messing with those...
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 4, 2010 at 5:53 pm
Paul White (3/4/2010)
beep...beep...beep...beep.............................................beeeeeeeeeeeeeeeeeeeeeeep!
That was almost as good as the sound effects from Tron.
Another one of those movies (Star Wars all but Episode 3) that my kids are hooked on these...
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 4, 2010 at 5:51 pm
VALEK (3/4/2010)
Do you want 448 exam? I can shoot what I have for it on my PC
Please don't be distributing braindumps, purchased software, or violate the NDA through the 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
March 4, 2010 at 5:47 pm
GilaMonster (3/4/2010)
aaron.reese (3/4/2010)
Delete writes to the transaction log and will roll back if there is an issue whereas Truncate does not.
Not true.
Truncate is a logged operation, it can...
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 4, 2010 at 5:44 pm
I like Jeff's idea. It is very useful to do it in this fashion and will save a lot of pain.
Another option is to script out the database 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 4, 2010 at 5:34 pm
Do you have a good full backup?
Do you have transaction logs since the last full backup?
If yes to both, then you can restore your database up to the time 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
March 4, 2010 at 5:28 pm
TPR -threadopulmonary resuscitation.
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 4, 2010 at 4:31 pm
http://dijest.editthispage.com/tools/pm
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 4, 2010 at 4:30 pm
Thanks
Enjoy the reading.
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 4, 2010 at 3:58 pm
The question was worth two points.
How many people only respond in the forum to the question, unless they get it wrong?
When they respond because they got it wrong, they are...
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 4, 2010 at 3:46 pm
BaldingLoopMan (3/4/2010)
Maybe I'm being thick, but I am trying to see the connection between truncated data and the quote...
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 4, 2010 at 3:32 pm
john.arnott (3/4/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 4, 2010 at 3:11 pm
Viewing 15 posts - 16,846 through 16,860 (of 19,560 total)