Viewing 15 posts - 16,501 through 16,515 (of 22,211 total)
As a rule, you want indexes to be as narrow as possible and as selective as possible. So the best index is a unique integer value. However, the real world...
September 17, 2009 at 7:33 am
It sounds like one of two, or even a combination of two, things; caching of the data, and compiling of the execution plans. I'd suggest firing up a server side...
September 17, 2009 at 7:27 am
Oh, and, I honestly don't know how helpful this book would be, but I can't help posting the shameless plug: Beginning SQL Server 2008 Adminnistration.
But really, the best for your...
September 17, 2009 at 7:09 am
That's a rough situation. Another book that might help is Craig Mullin's Database Administration. It's an excellent introduction to what the DBA job consists of, why you do it, etc....
September 17, 2009 at 7:05 am
This sure sounds like homework. Lots of people here on the board will be happy to help, but please show the queries you've tried that haven't worked and we can...
September 17, 2009 at 6:46 am
WAY back on SQL Server 6.5, we had to schedule a reboot once a week because that version of SQL Server and the Windows operating system back then were so...
September 17, 2009 at 6:40 am
From what I can see, it looks like REPAIR_DATA_LOSS has fixed the issue (at what cost, you have yet to find out). What problem are you having after running the...
September 17, 2009 at 6:14 am
forum member (9/16/2009)
I am still confused,whether to go ahead with lock or no lock on queries for example while one user is booking a product or editing a product...
September 17, 2009 at 5:33 am
BobMcC (9/16/2009)
I have a user that needs access to one of my databases with a query tool....
September 16, 2009 at 5:06 pm
Especially when you're talking about some huge long running query, a little bitty thing could cause contention with it, yeah. It's entirely possible that one process caused the other problems.
September 16, 2009 at 12:43 pm
Ah, well, hard to know then, but I'd still be inclined to some kind of blocking. It makes the most sense based on the evidence. If it happens again, and...
September 16, 2009 at 11:33 am
Did you look at the server to see if there were other processes running, other connections with locks?
September 16, 2009 at 10:34 am
You should evaluate Wait Stats. Andrew Kelly had an excellent little article in SQL Server Magazine recently. The Instanct Doc ID was 102111.
September 16, 2009 at 9:23 am
Not being there, it's really hard to know after the fact, but on a guess... You had contention that was slowing down the rollback process. Then, when you rebooted, the...
September 16, 2009 at 9:14 am
hsac1301 (9/16/2009)
I have SQL 2005 server and because of the power failure, The databse has been corrupted. I have no backup at all.
I have tried
exec sp_resetstatus 'Net'
alter database Net SET...
September 16, 2009 at 9:05 am
Viewing 15 posts - 16,501 through 16,515 (of 22,211 total)