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...
Is this "good" or "GREAT" style for a stored proc w/transactions:
BEGIN TRANSACTION GetMyData
IF @@ERROR <> 0
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 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
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:
Are these one and the same or is there a query plan difference?
Separate names with a comma.