Viewing 15 posts - 1,216 through 1,230 (of 1,347 total)
Check your client system's memory usage when running this qury - the grid display in QA may be consuming a large amount of memory for such a large resultset, and...
February 10, 2005 at 12:22 pm
What are the requirements, regarding latency ? Is it really necessary to load the file almost instantaneously, or is a delay of several seconds acceptable ?
The requirements drive the solution...
February 10, 2005 at 10:50 am
Also, reconsider the stored proc name, in particular the sp_ prefix.
See: http://www.sql-server-performance.com/vk_sql_best_practices.asp
February 10, 2005 at 8:53 am
How many indexes are on dbo.Sales ? Can you drop them and recreate them before & after the Insert ?
Does the table being joined to ([Item Group Template] have an appropriate...
February 10, 2005 at 8:31 am
This is a known Sql Server issue - it doesn't implement an ISO week (i.e. week 1 = 1st week with at least 4 days in it).
BOL provides an example...
February 9, 2005 at 3:20 pm
>>Doing a SELECT INTO #TempTables can cause blocking in tempdb.
In which version of SqlServer ? sys* tables in tempdb are row-locked in Sql2K.
February 9, 2005 at 3:03 pm
What if the wholesale price goes above $255 and you can't Char() it ?
I'm sure I won't be the 1st to ask "Why?" nor will I be the first to...
February 9, 2005 at 3:01 pm
I don't think this will be possible with a case-insensitive collation, even if you do use ASCII char values.
Example - uppercase D is ASCII 68. Try this, to place a...
February 9, 2005 at 1:34 pm
>>This i know
It would assist others, then, if you asked a specific question, so as not to waste other's time answering questions you don't need answered.
A "Select Into" creates the table,...
February 9, 2005 at 10:17 am
Insert into requires a table to exist already (and gives an error if the table does not exist).
Select Into creates the table (and gives an error if the table already...
February 9, 2005 at 10:05 am
See the CHARINDEX() and SUBSTRING() functions in BOL.
Part1: Substring(YourColumn, 1, CharIndex(' - ', YourColumn) - 1)
Part2: SubstringYourColumn, CharIndex(' - ', YourColumn) + 3, 80)
February 9, 2005 at 9:33 am
What you are attempting is really dynamic SQL and it can't be done via a CASE in a where clause.
You can have:
Where Table.SomeColumn = (CASE ... END)
You can't have:
Where (Dynamic...
February 9, 2005 at 8:52 am
You'd use UDPATE(ColumnName) to first determine if the column changed. Then a correlated query between the inserted & deleted tables to compare curr/prev values
If Update(YourColumn)
Begin
If Exists (
Select *...
February 8, 2005 at 12:11 pm
An "In () " subquery is not correlated, therefore there is no requirement for the column name in the outer query to match the column name of the subquery resultset....
February 8, 2005 at 11:44 am
Viewing 15 posts - 1,216 through 1,230 (of 1,347 total)