Can we use where clause with group by?

900

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1065

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1008

Write a query for primary key constraint with identity key word?

1031

Explain Geography datatype in SQL Server

1129

What is sql server programming?

1044

What does man by sql wildcard characters in sql server?

1060

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

970

what is normalization? : Sql server database administration

1096

How would we use distinct statement? What is its use?

1072

What is GUID in sql server?

1165

Does partitioning improve performance sql server?

978

What is an indice?

1037

What are two difference between sql azure and azure tables?

159

Can you explain different types of locks in sql server?

947