Viewing 15 posts - 121 through 135 (of 1,479 total)
I think that you are misusing the XML. You have the same elements' names for different information. The only way to know what is the real information is...
--------------------------------------------------------------
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/
September 1, 2014 at 5:06 am
There are 2 problems with your code. You cannot concat datetime data type with varchar data type, so you need to convert your parameters to varchar data type (using...
--------------------------------------------------------------
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/
September 1, 2014 at 4:56 am
You can use the function rank and compare its outcome to the function row_number. Here is an example based on your script:
CREATE TABLE #tblTasks
...
--------------------------------------------------------------
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, 2014 at 3:17 am
It does look like blocking issue. When you set the database to a single user mode, the process that was blocking you, was killed and the resources that 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/
August 24, 2014 at 1:12 am
You need to add one more apostrophe. See my example bellow:
declare @Name varchar(10)
set @Name = 'O''braien'
SELECT CASE WHEN LEFT(@Name,2) = 'O''' THEN 'yes' else 'no' end, @Name
set @Name =...
--------------------------------------------------------------
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 20, 2014 at 2:26 am
The script that was given by sql driver, shows the size of log backup. While I agree that it has a connection to the log's size, it doesn't show...
--------------------------------------------------------------
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 14, 2014 at 8:49 am
If all you need is to round the number to an integer number or to omit the part that is right to the decimal point, then you can use 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/
April 30, 2014 at 3:16 am
Check if you are using linked server (or synonym that uses linked server). If this is the case, then you need to modify the linked server's login's configuration.
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/
April 8, 2014 at 8:15 am
Koen Verbeeck (4/7/2014)
It seems your crystal ball is in the shop for repairs? 😀
repairs and upgrade:-).
--------------------------------------------------------------
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/
April 7, 2014 at 4:33 am
Talking about getting it wrong. I completely misunderstood your needs. You really need to explain what you want. It would be helpful if you'll also have a small...
--------------------------------------------------------------
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/
April 7, 2014 at 4:14 am
You didn't really specify the rules for your update. Currently we are mainly guessing the way that it should work. I wrote a small code that transform your...
--------------------------------------------------------------
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/
April 7, 2014 at 3:52 am
Well, you are wrong. Checkpoint will occur. In fact one of the factors of that cause checkpoint is database backup. Of course there are other things 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/
March 27, 2014 at 5:18 pm
The SQL statement that you are using in the screen shot that causes the runtime error is different from the statement that you wrote in the original question. 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/
March 27, 2014 at 4:52 pm
I've just ran the small script that you can see bellow on SQL Server 2012 and it worked without any problems, so I don't think that the problem is 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/
March 26, 2014 at 10:51 pm
You can test it for your self by creating a deadlock and then check that you see it's details in the error log. Here is a small script 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/
March 26, 2014 at 4:20 pm
Viewing 15 posts - 121 through 135 (of 1,479 total)