Explain what are the basic functions for master, msdb, model, tempdb databases?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What does indexation mean?
write a query to remove duplicate records without using primary key column?
What is the difference between 2-Tier architecture and 3-Tier architecture
15 Answers CTS, MCN Solutions, Oracle,
What do you understand by the analysis services in sql server?
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
How do I find the sql server database version?
What is data compression? : sql server database administration
What does this statement do @@rowcount?
Can you please explain the difference between function and stored procedure?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to access the inserted record of an event?