Does partitioning improve performance sql server?
No Answer is Posted For this Question
Be the First to Post Answer
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
what is hash nonclustered index
What are “lost updates”?
Tell me what are the essential components of sql server service broker?
Tell me what is de-normalization and what are some of the examples of it?
What is a covering index?
How to a Query to copy data from on table to another table.
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is sparse columns of sql server 2008?
Can the “if update (colname)” statement be used in a delete trigger?
What type of Index will get created after executing the above statement?
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)