Which is better statement or preparedstatement?
No Answer is Posted For this Question
Be the First to Post Answer
When would you prefer to have a minimum number of indexes?
What is a Linked Server?
How many clustered indexes there can be on table ?
What is the ‘fillfactor’?
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
Can two different columns be merged into single column? Show practically?
wat wil hapn if we give the both read and deny read permission to user?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
What is data mart? : sql server analysis services, ssas
Which trace flags are enabled in sql server?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
List the various tools available for performance tuning?
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)