Category: Uncategorized

Is the primary key always clustered in SQL Server?

Posted on by Calin OPREA

As I was playing in SSMS (SQL Server Management Studio), I created a table using the plain-old T-SQL, and then I decided to create a primary key, the "wizard" way, so to speak. Let's have a repro here: CREATE TABLE [dbo].[Employees] ( [empID] [int] NOT NULL , [firstname] [varchar](30) NOT NULL , [lastname] [varchar](30) NOT … Continue reading Is the primary key always clustered in SQL Server? →

How to Disable NetBIOS on the SQL Server Box

Posted on by Calin OPREA

Today I'll post a quick one, since a simple Google search (yeah, Bing, sorry) did not yield too many useful results. Just as a quick note, make sure you have a chat with your sys admins; they can tell you whether the protocols are needed or not anymore. Okay, on with the tip: Go to … Continue reading How to Disable NetBIOS on the SQL Server Box →

SQL Server installation tips… NOT

Posted on by Calin OPREA

I have to admit that I shamelessly "steal" any info available on the net when it comes to SQL Server. Just to give you a quick example: Brent Ozar and Jonathan Kehayas both have some neat articles about installing SQL Server. Of course, I use the Next > Next > Finish feature, just as anybody … Continue reading SQL Server installation tips… NOT →

Strange error in SQL Server 2005… when aplying SP3

Posted on by Calin OPREA

Before going any further, let's get this straight: I'm not sure whether it's a bug or not, whether can be reproduced or not, but I care to have this documented.A machine was re-installed (Win 2003, SQL 2005), having 3 named instances (no default, just named instances). SP3 was applied... and nothing was like before:-). You … Continue reading Strange error in SQL Server 2005… when aplying SP3 →

talking about customer care:-)

Posted on by Calin OPREA

I just received (as an MCT I get all kinds of goodies) a free licence of PerfectDisk 11. So far, so good... but: "the official release isn't until tomorow, but I wanted to make sure our MCTs had it in their hands a little early".This is what I call "yes, they care about me".best regards,io

Simple lesson learned

Posted on by Calin OPREA

KISS (Keep it stupid simple) :-)"System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation." - that was the wife having an issue.I told her: okay, do you have SQLNCLI? Obviously, she had it installed.Me: well then, check here:http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspxhttp://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspxIt turned out that SQL Browser service was not started. Again, KISS or be KISS-ed.