Viewing 15 posts - 18,421 through 18,435 (of 49,552 total)
Please don't post multiple threads for the same problem.
No replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1306941-266-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 26, 2012 at 8:01 am
You could wait forever, nothing will change. You need to restore one or more log backups.
Did you do a full restore or try a page restore? 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 26, 2012 at 7:47 am
Gullimeel (5/26/2012)
As mentioned by Paul earlier alternate for these nonclustered index scan(full) is Filtered indexes
Or a unfiltered nonclustered index that supports the query. Or a change to the query...
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 26, 2012 at 6:47 am
Gullimeel (5/26/2012)
GilaMonster (5/22/2012)
--------------------------------------------------------------------------------
andersg98 (5/22/2012)
--------------------------------------------------------------------------------
Yes. The concept is called 'partition elimination'. Especially when scanning the table for a date range, the optimizer will realize it only has to scan the current...
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 26, 2012 at 5:29 am
Hinting or forcing should be the absolute last resort when you know there is no other way and you know exactly what you are doing.
Please post query, table definitions, 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 26, 2012 at 5:21 am
No backup? Seriously why the hell not?
Your database is corrupt, it may be possible to get it back with some data loss, it may not. You need to 'hack' 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 26, 2012 at 5:19 am
Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 26, 2012 at 5:08 am
rajemessage (5/26/2012)
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 26, 2012 at 5:07 am
SELECT Original_Login()
Just in case there's any impersonation going on.
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 25, 2012 at 11:15 am
Steve Jones - SSC Editor (5/25/2012)
GilaMonster (5/25/2012)
Home finally. Lovely trip, but very glad to be back.Glad you had a good time and made it back. Everything OK, I assume.
Yup.
My lounge...
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 25, 2012 at 9:50 am
Home finally. Lovely trip, but very glad to be back.
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 25, 2012 at 9:24 am
Tried google? I know the answers to at least 2 of those can be easily found.
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 25, 2012 at 5:37 am
Historical trends and extrapolation can get you a reasonable idea. Otherwise chat with business and see how they see business expanding over time and use that along with your knowledge...
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 25, 2012 at 5:35 am
ben.brugman (5/25/2012)
As for the other questions, can the pages read from disk be 'converted' into reads and seeks.
No. A page read from disk is just a page read from...
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 25, 2012 at 5:31 am
Only running processes use CPU. Processes that are sleeping are doing nothing, processes that are suspended are waiting for resources and neither will use any CPU.
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 25, 2012 at 5:27 am
Viewing 15 posts - 18,421 through 18,435 (of 49,552 total)