Why use “nolock” in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How to create a simple stored procedure in ms sql server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is resource governor?
Why do we need normalization?
What is difference between clustered index and non clustered index?
Which command is used for user defined error messages?
Can a table be created inside a trigger?
When I run the sql server 2000 setup, it just hangs. What do I do?
how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is blocking?
What are the main sources of data?