I have a 40 000 row table that is very slow.
It has a primary key Identity column, identity auto increment.
It also has a integer column...
I am running a web based application, and I am looking at profiler trying to see ONLY the sql script that results from the web based...
I'm creating a web applicating using .NET.
Is it more faster/performant to use OUTPUT varialbes in a stored procedure to return 3 results back...
Here is a stored proc I've seen this on, is this working/correct?
CREATE Procedure DoSOmethignYo
@XXID as int,
@newXXXXID as int
Confused. What your saying is that after each statement, if there is no error, the @@error is reset so I have to do repeated checks?
so I have to...
Is this "good" or "GREAT" style for a stored proc w/transactions:
BEGIN TRANSACTION GetMyData
IF @@ERROR <> 0
So to be safe I guess I can check the size of the column..and if its whithin the varchar max length THEN do the replace on it?
Can someone script...
I'm trying to remove all <br> tags from a ntext field using the replace function and QA complained about it.
How do I do this?
5 million per week..do u mind me askign what this is for?
I have a field in a table that would be 'best' suited with a text field since the data can be extremely large.
Would table size, reads, writes be...
The thing is that the row is already locked...so I don't htink that will work. The nolock will not create a lock on the select statement but the row...
Which is faster?
SET @blah = select name from inserted
SET @blah2 = select name2 from inserted
SELECT @blah = name, @blah2 = name2 .......
My table has a trigger that fires upon insert/update. The trigger calls a extended-stored-proc which calls a ASP page which attempts to retrieve the...
doesnt' sql server 2000 automatically rebuilt index stats by itself?
What are the key differences in using either:
Are these one and the same or is there a query plan difference?
When did this forum get setup? I never noticed it before Brad !
Separate names with a comma.