Tag Archives: WTF

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