Database User and Programming Tips

New Preview of SQL Server Management Studio Available for Download

On September 24th Microsoft released …

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now

Microsoft announced the release or CTP 2.1 for SQL …

How Big is Your Transaction Log?

If you are not managing the transaction log space used by a database, the transaction …

SQL Server 2019 is Here

On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first …

Line Numbers in SQL Server Management Studio

Have ever tried to debug a chunk of TSQL code (like a stored procedure) and found …

Displaying and Removing Unprintable Hexadecimal Characters from SQL Server Data

There are times when you might need to look at your SQL Server data in hexadecimal …

How to Resize tempdb

When you are setting up a new SQL Server machine you need to determine how big you …

How to Remove Transparent Data Encryption From a Database

There may be a time when you want to turn off transparent data encryption on one of …

Placing a Mark in SQL Server's Transaction Log for Fall Back

How many times have you had a programmer come to you and say they want you (the DBA) to …

Using SQL Server's Default Trace to Identify Autogrow Events in tempdb

We all know that you should try to size tempdb appropriately, so it doesn’t need …

Databases with MAXSIZE Set

When a database grows to the MAXSIZE the database will not grow anymore and if someone …

Indexes That Have Not Been Used but Are Being Updated

We all know indexes are important for improving your query performance, but to store …

Tables Without Clustered Indexes

Do all of your tables contain clustered indexes? Some say every table should have a …

Why Are You Dropping and Recreating Your Indexes?

Why are you dropping and recreating your indexes, when you could just disable and then …

How to Show the Execution Plan of a Running Query

By looking at a query execution plan, you can determine which steps are used to resolve …