Viewing 15 posts - 826 through 840 (of 1,478 total)
I have few machines with SQL Server 2008 and SQL Server 2005 (some of them also have SQL Server 2000). Before installing SQL Server 2008 you need to install...
--------------------------------------------------------------
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 23, 2009 at 9:27 am
Maybe this is not the answer that you are looking for, but I from my experience, if I have a maintenance job that fails each time that it runs, 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/
September 21, 2009 at 9:46 am
Is this is the real code that you use? If it is, then I don’t think that it can even compile. You are trying to create a 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/
September 21, 2009 at 6:51 am
:pinch: I'm sorry but as written this is wrong.
The reason why a clustered index ALWAYS goes to the same filegroup the table goes is because the leaf level 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/
September 14, 2009 at 9:49 am
Pleas read the article that is on my signature to learn how to ask questions in a way that will get you a better and faster answer.
As...
--------------------------------------------------------------
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 14, 2009 at 9:08 am
The QUOTED IDENTIFIER set option is set during the creation of the stored procedure and sticks with it, so modifying this set option at the session that activates the procedure,...
--------------------------------------------------------------
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 14, 2009 at 8:42 am
This is done on purpose. When you create a clustered index on a heap you might want to move the table to a different file group, but you might...
--------------------------------------------------------------
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 14, 2009 at 7:52 am
When you create the index, you can specify the file group that you want it be on. If you don’t specify where to create the index, it will be...
--------------------------------------------------------------
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 14, 2009 at 5:30 am
Like you I would say that it depends. Suppose there is a procedure that inserts data into a temporary table, runs some complex calculations on the table (according...
--------------------------------------------------------------
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 8, 2009 at 5:42 am
As far as I know parameter sniffing uses the actual values of the parameters. If the parameters were passed with a different value then the default value, then 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/
September 8, 2009 at 5:11 am
I don’t have much experience with full text search so I might be off base here, but did you try changing the file’s path or name by using the move...
--------------------------------------------------------------
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 7, 2009 at 3:45 am
Sp_who2 can help you when you don’t have many processes on the server that are being blocked. On a busy server you might have a big blocking chain (which...
--------------------------------------------------------------
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 2, 2009 at 5:00 am
I think that severity 16 should also do the trick
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/
September 1, 2009 at 7:02 am
You have to be more specific then that. How do you decide which value goes to which column? Also post a small script that had the create 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/
September 1, 2009 at 3:28 am
select itemid,
tbl.col.value('(.)[1]','int')
from Test1 cross apply SerialNumbers.nodes ('/SERIALNUMBERS/SERIALNUMBER') tbl (col)
If what you need is to get the ItemID of a known serial number, you can use the exists method:
select...
--------------------------------------------------------------
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, 2009 at 2:59 am
Viewing 15 posts - 826 through 840 (of 1,478 total)