Viewing 15 posts - 8,971 through 8,985 (of 49,552 total)
Wait, or drop it and restore from your last backups.
Or maybe call MS support and get someone on site if your agreements with them allow. Will cost. They might 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
May 22, 2014 at 2:20 am
It'll be removed when ghost cleanup runs. It's done this way as an optimisation, SQL is cleaning up space properly, no it will not slow down inserts.
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 22, 2014 at 2:18 am
Why are you casting to Varchar? It's just going to force SQL to convert back to date, that's expensive conversions.
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 21, 2014 at 1:31 pm
GilaMonster (5/21/2014)
Is the maintenance plan doing compressed backups?Is the maintenance plan doing differential backups?
Is the maintenance plan striping the backup over multiple files?
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 21, 2014 at 7:24 am
Matt Crowley (5/21/2014)
Indexes only tend to kick in at about 4% selectivity, if I recall.
~0.5%, unless the index is covering (which a clustered index always is), in which case anything...
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 21, 2014 at 7:23 am
Are you explicitly inserting NEWID() into the table, or are you allowing the default to be used?
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 21, 2014 at 7:16 am
Post your questions in the relevant administration forum. PBM is a nice feature, but it's too specific to have a forum just for it. Hell, we've got way too many...
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 21, 2014 at 6:53 am
Nothing will happen to the existing values. If the table is fragmented before you change the default, rebuild your indexes.
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 21, 2014 at 6:51 am
Is the maintenance plan doing compressed backups?
Is the maintenance plan doing differential backups?
Is the maintenance plan striping the backup over multiple files?
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 21, 2014 at 6:37 am
WayneS (5/21/2014)
TomThomson (5/20/2014)
Steve Jones - SSC Editor (5/20/2014)
Up in the air on this whole thing, but I'll admit it's tempting, depending on price....
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 21, 2014 at 6:32 am
It's perfectly safe to kill anything (well, unless your developers have written procedures which don't use transactions, but that's not a SQL internals problem)
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 21, 2014 at 6:11 am
That's not a quick explanation, that's a chapter. Specifically, it's a chapter in SQL Server 2005 Practical Troubleshooting (http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743/)
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 21, 2014 at 6:09 am
No.
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 21, 2014 at 5:34 am
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 21, 2014 at 4:58 am
Oracle_91 (5/21/2014)
What can happen if CHECKDB is killed in the middle of process?
The CheckDB operation stops.
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 21, 2014 at 4:57 am
Viewing 15 posts - 8,971 through 8,985 (of 49,552 total)