Eduard (2/8/2010)

---

addition to the info:

- with a clustered index: correct for the data level of the pages.

however the intermediate lvl is controlled by pad index. if it's off it will...

The explanation is valid for both - Clustered and None clustered indexes.

Adi

There is no way to hide the tables from a login that belongs to systadmin server role. While I agree with the post that said that if you’ll encrypt...

The questions that you ask, show that you didn’t understand how partitioned table works. Before you create the partitioned table you have to create partitioning function and partitioning...

The fill factor has no effect at all when you insert the data. This means that if your fill factor is 90 percent, and you insert data into a...

I think that this was a very good question. I certainly learned something from it. I was sure that the answer would be 0 and was surprised that...

Setting up trace flag 1222 doesn’t cost anything and it won’t be noticed on the production environment. The same can be said about server side trace that catches the...

In that case you can use the build in tools in SQL Server to get the deadlocks's information. You can set trace flag 1222 to send information of...

I hope that I understood what you need. If you have Procedure A that activates Procedure B and you want procedure B to know the value of variables in...

You can use the SQL Server configuration manager to check which port is used by any of the instances that you have on the server. Notice that the default...

You should write rtrim(A.Last_Name) instead of A.rtrim(Last_Name).

Adi

In order to do capacity plan, it is more important to know or have an estimation about the database growth. There is a huge difference if you estimate that...

The first question that should be asked is – why do you want to shrink the log? Are you sure that it should be done. Unfortunately there are...

In your case since you need that a combination of columns will be unique, you need to do it on the table level with alter table statement:

ALTER TABLE TableName ADD...

You can check the value of @@rowcount in order to know how many records got updated. The name of the table is just like the name of the table...