Viewing 15 posts - 9,076 through 9,090 (of 49,552 total)
Try removing the interim storage. Instead of inserting into temp table then reading from temp table, do the grouping/joining directly.
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 13, 2014 at 6:47 am
Dropping it, not much. Recreating it however will require table locks unless you have Enterprise edition and specify ONLINE for the index creation.
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 13, 2014 at 5:40 am
There are three blob columns in that table (varchar(max)/nvarchar(max)), they can be up to 2GB each. Gut feel, that's where the space is going.
Check the Datalength() of each of those...
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 13, 2014 at 4:29 am
Is it a heap (no clustered index)?
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 13, 2014 at 4:18 am
There's nothing in an execution plan (estimated or actual) that reflects the time required to execute it.
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 13, 2014 at 2:55 am
Change the EXEC to a print and examine the generated statement. That usually helps find errors in dynamic SQL.
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 13, 2014 at 2:10 am
Problem is, without the execution plan we're doing nothing more than making guesses.
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 12, 2014 at 9:32 am
Maybe start with this:
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 12, 2014 at 9:00 am
Execution plan please (actual, not estimated)
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 12, 2014 at 8:45 am
Nothing whatsoever to do with compatibility level.
You cannot restore down-version. A SQL 2012 database (a database attached to a 2012 instance) cannot be restored to anything other than SQL Server...
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 12, 2014 at 8:33 am
Table definitions, index definitions and execution plan 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
May 12, 2014 at 8:19 am
Leave it running. No point in reinitialising unless something breaks.
You can (and probably should) leave your nightly full backups as normal full backups (without the copy only), especially if you...
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 12, 2014 at 6:48 am
Or [ url ] http://www.google.com [ /url ] (remove spaces)
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 12, 2014 at 6:09 am
Koen Verbeeck (5/12/2014)
GilaMonster (5/12/2014)
*sigh* http://www.sqlservercentral.com/Forums/FindPost1569693.aspxWhy do some people bother to post "advice" (and apparently incorrect) on an almost 4 year old topic?
Advertisement for their database 'recovery' product. Look at where...
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 12, 2014 at 5:07 am
nm
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 12, 2014 at 5:04 am
Viewing 15 posts - 9,076 through 9,090 (of 49,552 total)