Viewing 15 posts - 406 through 420 (of 1,478 total)
Why are you using an XML in the select with for xml clause? The for xml clause is meant to be used when you take a tabular data and...
--------------------------------------------------------------
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/
November 24, 2011 at 8:58 am
You need to add apostrophes to your dynamic SQL. Instead of the line:
Select @bank = @bank + '','' + bank + '''' -- In the second step taking bankFusiCode...
--------------------------------------------------------------
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/
November 23, 2011 at 9:55 am
It’s been a while since I opened a text file using T-SQL, but when I did it, I used the bulk provider and was very easy to do 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/
November 23, 2011 at 9:46 am
Jeff Mayer (11/22/2011)
Our server finally choked itself to death and shut down. I am now trying to figure out what caused the processes to fire. Now the real fun begins!!
Actually...
--------------------------------------------------------------
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/
November 22, 2011 at 12:20 pm
Can you find out what those processes are? Are they jobs that were configure? Can you see the name of the application that uses xp_readerrorlog? Can 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/
November 22, 2011 at 10:49 am
There are few strange things in your post. Xp_readerrorlog doesn’t change any data, so I don’t see why there should be any rollback. Can you post 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/
November 22, 2011 at 9:43 am
The log backup logged the alter database statement and also modifications to the system’s metadata tables that reflect the database’s modification. It didn't have to copy/backup the files' pages....
--------------------------------------------------------------
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/
November 22, 2011 at 4:21 am
While I agree that we should use the new syntax, I don’t think that the error message was caused by using the procedure. Most chances are that you already...
--------------------------------------------------------------
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/
November 22, 2011 at 1:30 am
Here is one way of doing it. Take into consideration that you showed us an example and didn’t write any specification, so the example works on the dataset 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/
November 22, 2011 at 1:16 am
Here is a query that can check the query plans that exist in the cache and show you the queries that use most CPU. Take into account that if...
--------------------------------------------------------------
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/
November 20, 2011 at 2:17 am
Check if you defined a table type parameter that uses this schema.
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/
November 16, 2011 at 10:55 am
Have a look at sys.dm_io_virtual_file_stats. It has all the information that you are asking for.
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/
November 16, 2011 at 3:05 am
drew.allen (11/11/2011)
Adi Cohn-120898 (11/11/2011)
--------------------------------------------------------------
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/
November 11, 2011 at 10:47 am
Personally I don’t like doing things like that, but it can be done with the over clause. The code bellow is based on AdventureWorks database:
select ProductID, SUM(ActualCost) from Production.TransactionHistory...
--------------------------------------------------------------
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/
November 11, 2011 at 10:32 am
When I need to do it, I use UNC path (\\MyServerName\Dirctory\File.bak)
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/
November 11, 2011 at 10:11 am
Viewing 15 posts - 406 through 420 (of 1,478 total)