Viewing 15 posts - 32,971 through 32,985 (of 49,552 total)
One of the snapshot isolations?
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
May 10, 2010 at 9:21 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic919053-145-1.aspx
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
May 10, 2010 at 8:39 am
Robert Frasca (5/10/2010)
I tried adding the index on Entry_Sequence on the Patient_Info_Fields table but it didn't use it.
Index on (Entry_Sequence, Patient_Info_Field_ID)? Should have, the index looks covering, unless I missed...
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
May 10, 2010 at 8:37 am
jpSQLDude (5/10/2010)
All user-defined server side traces are DELETED every time SQL Server is restarted (or even if you just restart the SQL Server Agent).
SQL Server, yes, SQL Agent, no. 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
May 10, 2010 at 8:33 am
Dave Ballantyne (5/10/2010)
Whats the Patient_info_field table ? Its table scanning , is there no indexes on that ?
Apparently there are 20 or so rows in it. Index may help, I...
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
May 10, 2010 at 8:20 am
Dave Ballantyne (5/10/2010)
Hmm the Optimizer is timing out. Reason for early Termination = "Time Out".
Considering the size, I'm hardly surprised. Looking at that thing last week I felt like...
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
May 10, 2010 at 8:13 am
Abrar Ahmad_ (5/10/2010)
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
May 10, 2010 at 7:51 am
You need to apply a service pack. I can't recall which one, but applying SP3 is safe enough.
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
May 10, 2010 at 7:37 am
I'm probably not going to get a chance to look at this, got a lot of work this week. Maybe Grant feels like a challenge.
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
May 10, 2010 at 7:34 am
Attachment? <looks around>
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
May 10, 2010 at 7:22 am
Restore the database from a backup taken before the change. If you don't want to overwrite the entire database, restore the backup as a new database and copy the data...
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
May 10, 2010 at 7:13 am
Abrar Ahmad_ (5/10/2010)
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
May 10, 2010 at 7:11 am
Abrar Ahmad_ (5/10/2010)
1. In which the there is no DB Team at all, except a White Elephant named as DBA.
Wow. How can you ask for a discussion when your bias...
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
May 10, 2010 at 7:07 am
You can check the default trace, if the server isn't too busy, the changes might still be in there. Otherwise you would have needed a trace or DDL trigger before...
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
May 10, 2010 at 4:15 am
sivark1 (5/10/2010)
EXEC sp_resetstatus 'yourDBname';ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
No! No! No!
That is terrible advice, it is...
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
May 10, 2010 at 2:59 am
Viewing 15 posts - 32,971 through 32,985 (of 49,552 total)