#sqlserver

Check out the solution in the video Error: Incorrect syntax near the keyword 'SCHEMA'. and what we do to solve this. This error may arise relative to the other T-SQL around it. Also, keep in mind that

Check out the discussion in the video TSQL: Altering Column To NOT NULL Causes Log Growth Spike. In this situation, we see that a change needs to made to a column to set a default to NOT NULL from NULL.

Check out the solution in the video TSQL: Compare Tables. As you can see, we compare data in the two tables to identify where rows of data don't match (or don't exist). There are other techniques we can

Check out the demo and discussion in the video TSQL: ARITHABORT ON and Query Speed. While it may seem like a harmless setting, this setting may affect our queries. We should be aware of how the application

Check out the solution in the video Different Designs For Reporting Data. Remember that new development videos are posted on Mondays with other videos possibly being posted other days of the week. We look

Check out the solution in the video Schema validation failed: 'ISJSON' is not a recognized built-in function name. First, note the version of Microsoft SQL Server that we're using. This is key because

Check out the solution in the video TSQL: How To Get the Outliers In A Data Set. We often hear about generalizations and exceptions when discussing data (outside of statistics, these are common terms).

Check out the solution in the video TSQL: DBCC CHECKDB Part I. In part 1 of this series, we look at the basics of using DBCC CHECKDB. Alternatives may be more granular and more appropriate in some situations.

Check out the solution in the video Wait Types Part IX: SOS_SCHEDULER_YIELD. As you watch the video, pay close attention to where I tend to see this wait type and how I approach solving this. We also discuss

Check out the solution in the video TSQL: Get Number of VLFs. We see how to get the number of VLFs in a database within SQL Server. This is worth considering from time to time, as it may indicate that

Check out the solution in the video Alerting Best Practices. We should consider the story of the Boy Who Cried Wolf: false alerts or annoying alerts train people to ignore them. The initial best practice

Check out the discussion in the video TSQL: What Are the Disadvantages of Using Triggers. One of the troubles with triggers involves troubleshooting - pay attention to the point made in the video. In addition,

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