|
|
-
|
|
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......
|
|
-
|
|
In previous posts (here and here), I described the methods I use to monitor and maintain indexes. This is a next chapter – let’s try to find candidates for new indexes or hints for extending existing ones. Of course, there are few methods to achieve this goal: Find a candidate query and analyze ......
|
|
-
|
|
In my previous post regarding indexes I presented a method of inspecting all indexes in a database using sys.dm_db_index_physical_stats. Let us develop it a little bit more. Suppose you want to loop through all indexes and rebuild those which fragmentation exceeds 30 percent, and reorganize those w......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|
-
|
|
Collation can be a little bit tricky sometimes. Changing it is not a problem (theoretically) if you want to do it on a column, table or database level – you have to issue respectful ALTER statement and that’s it.
Another thing is changing default server collation. You set it during inst......
|
|
-
|
|
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......
|
|