Viewing 15 posts - 15,526 through 15,540 (of 18,923 total)
Frankly no... I usually try to find the fasted query for a situation... and often 2 versions can have the same performance. Maybe someone else might think of one.
July 7, 2005 at 8:29 am
If the any of those tempdb tables are locked (sysobjects, syscolumns, sysindexes, sysindexes), any code that needs to create a temp table or even a table variable will not be...
July 7, 2005 at 8:26 am
Generally, this is something that will change between each call from the app
.
July 7, 2005 at 8:24 am
Do you have a specific case?
This is one of those "it always depends"
.
July 7, 2005 at 8:21 am
Why can't you use this syntaxe? : Form_FormName.fkClientID = id
July 7, 2005 at 8:20 am
Here's my thinking : Don't use cursors, ever. Then if you find a situation where a cursor is faster than a set based approach or there's no set based...
July 7, 2005 at 8:19 am
What is SAP short for? Yahoo doesn't return anything usefull.
July 7, 2005 at 8:09 am
As I said, not the expert in this matter
. Thanx for correcting my answer David.
July 7, 2005 at 8:05 am
How about finding 3 other ways then
.
July 7, 2005 at 8:05 am
Thanx Shown for this input, but I'd like to stress out that these methods are only LAST RESORTS, you must first try to find the SET BASED approach...
July 7, 2005 at 8:03 am
Can't you try it like this?
Select * fro LinkedServerName.DbName.dbo.TableName where ...
July 7, 2005 at 8:01 am
/*this creates a sequence table*/
CREATE TABLE [Numbers] (
[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [Pk_Number] PRIMARY KEY CLUSTERED
(
[PkNumber]
) ON [PRIMARY]
) ON [PRIMARY]
GO
Declare @i as int
set @i = 0
while...
July 7, 2005 at 7:58 am
Now that's what I was talking about in the other post
.
Arrays and Lists in SQL Server - Slow
StmtText ...
July 7, 2005 at 7:55 am
My bad, I thaught you were writting the split code... ![]()
July 7, 2005 at 7:47 am
Viewing 15 posts - 15,526 through 15,540 (of 18,923 total)