Viewing 15 posts - 18,391 through 18,405 (of 49,552 total)
The reason being that a properly tuned SQL Server should never be using the page file at all, so unless there are other things on the server that might page...
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 29, 2012 at 2:14 am
Ident_current doesn't give you the max value in the table, it just gives you the current identity seed. That can be way different from the maximum value in the identity...
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 29, 2012 at 2:12 am
If you run checkDB with repair you will lose data from the following tables
'AllJobTitles'
'AllDocuments'
'EmailAddressVIADB'
This data loss cannot be avoided unless you can find and restore a clean...
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 29, 2012 at 2:10 am
Backups aren't integrity checks. http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%282730%29-use-BACKUP-WITH-CHECKSUM-to-replace-DBCC-CHECKDB.aspx
Still need the output I asked for...
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 28, 2012 at 5:27 pm
Jeffrey Williams 3188 (5/28/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 28, 2012 at 5:25 pm
All tables should have a clustered index unless you know better (and I don't mean having read something) Been that way since SQL 7.
For frequent inserts, make sure the clustered...
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 28, 2012 at 1:50 pm
Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
If you don't have a clean backup, fixing this will require losing data, so...
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 28, 2012 at 1:48 pm
Please, please don't trust those index suggestions. They're made on the basis of a single query and if you follow them blindly without testing or considering the rest of 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 28, 2012 at 12:49 pm
pdanes (5/28/2012)
SELECT a,b FROM (SELECT a,b,c,d FROM MyTable) AS MyView WHERE C > 10Will SQL Server not...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 28, 2012 at 10:56 am
Sorry, need to set something straight...
Indexed views can have performance benefits. Normal views cannot.
They can make queries easier to read, easier to write, but they cannot improve performance because...
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 28, 2012 at 9:18 am
The term you're looking for is 'materialise'
SQL doesn't materialise views when running queries. Views don't have execution plans and are never executed alone. As part of the early parsing phase,...
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 28, 2012 at 9:06 am
Correct. All an index (clustered or otherwise) guarantees it the logical order of the rows and pages.
If a clustered index did guarantee the physical order then there would never 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 28, 2012 at 9:01 am
pdanes (5/28/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 28, 2012 at 8:58 am
No backups? Seriously? Well can't have been a very important database then.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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 28, 2012 at 8:46 am
Trigger or SQLTrace are about the only options on SQL 2005.
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 28, 2012 at 4:21 am
Viewing 15 posts - 18,391 through 18,405 (of 49,552 total)