Viewing 15 posts - 11,896 through 11,910 (of 22,214 total)
Temporary tables will cause the recompile. If the amount of data you're working with is small, say less than 200 rows, you could switch to table variables. These will not...
September 6, 2011 at 4:55 am
It's not a very big table. Is there lots of contention? Other processes accessing it while you're attempting to defrag? That would explain the slow down.
September 6, 2011 at 4:51 am
You can't get zero i/o, ever. You have to have some i/o or you're neither querying or returning any data. So that goal is right out the window.
As far as...
September 5, 2011 at 8:10 am
There's not enough information here to give you good info. First, the database tuning adviser is a pile of steaming brown stuff. It's recommendations are frequently useless and sometimes dangerous....
September 5, 2011 at 8:03 am
forsqlserver (9/5/2011)
Just to be included in the answers
You don't have to do that. If you go to the top right of the page with the question on it and click...
September 5, 2011 at 7:59 am
Backups are largely an I/O operation. How fast are your disks? Are you backing up over the network? Are there contentions on the system? Can you put multiple disks to...
September 5, 2011 at 7:58 am
beejug1983 (9/5/2011)
Only backup job is running at scheduled time.
There has to be something else going on. Has to. SQL Server doesn't just randomly decide to slow down. Are you backing...
September 5, 2011 at 7:55 am
GilaMonster (9/4/2011)
Grant Fritchey (9/4/2011)
September 4, 2011 at 6:24 am
The question is, what is causing it? What are your queries doing and what is your structure such that you're getting excessive writes? Could something have changed between RTM &...
September 4, 2011 at 6:09 am
And having Enterprise wouldn't change the fact that you need to adjust the trace events to collect only the information you need. Nothing magic there.
September 4, 2011 at 6:07 am
What do you mean by row versioning? Do you mean the data type rowversion? It's meant as a mechanism for concurrency, to determine if someone has modified a record that...
September 4, 2011 at 6:05 am
I'm assuming that Common.dbo.AuthorizedDepartments is a table valued function, right? Is it a multi-statement table valued function? If so, that's the problem right there. Based on what you're saying about...
September 4, 2011 at 6:01 am
The only deviation I would make on the clustered index over what Gail says is to look for the most frequently accessed path to the data. Usually, it's the primary...
September 4, 2011 at 5:53 am
falcon00 (9/2/2011)
Grant Fritchey (9/2/2011)
So when do you need the old value again? I don't completely understand.
🙂
NEVER!!!
I know I know, that's what I said.
All they want is just to send...
September 3, 2011 at 4:56 am
GilaMonster (9/2/2011)
Grant Fritchey (9/2/2011)
I was just reading about monitoring latch waits over on Paul Randal's blog. He suggested this white paper to understand what's happening with latch waits..
There seems to...
September 2, 2011 at 5:04 pm
Viewing 15 posts - 11,896 through 11,910 (of 22,214 total)