Tag Archives: SQL Server

SQL Server database file size

Keeping track of database size and growth is a critical part of a DBA’s job which I wrote about in an earlier blog post. But now I have improved my scripts that reveal the status of all my db files … Continue reading

Posted in Miscellany | Tagged , , , , , | Leave a comment

Coding NATO International Radiotelephony Alphabet in SQL

Joe Celko and Ken Henderson are two of my favourite SQL Gurus and I very much enjoyed reading one of Joe’s articles this morning. It made me think and playing with the code was fun. Try this on for size: … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

Selecting from a table in ALL your databases in SQL Server

I knew about the system stored procedure sp_MSforeachdb but had never really used it until recently. The books on line weren’t much help so I turned to Google and found this link. If you fully identify the database you can … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

Deciding against Code Collapse in SQL Server Management Studio 2008

A very annoying feature, which is automatically on, is the Code Collapse for editing T-SQL code.  I have complex code for which it rarely adds anything valuable. Also, I like to choose rows over on the left by the line … Continue reading

Posted in Miscellany | Tagged , , , , | 1 Comment

Identifying High Row count tables in SQL Server – New and Improved

A big part of good database maintenance is having a fair idea of where your tables are at in terms of numbers of rows and primary keys. I took a stab at writing a generic script to return all the … Continue reading

Posted in Miscellany | Tagged , , , , | 1 Comment

SQL: taking a step back

Joe Celko has written a very interesting and enjoyable article at the Simple Talk site that I recommend to SQL Server database developers anywhere. We all approach our jobs with different mindsets and it’s always a good idea to step … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

SQL Server copy_only backup and restore

Previously I wrote an article listing information on SQL Server backups. I want to expand a little on the practical use of the new and useful copy_only backup available in SQL Server 2005 and 2008. You can’t get to copy_only … Continue reading

Posted in Miscellany | Tagged , , , , | 1 Comment