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...
Question#1 Is this "good" or "GREAT" style for a stored proc w/transactions: BEGIN TRANSACTION GetMyData Update ...@topicID IF @@ERROR <> 0 GOTO...
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...
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...
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...
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?
Separate names with a comma.
