Viewing 15 posts - 346 through 360 (of 1,479 total)
Each primary key and each unique constraints are implemented with unique index. This is done for performance. Imagine that you have a table that has more then 10000000...
--------------------------------------------------------------
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/
March 16, 2012 at 11:30 am
baabhu (3/16/2012)
--------------------------------------------------------------
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/
March 16, 2012 at 11:13 am
From what I see each record is unique, which brings up the question – how do you decide which records are unique and which records are not unique?
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/
March 6, 2012 at 7:23 am
You can use profiler or server side trace to get the data when it runs.
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/
March 5, 2012 at 1:32 am
You can use the default trace to find out about file growth. Bellow there is a code, that I've once found on the net (sorry, I just don't remember...
--------------------------------------------------------------
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/
March 5, 2012 at 1:28 am
Money data type is working with 4 digits after the decimal point. If this is not enough for you, you should use a different data type.
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 28, 2012 at 10:14 am
You can have join clause on an update statement. BOL (Books On Line) has an article about it with example. Look for the article that is called "Changing...
--------------------------------------------------------------
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 28, 2012 at 10:09 am
I have to admit that I don’t understand why both queries use the same path in nodes method, but different path in value method. I would have thought 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 28, 2012 at 6:32 am
Users that don't have permissions to work with the view, won't be able to see the columns from sys.all_collumns, but if you can see it in sys.all_objects, you do have...
--------------------------------------------------------------
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 27, 2012 at 11:50 am
svakka (2/27/2012)
Thank you all!
Do you know what went wrong and why you didn't get the expected results? In my opinion your query should have shown the columns of 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 27, 2012 at 10:56 am
Most chances are that the line and a.name like '%_vv%' is the one that filters your results. What is the name of the view that you are trying 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/
February 27, 2012 at 8:41 am
I never use percentage for autogrow. I only use whole numbers. Most of the times I use something between 200MB and 500MB, depending on what I think...
--------------------------------------------------------------
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 27, 2012 at 8:36 am
One way of doing it is to use a recursive CTE that creates the list of dates and use the CTE in select into statement. Here is an example:
declare...
--------------------------------------------------------------
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 27, 2012 at 8:05 am
The quoted_identifier set option of a procedure is set during the time that it is created and not according to the session that uses the procedure. If what you...
--------------------------------------------------------------
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 22, 2012 at 11:03 am
g.korot (2/22/2012)
Hi AllMy client want to encrypt the database backup set. Is there any possibility to do it? I'm not speaking about TDE option.
Thanks.
Any reason that TDE is not...
--------------------------------------------------------------
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 22, 2012 at 10:52 am
Viewing 15 posts - 346 through 360 (of 1,479 total)