Viewing 15 posts - 16,606 through 16,620 (of 22,211 total)
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
Thanks. I was told the max number was 435. I only saw...
September 2, 2009 at 8:56 am
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
What is wrong with using Avg. Disk Queue Length?
Two things.
Firstly, SQL can and does drive it very high if it does large read-ahead reads. If the storage...
September 2, 2009 at 8:45 am
Jack Corbett (9/2/2009)
Steve Jones - Editor (9/2/2009)
GilaMonster (9/2/2009)
Nah. Forgotten about it already.She says that Jack, but let's see if she invites you to train on Tues or Wed night ...
I'll...
September 2, 2009 at 7:59 am
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
Thanks. I was told the max number was 435. I only saw 410. Still, that's...
September 2, 2009 at 7:38 am
GilaMonster (9/2/2009)
Hey Grant.I completely disagree with your choice of disk counter. Just so you know. 😉
Please, disagree away. I just tried the find the bare bones basic counters. I...
September 2, 2009 at 7:37 am
Alvin Ramard (9/2/2009)
Jack Corbett (9/2/2009)
Now whenever I read one of your posts I'll have the correct voice in my head:-P
Next up for me...
September 2, 2009 at 7:36 am
Jack Corbett (9/2/2009)
Enjoying Gail's session on indexing on 24 hours of PASS. Don't know how much I'll retain being up this early.
I'm definately getting the download on that one.
September 2, 2009 at 7:34 am
nigel (9/2/2009)
Grant even said in his post that it wasn't the greatest approach.
I would avoid recursive CTEs if there is a more...
September 2, 2009 at 7:32 am
GilaMonster (9/1/2009)
Alvin Ramard (9/1/2009)
24 Hours of PASS starts today and I did not get a good night's sleep last night. It's gonna be a fun 2 days.
Starts tomorrow for...
September 1, 2009 at 7:41 pm
Krasavita (9/1/2009)
When I ran the query,it wasn't running slow
Ah, well, that's why there wasn't any useful information in the query. You need to gather the information when the slow performance...
September 1, 2009 at 6:50 am
Yeah, if the procedure kicks out an error, the job should have an On Error statement that determines what to do.
September 1, 2009 at 6:06 am
Rollback is necessary for SQL Server to preserve the integrity of the database. You don't want it to just leave a bunch of half-saved records hanging out in a database...
September 1, 2009 at 6:02 am
Krasavita (8/31/2009)
Here is my results.What should I look for?
Looking at that data, I don't see anything running especially slowly. There are no blocked processes. Are you sure that the server...
September 1, 2009 at 5:58 am
Better than sp_who2, take a look at the DMV sys.dm_exec_requests. That will show you currently running queries. You can combine it with other DMV/DMF to arrive at the query being...
September 1, 2009 at 5:53 am
You can put a RAISERROR statement within the CATCH statement of your error handler so that, assuming the error needs to be returned, you can raise it and it will...
September 1, 2009 at 5:51 am
Viewing 15 posts - 16,606 through 16,620 (of 22,211 total)