#sqlserver

What happens when we run into the problem where we need to make changes to a column in a SQL database after the creation (especially when it has values in it)? Check out the solution in the video Changing

What happens when we run into the problem where the query executes quickly in SSMS, but runs slow in the application? Check out the solution in the video TSQL: Fast In SSMS, Slow In the Application Part

What happens when we run into the problem where we're not sure whether we should store derived data? Check out the solution in the video To Store Or Not Store Derived Data. If this question arises, generally

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 OLTP environment

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

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: 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

What happens when we run into the situation where we want or need to change a primary key? Check out the solution in the video T-SQL: Changing A Primary Key - What We Should Consider. As we can see, 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

What if we want to get the last row of data in a table? Check out the answer in the video TSQL: Get Last Row of Data In A Table. As you can see, we get the final row of data in our example table by using

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

What happens when we run into the problem where we attempt to make changes, but our source code differs from our live code? Check out the solution in the video Pre-update schema check failed: the schema

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,

Every now and then we have to create a pivot table from a dat set. In the video TSQL: How To Automate A Two-To-Many-Column Pivot Table, we look at a technique to automate this process - as pivot tables

What happens when we try to drop a table that is being referenced by a view (it's also possible that we get an error if other references exist)? Check out the solution in the video TSQL: "Cannot DROP TABLE

What happens when we run into the problem where a table already exists in our database when we try to create one? Check out the solution in the video There is already an object named '' in the database

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: "String or Binary Data Would Be Truncated" Quick Solution. As you can see, we learn one possible solution to the string or binary data when the data involve