How Can I Tell if SQL Agent is Running via SQL?
Introduction
Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my...
2010-05-04
400 reads
What is a Good Way to Get the SQL Server Log Directory?
Introduction
Today’s post is going to be a quick one to get back in the saddle again. I have been on...
2010-05-03
405 reads
What is a Good Way to Quickly Disable SQL Agent Job Schedules?
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
442 reads
Whats a Good Rule for Max Degree of Parallelism?
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
539 reads
How Do I Find SSIS Packages that Exist in Multiple Folders?
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
295 reads
How Do I Kill All Sessions from a Windows Group?
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
489 reads
T-SQL Tuesday #005 – Self Service Performance Information
Introduction
Today I am taking a little detour from the scripts I have been posting to take part in “T-SQL Tuesday...
2010-04-13
426 reads
How Can I Tell if a Windows Login has Rights to My Server?
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
315 reads
Script to Create A TempDB File Per Processor
Introduction
Trying to keep the streak alive so here is my 5th blog post in 5 days. This one is another...
2010-04-09
2,022 reads
What Do I Need to Do After Moving a Database to SQL 2005/2008?
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
383 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
SQL Server 2025
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Forums
SQL Clustered Resource in online pending for about 3-5 mins before coming online
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
SQL Query to use in MS SSRS server to give you your report structure.
Code that can be used in order to create dashboard or SSRS report on...
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers