Subscribe to this blog
Archives: November 2012
Tables without a Primary Key
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script slightly to get all tables without a primary key. A Primary Key constraint enforces uniqueness of a record in a table. I am extremely anal with this particular standard…
6 comments, 2,756 reads
Posted in SQL Server 365 on 30 November 2012
Tables without a Clustered Index
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the routine. Investigation led me to find that a new table had slipped through the net and been created without a clustered index. Needless to say adding a clustered…
1 comments, 370 reads
Posted in SQL Server 365 on 29 November 2012
Unused Indexes
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can cause unnecessary reads placing additional overhead on, among other things the IO subsystem. Having said that indexes that are in place but never used cause unnecessary writes during…
3 comments, 1,023 reads
Posted in SQL Server 365 on 27 November 2012
Database Mirroring Performance Counters
This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t signed up to the insider email I suggest you do as there is wealth of great information provided by the SQL Skills team on a Bi-Weekly basis.
In summary what…
0 comments, 1,329 reads
Posted in SQL Server 365 on 14 November 2012