|
|
-
|
|
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......
|
|
-
|
|
<p>
Everyone working in a big company knows the scenario – there are some business requirements,
which don’t fit into any existing application, so a new functionality must be developed.
Whether it’s a part of existing solution, or something completely new the cycle
is always the ......
|
|
-
|
|
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......
|
|
-
|
|
First, let me express I am really happy to post here. I was following BeyondRelational for quite some time and learned a lot (especially from T-SQL Challenges, I guess) and I have finally decided to contribute a bit. I hope I am able to deliver some quality, so any comments are welcome. So, let’s s......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|