Thank you for the index, DBA! (you saved my system!)

RIL_button( “http://sqlconcept.com/2011/07/05/thank-you-for-the-index-dba-you-saved-my-system/”, “Thank you for the index, DBA! (you saved my system!)” );

It happens often. Too often, maybe. A DBA goes to a company, looks at the system, which is running slow and and the business people are losing faith in, and the DBA creates an index or two and the system starts performing 50

Continue reading [...] Thank you for the index, DBA! (you saved my system!) [...]

July 5th, 2011 | Tags: , , , , , , , , | Category: CPU, Disk System, Indexing, IO, Memory, Some thoughts, SQL Server Architecture, SQL Server metadata, SQL Server Wishlist, SQL Services | Comments are closed
Work on itWell, now...OKGoodGood job! (4 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

The SQL Server metadata concept

RIL_button( “http://sqlconcept.com/2011/04/27/the-sql-server-metadata-concept/”, “The SQL Server metadata concept” );

… the data describing the data describing the data described described data described by data… (and so on)

 

The charm of SQL Server is that it comes with a good set of metadata. Even in SQL 2000 there were plenty of system objects containing data about the instance and

Continue reading [...] The SQL Server metadata concept [...]

April 27th, 2011 | Tags: , , , , , , , , , | Category: SQL Server Architecture, SQL Server metadata | Comments are closed
Work on itWell, now...OKGoodGood job! (1 votes, average: 1.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...