Tag Archives: WTF

Lazy programming from MS? Surely not…

Another vignette from SQL Server 2005 Management Studio showing a possible lack of attention to detail somewhere… (Speaking of lack of attention to detail, I can’t remember which version of the SSMS had this bug.  I suspect it was RTM, … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , , | Leave a comment

T-SQL Tuesday #13 – Business Briefs

The final T-SQL Tuesday of 2010 is hosted by Steve “SQL Server Central” Jones, and is on the loosely-defined subject of “What issues have you had in interacting with the business to get your job done?” As some of you … Continue reading

Posted in Uncategorized | Tagged , , | 2 Comments

CSV with added ,

What’s the Definition of CSV? A simple question, I would have thought, and one that’s answered reasonably comprehensively elsewhere.  However, I note that there appears to be no “official” format definition, but only a de facto standard. Consider the following: … Continue reading

Posted in Uncategorized | Tagged , , , | 4 Comments

Unable to launch Activity Monitor.

It all started so innocently. A SQL Server 2005 installation.  An installation of SQL Workbench, sorry, “Microsoft SQL Server Management Studio.”  And a need to find out what’s going on.  Click, click, click – Activity Monitor.  Double-click.  Uh-oh. (Incidentally, why … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , | 2 Comments

Database Design Horrors

Jen McCown, of the MidnightDBA (twitter / blog) recently posted a couple of articles about the basics of Database Design.  As she was writing the second of these posts, she put out a Tweet (well, two tweets) saying: Help me … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , , | 13 Comments

Inappropriate Indexes, and Programming Your Way Around Them

(This article should probably be called “Inappropriate Primary Keys…”, but that wouldn’t have the assonance…) Seeing various questions on AskSSC about using GUIDs as indexes, including GUIDs which are actually stored in Varchar(255) fields, reminded me of this little vignette … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , , , | Leave a comment

Troubleshooting 101 – Services failed to start

One that happened a while ago, as I’m a bit swamped with reality at the moment… So I got into work one Monday morning to be greeted by one of the tech support team saying “your database server isn’t working”. … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged | Leave a comment