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
410 reads
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
410 reads
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
411 reads
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
449 reads
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
543 reads
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
297 reads
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
503 reads
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
430 reads
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
316 reads
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,310 reads
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
385 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;