What is a trigger?4 4085
What is a view?6 5024
What is the basic difference between clustered and a non-clustered index?9 31053
What are cursors?8 5397
Which TCP/IP port does SQL Server run on?2 7626
From where can you change the default port?3 4384
Can you tell me the difference between DELETE & TRUNCATE commands?15 14931
What is the use of DBCC commands?4 5671
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.1351
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?2 2524
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?11 20756
your distribution database is full what will u do
Why do you want to join software field as you have done your BE in Electronics?
How do you Implement SSIS Packages in your Project?
which backup strategy you are following at ur company
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
how to take backup bcp out for a column in table in sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
How to convert a table data in XML format in sql server?
System variable and temporary variables
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?