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 2008 DBA now
I made myself an early Christmas present: since I had a free exam voucher from Microsoft, I said to myself heck, since I'm not paying for the exam, it's kinda time to upgrade my DBA skills from 2005 to 2008. That is, 70-453.OK, I passed, but I want to tell you some impressions:tough examdifficult examnot … Continue reading SQL 2008 DBA now
talking about customer care:-)
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
SQL-PLAY 