| Title | Posted Date |
| What operator performs in pattern matching in SQL Server | December 24, 2009 |
| Which command executes the contents of a specified file? | December 24, 2009 |
| Which system tables contain information on privileges granted and privileges obtained? | December 24, 2009 |
| Which system table contains information on constraints on all the tables created? | December 24, 2009 |
| What is the use of CASCADE CONSTRAINTS? | December 24, 2009 |
| What are the Text and Image Functions? | December 24, 2009 |
| Tell me some String Functions? | December 24, 2009 |
| Tell me some Aggregate Functions? | December 24, 2009 |
| Write a function to find distance between two points? | December 24, 2009 |
| How do we rename a database through query? | December 24, 2009 |
| What is a trigger? | December 24, 2009 |
| What is a view? | December 24, 2009 |
| What is an Index? - | December 24, 2009 |
| What are the types of indexes available with SQL Server? | December 24, 2009 |
| What is the basic difference between clustered and a non-clustered index | December 24, 2009 |
| What is the default index for primary key | December 24, 2009 |
| What are cursors? | December 24, 2009 |
| Can we use Truncate command on a table which is referenced by FOREIGN KEY? | December 24, 2009 |
| What is the use of DBCC commands? | December 24, 2009 |
| Can you give me some DBCC command options?( | December 24, 2009 |
| What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? | December 24, 2009 |
| What is a Linked Server? | December 24, 2009 |
| In SSIS where the package related information are stored? | December 24, 2009 |
| Which stored procedure will you be running to add a linked server? | December 24, 2009 |
| What are the OS services that the SQL Server installation adds | December 24, 2009 |
| What are the authentication modes in SQL Server? | December 24, 2009 |
| What is log shipping? Can we do logshipping with SQL Server 7.0 | December 24, 2009 |
| Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow? | December 24, 2009 |
| What is BCP? When do we use it? | December 24, 2009 |
| What is DTS? | December 24, 2009 |
| What''s the latest version of DTS? | December 24, 2009 |
| What is the file extenstion of SSIS package | December 24, 2009 |
| Which one is best DTS or BCP? | December 24, 2009 |
| What should we do to copy the tables, schema and views from one SQL Server to another? | December 24, 2009 |
| I need to export tables, data,relationship, constraints etc from ACCESS to sqlserver? how shall I do it | December 24, 2009 |
| What is the use of SET ROWCOUNT | December 24, 2009 |
| There is a DELETE statement inside a transaction. What happens if the transaction is rolled back? | December 24, 2009 |
| What is a cube? | December 24, 2009 |
| What is snow-flake schema? | December 24, 2009 |
| What is star schema? | December 24, 2009 |
| What is a fact table? | December 24, 2009 |
| What is a dimension table? | December 24, 2009 |
| What is the use of @@fetch_status? | December 24, 2009 |
| What''s the use of @@trancount in sql server 2005 | December 24, 2009 |
| Which command displays the SQL command in the SQL buffer, and then executes it? | December 25, 2009 |
| What are the wildcards used for pattern matching? | December 25, 2009 |
| !=, <>, ^= all denote the same operation. It is True of False | December 25, 2009 |
| What are the privileges that can be granted on a table by a user to others? | December 25, 2009 |
| What is the difference between TRUNCATE and DELETE commands? | December 25, 2009 |
| Which command is used to create a table by copying the structure of another table? | December 25, 2009 |