Viewing 15 posts - 451 through 465 (of 1,478 total)
I think that this is because you are using the option KEY_SOURCE. If you use this option, then you get the same key. The certificates on each database...
--------------------------------------------------------------
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/
August 31, 2011 at 8:48 am
Pleas fallow the URL at my signature to see how to post questions. See the code and the remarks in the code for an answer for your question.
--Creating 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/
August 29, 2011 at 3:53 am
You can specify your own order. For example in the fallowing query you’ll see all the sales from the U.S first and after those records you’ll see all 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/
August 29, 2011 at 3:40 am
First of all thank you very much for the detailed post. I appreciate the time and effort that you spent in helping me understand your solution. Your explanation...
--------------------------------------------------------------
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/
August 25, 2011 at 7:30 am
This is very impressive, but there is one thing that I don’t understand. I would expect that the second nodes operator will get the path Product/Authors/Author because 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/
August 25, 2011 at 4:41 am
http://www.microsoft.com/download/en/details.aspx?id=26727
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/
August 25, 2011 at 4:03 am
Adi Cohn-120898 (8/23/2011)
You can use the substring function to do that. You can find more details about this function in BOL (Books On Line).Adi
Sorry, didn't notice that it...
--------------------------------------------------------------
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/
August 24, 2011 at 12:51 am
You can use the substring function to do that. You can find more details about this function in BOL (Books On Line).
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/
August 23, 2011 at 2:18 am
Backup log with truncate_only is not supported with SQL Server 2008. I have to say that I wouldn’t run this script on other versions that still support the truncate_only...
--------------------------------------------------------------
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/
August 22, 2011 at 9:59 am
ChrisM@Work (8/22/2011)
Adi Cohn-120898 (8/22/2011)
The book is wrong...
Quote from BOL, SQL server 2k8:
nchar [ ( n ) ]
Fixed-length Unicode character data of n characters. n must be a value from...
--------------------------------------------------------------
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/
August 22, 2011 at 4:43 am
The book is wrong. The number that is used when you declare a variable or define a column that is a Unicode, specifies the number of characters and 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/
August 22, 2011 at 4:32 am
Jayanth_Kurup (8/22/2011)
Execute the rollback statement a few times until you get a messageThe ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
Actually this will produce 2 errors. When...
--------------------------------------------------------------
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/
August 22, 2011 at 4:21 am
You didn’t specify what you are trying to do, so maybe there is a better way. In any case if you’ll run what ever you need to run...
--------------------------------------------------------------
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/
July 28, 2011 at 9:19 am
It seems that you need to learn more about log management, recovery models and log backups. After you’ll understand those topics, you’ll be able to configure and manage...
--------------------------------------------------------------
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/
July 25, 2011 at 4:01 am
The variables that are declared outside of the dynamic SQL are not recognized inside the dynamic SQL, so when you run the dynamic SQL and reference those variables, you get...
--------------------------------------------------------------
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/
July 22, 2011 at 8:48 am
Viewing 15 posts - 451 through 465 (of 1,478 total)