how many clustered indexes can be created on a table? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
How do you persist objects, permissions in tempdb
What is the process of normalising?
If we shrink the Databse and Files, how much size is decreased?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What is an sql server agent?
how to trace the traffic hitting a sql server? : Sql server database administration
What do you understand by intent locks?
If a table does not have a unique index, can a cursor be opened on it?
how to use DTS package in 2000,2005,2008 in sql server
How to check status of stored procedure in sql server?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
Explain about unique identifier data type in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)