Why use identity in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
How to create nested stored procedure?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
How to optimize stored procedures in sql server?
What is correlated subquery in sql server?
How to return the second 5 rows in ms sql server?
what is the system function to get the current user's user id? : Sql server database administration
What do you mean by a Composite primary key?
What is normalization according to you and explain its different levels?
Why Master database is required?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is sub-query in sql server? Explain its properties.
What are joins in sql and what are the different types of joins?
What is table value parameters (tvp)?