How to view existing indexes on an given table using sp_help?
No Answer is Posted For this Question
Be the First to Post Answer
Does table partitioning improve performance?
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
What are the types of sql server?
What is the difference between inner join and equi join?
What is a livelock?
What is Index ? Explain its Types?
What are dml triggers and types of dml triggers?
What are the hotfixes and patches in sql server?
what is database replicaion? : Sql server database administration
what is denormalization and when would you go for it? : Sql server database administration
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are different types of data sources?
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)