Viewing 15 posts - 14,941 through 14,955 (of 49,552 total)
WolfgangE (1/7/2013)
Maybe - and I really mean MAYBE - you can solve the problem by rebuilding the indexe mentioned in the error message.
Dropping and recreating should solve this particular corruption.
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
January 7, 2013 at 12:44 pm
It would kinda help if you show us the code that doesn't work...
What error does it give? If it's a permissions problem, the error is very specific.
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
January 7, 2013 at 10:35 am
Just run exactly what the error says - DBCC UPDATEUSAGE. Doesn't usually take that long
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
January 7, 2013 at 10:33 am
Kishore-132325 (1/7/2013)
but UPDATE STATISTICS with FULL SCAN will scan for the entire table everytime
Yup, that's what you need for accurate stats. You can run full scans on more important tables...
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
January 7, 2013 at 10:31 am
ben.brugman (1/7/2013)
Something has to do the disk accesses.
The storage engine
And because the physical reads on disk is often the determining factor for throughput, this must be somehow included in 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
January 7, 2013 at 9:10 am
Knowledge Hunter (1/7/2013)
But since the script is running fine in production why is creating such a mess in Development?
Err... *rolls dice*
More data
Less memory
Older stats
Different recovery model
etc
etc
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
January 7, 2013 at 9:01 am
Terrie (1/7/2013)
Thanks for all your replies. One shrinks a database to recover space. What does shrink with notruncate accomplish?
It does exactly the same as shrink does, just without...
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
January 7, 2013 at 9:00 am
The script you've posted doesn't even parse.
Msg 102, Level 15, State 1, Line 37
Incorrect syntax near ','.
Msg 134, Level 15, State 1, Line 76
The variable name '@THIS_CALENDAR_YR_START_DT' has already been...
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
January 7, 2013 at 8:46 am
Don't use sp_updatestats, it does sampled updates (unless you tell it otherwise). If you are doing a maint plan to manage stats, run the stats updates with fullscan.
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
January 7, 2013 at 8:14 am
ben.brugman (1/7/2013)
Or is the selection of the C done after the pages have been read in to memory as a filter?
All processing is done in memory, regardless of whether it's...
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
January 7, 2013 at 8:11 am
ben.brugman (1/7/2013)
Does this read all rows from A with a 6 in it. So RID lookup of all A = 6 rows?
No. It reads all rows from the index 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
January 7, 2013 at 8:03 am
Don't set it to 1 unless you want to hobble your server. SQL uses parallelism to run larger queries fast. If you would prefer that larger queries run significantly slower...
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
January 7, 2013 at 7:58 am
craig.dixon (1/7/2013)
Im just wondering though, if I was to use simple recovery mode and differential backups, would the differential backups not be as large as my transaction logs?
Maybe, maybe...
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
January 7, 2013 at 5:28 am
craig.dixon (1/7/2013)
Would it be advised to take them more regularly?
Yes. Daily log backups mean that you can lose up to 24 hours data in the case of a disaster....
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
January 7, 2013 at 3:46 am
Please read through this - Managing Transaction Logs[/url]
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
January 7, 2013 at 3:22 am
Viewing 15 posts - 14,941 through 14,955 (of 49,552 total)