Viewing 15 posts - 16,516 through 16,530 (of 22,226 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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 16, 2009 at 9:05 am
Viewing 15 posts - 16,516 through 16,530 (of 22,226 total)