A quick one today, but I intend to make a series out of it, especially that we're having loads of "fun" with clustering: we encountered something in the line: IP Address 192.168.1.100 is already in use. To continue, specify a different IP address". Okay, I think this one filled the glass of my colleague, but … Continue reading SQL Server 2008 cluster installation – IP address already in use
Author: Calin OPREA
Side-by-side installation of SQL 2008 R2 and SQL Server 2005
My wife asked me to install a named instance of SQL Server 2005 Enterprise Edition x64 on top our existing SQL Server 2008 R2 Enterprise x64. HA! As a SQL Server MCT (besides the fact that I did quite a few installs in my time) I should have known better how to do it. So … Continue reading Side-by-side installation of SQL 2008 R2 and SQL Server 2005
Is the primary key always clustered in SQL Server?
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
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
Hypervisor not running and Intel not carrying
I must admit that I'm a huge fan of technology, but only from a distance. I decided to build my own mini-server at home, mainly to be able to run various things in a virtualized environment. Okay, how about Windows 2008R2 and Hyper-V? Good to go, since I have it for free as an MCT. … Continue reading Hypervisor not running and Intel not carrying
top book for free
http://www.solidq.com/ce-en/News/Pages/Data-Quality-and-Master-Data-Management-with-Microsoft-SQL-Server-2008-R2.aspx - for those who know about Solid Quality Learning, you know what you'll get. For the rest of you out there, it doesn't get any better than this.
To 32 or not to 32 on Windows 7
Finally I got 8 GB of RAM on my laptop. That's a great thing, especially that I have free licenses to pretty much whatever Microsoft has as x64, except that I'm married and this is not quite my laptop, but my wife's. If you ask anyone on the planet, you are to find out that … Continue reading To 32 or not to 32 on Windows 7
Tables and space used by them
This came up when a dear colleague of mine came to her boss and told him that even though the table she just created had only one row, "is taking up much more space than needed" – this is the actual quote. Let see what she meant. CREATE TABLE dbo.Table_1 ( large_column CHAR(8000) NULL ) … Continue reading Tables and space used by them
SQL Server installation tips… NOT
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
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
SQL-PLAY 