#tsql

Creating a GUID for each GUID

Solving transaction log being full due to replication

Why does our query run fast in Sql Server management studio but slow in our application?

How to write if statements in SQL Server

How to quickly get the VLF count for a database in SQL Server

Review the solution and discussion in the video The transaction log for database 'DB' is full due to 'REPLICATION'. We do not want to develop the habit of micro-managing transaction logs, so we should

Check out the solution in the video TSQL: DBCC SHRINKFILE Part I. Depending on the environment and setup, we may be required to shrink a file in SQL Server (such as a log file). Lower environments (generally,

In the video T-SQL: How To Use If Statements, we look at how to use IF statements with T-SQL. These can be an alternative to CASE WHEN statements in some situations (see video T-SQL: How To Use CASE WHEN

Check out the solution in the video TSQL: Find Values In One Table Not In Another Table. In the example, we see how to identify data in one table that does not exist in another table. This may be extremely

Check out the solution in the video TSQL: DBCC OPENTRAN. In honor of one of my favorite DBAs, we look at using the DBCC OPENTRAN. We simulate an example with this technique and show what we see and what

Check out the solution in the video (ETL) Violation of PRIMARY KEY constraint 'PK_Constraint' - Different Source and Destination Keys. One pattern I've seen quite often is developers changing primary keys

Check out the solution in the video Cannot find the object sp_Name because it does not exist or you do not have permission (naming). While this error should rarely appear, it serves as a reminder to avoid

Check out the discussion in the video . A colleague once shared a story of a company that dismissed a developer because the developer had run a query counting records without using NOLOCK. The OLPT environment

We look at median overall and with T-SQL in What Is Median? Why Use Median?. As you can see, we see one way in which we can obtain the median using T-SQL. We also notice a comparison of average versus

Check out the solution in the video TSQL: Quickly Obtain Log Space Used (DBCC SQLPERF). Prevention beats cure, but this is a great command for those situations we haven't had time to look at and need to

Check out the solution in the video TSQL: Get Maximum Length of Every Column On A Table. This can be helpful if we require strict limits in downstream tables, assuming that we have a data flow where we

Check out the solution in the video TSQL: Get Last Restore Date. I've faced situations where backups were failing, but we didn't have any warnings, so running this query and organizing the output by latest

Check out the discussion about table lock hints in the video TSQL: TABLOCK vs. TABLOCKX (vs. Normal Process). We look at the actual results of using the different hints and consider whether we'd want to

Check out the solution in the video (ETL) Violation of PRIMARY KEY constraint 'PK_Constraint' - Different Source and Destination Keys. While it's rare to see, from time to time, I do see a design where

Review the solution and discussion in the video The transaction log for database 'DB' is full due to 'REPLICATION'. We do not want to develop the habit of micro-managing transaction logs, so we should