What is the difference between having clause and where clause in sql server?
Explain user defined views?
List the advantages of using stored procedures?
What is an etl file?
What do you mean by acid?
What is the function of sql server agent windows service?
How to list all columns in a table using odbc_columns()?
What is nolock hint in sql server 2008
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
When would you use a before or after trigger?
What are sql server procedures?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is a view in sql?
What is the difference between function and stored procedure in sql server?
What is TDS(Tabular Data Stream) Gateway?