2012-06-07
2,000 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,677 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,960 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,455 reads
Blogs
Using Write-Debug
By Steve Jones
I wrote a post about PoSh output recently, noting that in general we ought...
T-SQL Tuesday Retrospective #002: A Puzzling Situation
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...
Daily Coping 28 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Index question
We have some indexes we have changed over the last few years to address...
Getting the top unique value by group
Alright, so I've been banging my head against the wall for a bit on...
Ask SSC