|
|
-
|
|
I made my first attempt to install SQL Server 2012 RTM on Windows Server 8 Beta on 07.03.2012 and as you may remember from that post, it failed on .NET Framework 3.5. I tried to install it again after having enabled .NET Framework 3.5 in Server Manager and this time it worked like charm. My conclusi......
|
|
-
|
|
As SQL Server 2012 has reached RTM status on 07.03.2012, with scheduled General Availability starting from 01.04.2012 more and more training resources are available. First of all, Microsoft prepared a big online event at SQL Server 2012 Virtual Launch. You can find a lot of information - mostly ove......
|
|
-
|
|
Have you ever tried creating objects and giving them strange names? I made some experiment at one of lab servers, main focus was space (you know, the long key at the bottom of the keyboard :D). So, without further ado - the first object to be tested is a database. Run:
create database [ ]
a......
|
|
-
|
|
I was tasked with migration of two virtual machines from Virtual Server 2005 R2 to Hyper-V in order to prepare them for upgrade from SQL Server 2005 SP3 to SQL Server 2008 R2 SP1. Unfortunately, not everything went as smoothly as initally planned, mostly due to incosistencies in the environment. Fi......
|
|
-
|
|
During preparation of replication from remote site to central office I stumbled upon a need to check definitions of all views in a database. The script is simple, yet useful:
select sv.name, sc.text from sys.views sv
inner join dbo.syscomments sc on sv.object_id = sc.id
where sv.is_ms......
|
|
-
|
|
Since I had written a few posts about indexes before, I thought it would be good
to shed some light on theory behind indexes in SQL Server. It would be divided into
four parts:
Dense and sparse indexes (this post).
B-t......
|
|
-
|
|
And now for something completely different… As it is essential for a DBA to know his/her way around in server administration, let’s think of something else for a minute. If your IT department consists of more than 2 people, you most likely have experienced such situation - you try to lo......
|
|
-
|
|
It’s almost a month since
my post on index maintenance based on fragmentation, in which I attempted
to show what can be done using simple script and some DMVs. There was some
discussion on LinkedIn group SQLDBA about it and I would refer to it with
......
|
|
-
|
|
Ever wondered how many SQL Server instances are there in your network? Or maybe you wanted to check a settings or run a script on all of them? Of course you can use Registered Servers functionality and run a query on all servers in a group, but this can save you the pain of adding all servers one by......
|
|
-
|
|
After few posts devoted to indexes it’s time to look at something else. Let’s see some common problems with users and logins, and methods of overcoming them. These are the basic and most frequently occuring ones. Unable to connect to server - cannot open user default database (error 4064). ......
|
|