Viewing 15 posts - 31,411 through 31,425 (of 49,552 total)
Open a query window and write a select statement that queries the sys.databases view.
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 5, 2010 at 11:08 am
What's the exact status of the database? (query sys.databases)
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 5, 2010 at 10:55 am
satish.adlurmohan (8/5/2010)
Our application database's transaction logs grow more than what the actual data is imported.
That's quite normal. Log records have headers and other information in them about the transaction as...
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 5, 2010 at 10:15 am
Ok, just copy out, plain text, what pieces I said and what your replies were, wrap your replies in [ b ] and [ /b ] (or highlight and click...
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 5, 2010 at 10:08 am
Yeah, you missed something. That's not the line throwing the error. This one is:
SET @cmd = 'ALTER INDEX ALL ON ' + @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 5, 2010 at 10:02 am
mrpush (8/5/2010)
Gail, how did you reply to specific questions with them individually quoted in there?
By adding a [ /quote] at the end of the chunk I'm commenting on, adding my...
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 5, 2010 at 10:01 am
Reorganise shuffles the index pages into order. Rebuild drops the index and recreates it with the pages in order. Why would you want to do both?
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 5, 2010 at 9:59 am
Adiga (8/5/2010)
I don't see the word CASE in the entire code. Am I missing something here?
He's probably got a table called 'Case'
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 5, 2010 at 8:11 am
Stefan Krzywicki (8/5/2010)
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 5, 2010 at 8:04 am
Grant Fritchey (8/5/2010)
Praveen Goud Kotha (8/5/2010)
especially for Fritchey..
If any other reasons for "Reasons for difference in execution plans"..
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 5, 2010 at 8:00 am
Try putting [] around the table name, in case there are spaces, prohibited characters or reserved words
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 5, 2010 at 7:24 am
If he's anything like the SOX auditors I used to work with, he'll be asking for proof of everything you said - backup histories, security permissions, sign-offs, 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
August 5, 2010 at 6:38 am
Praveen Goud Kotha (8/5/2010)
just confirm me that whether the difference is in no. of parameters or different input data for the procedure..
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 5, 2010 at 6:36 am
If you're rebuilding indexes you don't need to reorganise as well.
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 5, 2010 at 5:50 am
Drop the redundant indexes.
Do a once-off shrink, shrink the database to a reasonable size (leave enough free space for index rebuilds and a couple months of growth).
Ensure there's a...
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 5, 2010 at 5:45 am
Viewing 15 posts - 31,411 through 31,425 (of 49,552 total)