What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is clustered primary key?
What is a rollup clause?
What is faster join or union?
Can you please explain the difference between primary keys and foreign keys?
How many database files are there in sql server 2000?what are they?
What is @@Identity in sql?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is sql server transaction log file?
How to use copy and concatenate commands in SQL?
What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
What is rank function?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,