Viewing 15 posts - 676 through 690 (of 1,478 total)
The explanation is valid for both - Clustered and None clustered indexes.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2010 at 4:38 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2010 at 4:02 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2010 at 3:26 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2010 at 3:14 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 3, 2010 at 1:20 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 2, 2010 at 7:02 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 2, 2010 at 5:42 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 2, 2010 at 4:17 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 2, 2010 at 4:07 am
You should write rtrim(A.Last_Name) instead of A.rtrim(Last_Name).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 1, 2010 at 6:45 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 1, 2010 at 4:25 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 1, 2010 at 3:40 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2010 at 11:15 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2010 at 10:26 am
You could do it that way:
IF NOT EXISTS (SELECT * FROM usp_tblDivisionINSERT WHERE DivisionAbbr = @DivisionAbbr AND DivisionName = @ DivisionName)
INSERT INTO…
You’ll might have to modify it to...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2010 at 10:20 am
Viewing 15 posts - 676 through 690 (of 1,478 total)