DELETE logs the data for each row affected by the statement in the transaction log and physically removes the row from the file, one row at a time. The recording of each affected row can cause your transaction log grow massively if you are deleting huge numbers of rows. However, when you run your databases [...]
Archive for November, 2006
DELETE and TRUNCATE explained.
November 24, 2006
Understanding NULLS
November 23, 2006
Understanding NULLs
Difference between UNIQUE constraint and PRIMARY key
November 22, 2006
UNIQUE constraint and PRIMARY key differences
How do you find the Second highest Salary?
November 14, 2006
Find the Second Highest Salary in a table
How many rows this query will return
November 14, 2006
How many rows will a plain JOIN return?
What is a deadlock?
November 10, 2006
What is a deadlock? What is a live lock?
What is the maximum size of a row?
November 10, 2006
Maximum capacity specifications. Max size of a row?
Indexes in SQL Server
November 10, 2006
What are Indexes? How do Indexes Work? Types of Indexes? Advantages of Indexes. Disadvantages of Indexes?
What is the difference between Primary and Unique key?
November 10, 2006
Difference between priimary and unique keys. MS SQL Server
What are triggers?
November 9, 2006
triggers in sql server.
