2012-06-07
1,999 reads
Seth Delconte
2012-03-26
2,179 reads
Verify SQL Server Login and Login Settings
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,676 reads
Randomizing Result Sets with NEWID
Seth Delconte brings us a technique to solve a common request. Using the NEWID function to return a random record from a result set.
2010-03-01
6,956 reads
Get Rid of Duplicates!
This article contains instructions on how to use some of my favorite methods to remove duplicate fields from a table.
2009-11-30
13,450 reads
Blogs
What Agent Jobs are Running??
By gbargsley
Do you run SQL Agent Jobs in your environment? Do you know what is...
Unboxing SQL Clone 2020 for a PoC
By Steve Jones
When I got a new machine, I had SQL Clone on my old machine,...
Daily Coping 4 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Extended Events
I have set up an extended event to capture the queries users may be...
Script logins and all permissions: no longer supported in SSMS generate script?
Okay, maybe I've just gone crazy but I was certain it used to be...
Recursive Select runs slow
Hello, I have a recursive Select that runs ultra slow. My test table has...
Ask SSC