Hi, 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...
Hi, 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...
Hi, 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 As BEGIN...
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...
Question#1 Is this "good" or "GREAT" style for a stored proc w/transactions: BEGIN TRANSACTION GetMyData Update ...@topicID IF @@ERROR <> 0 GOTO...
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? I tried: update...
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 .. .. OR 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: NOT IN or NOT EXISTS Are these one and the same or is there a query plan difference?
Hey! When did this forum get setup? I never noticed it before Brad !
Separate names with a comma.
