#sqlserver

How to solve the transaction log growing too big in SQL Server

How can we get the median absolute deviation in SQL Server?

Should we use triggers in SQL Server?

How to address the SOS SCHEDULER YIELD wait in SQL Server

What do we do if an object already exists when we try to create an object in SQL Server?

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

Log growth when changing from NULL to NOT NULL

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

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

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

In the following video of T-SQL: How To Use FOR XML PATH - 3 Output Formats, we look at 3 popular XML formats that involve SQL Server and returning data. While we can output XML in other formats, these

One alternative to the common technique of a blank space is answered in the video, T-SQL: How To Use the SPACE Function. This function can be useful in situations where we may want to dynamically generate

Check out the solution in the video T-SQL: How To Audit Login Failures for checking what users have attempted to login and failed. This may be a concern relative to the architecture of our setup and if

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

Getting more PostgreSQL in your life:

Is it always a good idea to use the latest software updates or features in an application? Check out the discussion in the video Should We Use the Latest Features/Updates In Development. As we learn, this

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