Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
640 reads
Blog Posts
SQL Pass session evaluations
I finally got the last of my PASS Summit session evals and so, like someotherpeople, I thought I’d make them...
2010-01-13
570 reads
SQL Server Standard Volume 7 Issue 1
Kathi Kellenberger’s fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more...
2010-01-13
837 reads
Tally Table - String Cleaning
Overview
This is something that most people eventually need for reporting purposes. This function uses a Tally table to 'clean' a...
2010-01-13
4,201 reads
The Advantage of GUIDs
I never liked GUIDs, not really using them in most of my development until I had a conversation many years...
2010-01-13
687 reads
Why not play my cards?
Still no work on my laptop. It’s been over 24 hours since I left a message for the customer escalation...
2010-01-13
720 reads
Why not play my cards?
Still no work on my laptop. It’s been over 24 hours since I left a message for the customer escalation...
2010-01-13
720 reads
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-12
5,066 reads
IN vs INNER JOIN
Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...
2010-01-12
21,533 reads
Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2
There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...
2010-01-12
1,471 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers