I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the job associated with the maintenance plan. […]
Tag: Scripts
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have a better understanding of it. What […]
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts you are working on, and possibly […]
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the database was used. For the first […]
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen for a number of reasons. One […]
SQL Bitwise Operations
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one data value? Have you ever had […]
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs that could help you in the […]
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able to take a delimited string and […]
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way to find out that information from a tSQL command? On occasion it would be nice […]