Which index created when Create Index on table(col), Why
Answer Posted / sanjay
whenever you create index without specifying the type, its
non-clustered.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Tell me about the approaches which you used to counter the DI problems.
Does group by or order by come first?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is difference between delete & truncate commands?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
explain declarative management framework (dmf) in sql server 2008?
What happens to a statement batch if there is a compilation error?
What is the purpose of linked server configuration in sql server?
What is ems sql management studio? : sql server management studio
What is snapshot parameter in ssrs?
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
Explain about the command-line tool SQLCMD?
How does a profiler work?
What are the requirements for sql server 2016?
Explain what is lock escalation and what is its purpose?