What are the differences between sql server and mysql.
No Answer is Posted For this Question
Be the First to Post Answer
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Can we linked SharePoint to a SQL database?
0 Answers Sans Pareil IT Services,
how can you move the master database
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain following error properties?
Explain sql delete command?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Can a rule be bound to any column of any data type?
Explain the storage models of OLAP?
Explain what is the difference between union and union all?
What will be the maximum number of index per table?
What are the difference between primary keys and foreign keys?
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)