Viewing 15 posts - 40,771 through 40,785 (of 49,571 total)
Lynn Pettis (2/25/2009)
Someone want to explain what the statistics profile is saying?
Will look in the morning, providing Grant doesn't get it first.
Is 11pm, and I'm dead tired.
February 25, 2009 at 1:38 pm
This doesn't look good. Do you have any idea when it started? Do you have a clean backup of this database?
How important is the data in this database? Will losing...
February 25, 2009 at 1:37 pm
Couple steps back...
What kind of process do you need to run when a row is inserted?
What's going to be running those processes?
February 25, 2009 at 12:45 pm
jblanco (2/25/2009)
February 25, 2009 at 11:28 am
Bob Hovious (2/25/2009)
Just out of curiousity, how many of you see this forum's ultimate objective to be giving people fish, or teaching them to fish?
Teaching, but you can't teach someone...
February 25, 2009 at 11:26 am
sudhakara (2/25/2009)
How do you exactly calculate the average disk queue in performon ?
If you have a SAN, don't bother. That counter's near impossible to interpret properly when the storage...
February 25, 2009 at 11:22 am
Since it's 2000, to get the exec plan, run the query with the statement SET STATISTICS PROFILE ON above it.
There will be a second resultset. Copy that, paste in excel,...
February 25, 2009 at 11:20 am
steve smith (2/25/2009)
February 25, 2009 at 10:08 am
steve smith (2/25/2009)
Sorry all. This is the first time that I've experimented with using font sizing. Does '2' work better? [pls reply only if you need larger]
How...
February 25, 2009 at 9:41 am
Steve Jones - Editor (2/25/2009)
Job - granularity is only every minute, so be aware there.
The job doesn't have to be scheduled. I did something like this with replication where the...
February 25, 2009 at 9:16 am
What kind of system is this? What data are you storing?
February 25, 2009 at 9:14 am
Lynn Pettis (2/25/2009)
What is "best practices" actually? What is "best" today may not be "best" a week, or month, or year from now.
Which is one of the reasons I...
February 25, 2009 at 9:10 am
Also Inside SQL Server 2005: Query Tuning and Optimisation which, as it's name implies, is an entire book on query tuning and optimisation.
February 25, 2009 at 9:07 am
It's perfectly normal with 2000 SP4. It happened in earlier versions, but wasn't reported.
If a query runs parallel and some of the threads are slower than others, the ones that...
February 25, 2009 at 9:02 am
DBA (2/25/2009)
should'nt the DBCC OPENTRAN returnthis open transaction?
What DB are you running it in? What DB's the transaction in?
February 25, 2009 at 8:53 am
Viewing 15 posts - 40,771 through 40,785 (of 49,571 total)