What are the steps you will take to improve the performance of a poor performing query?
No Answer is Posted For this Question
Be the First to Post Answer
What is an sql server agent?
How to declare and use cursor variables?
How can we rewrite sub-queries into simple select statements or with joins?
What are .mdf files?
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
Are connections to sql server encrypted?
A left outer join B B right outer join A gives the same result then what is the use of two?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What are tables in sql server?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is nolock?
Oracle (3253)
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)