An important point may be, if the query produces alternating big and small resultsets. If it is true that a stored procedure keeps more to the...
My query spans three databases on one Sql Server 2000 instance. Is the query execution plan optimized as it would be when the tables are all in the...
Is the following performance tip in the Newsletter from 14-07-2008 true? I don't think so. Optimizing SQL Server Clustered Indexes If you run into a...
I have two comments: 1. the querycost in SSMS doesn't match your timing. That can be an issue with Windows regional Options. If your setting for...
Your function is a Table-function. So it has to be in the From clause of the Select statement: SELECT Value FROM dbo.fSplit(ColAInputstring, ',')...
MSDN tells in Sql Server 2005 BooksOnLine about CreateView ( http://msdn2.microsoft.com/en-us/library/ms187956.aspx ) in Change History: 17 July...
I don't know much about prepared queries or the table structure in this case. But I can imagine as the primary key is composite, the query has to use...
quote:Originally posted by Adriaan Add an INT column with IDENTITY(1,1) and make this the clustered primary key. Why is using a clustered index on...
My problem seems to come from my regional settings. Comma was set as decimal separator. Obviously the real numbers that come from the server are not...
It looks like a problem in the graphical view of the execution plan in Query Analyzer. In Query Analyzer on Sql Server 2000 (version 8.00.760, SP3) I...
After I moved to Sql Server 2000 (local), I see often in the execution plan cost of more then 100 % (for instance with nested loop join). The query...
Separate names with a comma.
