How to optimize stored procedures in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
What is instead of trigger sql server?
What is pessimistic concurrency?
What is primary key and example?
What are the parts of a function?
how can i view structure of table in sql server? tell me that query.
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is the boxing and unboxing concept in .net?
How will you decide the active and passive nodes?
Why do we use trigger?
if no size is defined while creating the database, what size will the database have? : Sql server administration