Viewing 15 posts - 16,846 through 16,860 (of 49,552 total)
🙂
Ones you can't get without turning that setting on, where you also wouldn't expect to even get a deadlock.
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 30, 2012 at 11:13 am
Looks like either someone's been messing with the metadata or there's been some odd problem dropping an index somewhere. The index structure still exists but the metadata's gone.
Recreating the table...
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 30, 2012 at 11:11 am
Sorry, CREATE CLUSTERED INDEX .... WITH DROP_EXISTING
Note that it will take time and use log space. How much depends on the size of the table.
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 30, 2012 at 11:06 am
Jysafe Lerroy (8/30/2012)
on the second step, when I drop the file that shrunk, wouldn't that delete all the data in that file?
No, read up on what ShrinkFile with...
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 30, 2012 at 11:03 am
Could you post your actual scheme and function alteration code please?
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 30, 2012 at 1:53 am
ananda.murugesan (8/30/2012)
For adding new data files (ndf or mdf) in primary filegroup, application might be gets slow performance due to round robin seraching data from different datafiles.
Unlikely to be...
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 30, 2012 at 1:48 am
jpSQLDude (8/29/2012)
Therefore those TLog backups you are using are "based on" the Week 2 Full backup. Is that not correct somehow?
Nope.
Are you saying you could instead do the restore by...
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 29, 2012 at 4:44 pm
You're not trying to add a filegroup (FG4 already exists).
You're not trying to add an existing file to that new filegroup. As I already said, you cannot move files between...
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 29, 2012 at 4:25 pm
No. Log backups are not based off a full backup unless that's the first ever full backup since the DB went into full recovery. Otherwise they're based solely on 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 29, 2012 at 4:02 pm
You have to take full backups regularly. Without a full backup, the log backups are useless and that database can't be restored if necesary (and no, mirroring doesn't make backups...
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 29, 2012 at 3:15 pm
Lynn Pettis (8/29/2012)
GilaMonster (8/29/2012)
, but I would like a checkDB output without the info messages to confirm.The results are posted above in an earlier post as an attachment.
Hence why 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
August 29, 2012 at 3:12 pm
sierra4 (8/29/2012)
i have not used the dbcc repair options before, but in this regard is the experts' recommendation to use dbcc repair only as a last resort?
In most cases, yes....
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 29, 2012 at 2:30 pm
Please run the command I gave you and post the results.
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 29, 2012 at 2:10 pm
Please run the following, post the full and unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
CheckDB never guarantees to repair all errors. It's primarily (though certainly not only) for times...
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 29, 2012 at 12:49 pm
Expected behaviour
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
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 29, 2012 at 12:46 pm
Viewing 15 posts - 16,846 through 16,860 (of 49,552 total)