What are the disadvantages of primary key and foreign key in SQL?
What happens if null values are involved in arithmetic operations?
What is a partition key?
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
How to test a dml trigger in ms sql server?
What is buffer cash in sql server?
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Why we need sql server?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
What is #temp and @table variable in SQL server?
Can the query output be sorted by multiple columns in ms sql server?
Explain following error properties?