Viewing 15 posts - 31,426 through 31,440 (of 49,552 total)
Adiga (8/5/2010)
You may find this article useful in resolving deadlocks.
That article is for SQL 2000. There are better ways to get deadlock information on SQL 2005 and above. Traceflag 1222...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 5:03 am
Quite likely.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 4:40 am
Homework?
Interview?
Exam?
Have you tried google? I'm pretty sure a search will turn up the answer faster than waiting for someone to reply here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 4:37 am
SELECT SERVERPROPERTY('IsClustered') as IsFailoverClusterNode
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 4:29 am
Don't shrink!
Shrinking causes massive index fragmentation. It's going to undo all the work that your index defrag did, will probably leave the indexes more fragmented than they were before the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 4:28 am
Phil Harbour (8/5/2010)
OLDACT_SPID21s
The s denotes that it's a system SPID, rather than a user process.
Because on SQL 2005 the system SPIDs can have session_ids above 50, the old rule...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 4:27 am
Different volume of data
Different indexes
Different hardware
Different database load
Different statistics
Different set options
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 4:26 am
Did you bother to read those links I gave you?
Straight from the first one:
After creating a credential, you can map it to a SQL Server login by using CREATE...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 2:00 am
guptaajay1985 (8/5/2010)
suppose my database is just corrupted after running command backup log with NO_log , how Will I restore my databse?
Restore your last full backup and any transaction log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 1:58 am
kalivaraprasadm (8/4/2010)
That contains One clustered Index and 99 Non_clustered Indexes.
Why? Why? Why?
How many of those indexes are actually useful? (I'll bet less than 10% of them). If all are single...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 12:21 am
CirquedeSQLeil (8/5/2010)
It also never fails that when you think the change is insignificant and decide to skip the backup part - something bad is going to happen.
Wasn't the update that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 12:17 am
CirquedeSQLeil (8/5/2010)
I like to have a backup of the database right before I run the changes.
Me too, but some people seem to want to live dangerously.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 12:02 am
guptaajay1985 (8/4/2010)
When we use backup with NO_Log.Where that backup goes..
Nowhere. That command says to SQL 'do as if you were doing a log backup, but throw away what you would...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 12:00 am
Restore from backup.
Oh, wait, no backup. Why the hell not?
Run the following, post the results, hope that the data in that database is not critical.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2010 at 11:54 pm
B4u (8/4/2010)
Hi friends, would like to know what are the steps to resolve deadlock issuesapp: sharepoint
During the search crawl? If so, deadlocks are expected and are not a concern....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2010 at 11:53 pm
Viewing 15 posts - 31,426 through 31,440 (of 49,552 total)