What is the purpose of grouping data in a report?
No Answer is Posted For this Question
Be the First to Post Answer
How to recreate an existing index in ms sql server?
What do you understand by the data quality services in sql server?
Does group by sort data?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How can you get @@error and @@rowcount at the same time?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What do you understand by recursive stored procedure?
Explain what is cte (common table expression)?
What is the purpose of UPDATE STATISTICS?
What is scheduled job and how to create it?
explain extended properties
What is the New in SQL server 2008?
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)