What are the different Authentication modes in SQL Server and how can you change authentication mode?
- 0 Answers
- 806 Views
- I also Faced
- E-Mail Answers
Explain cross join or cartesian product in sql?
What are the properties of primary key?
How to list all objects in a given schema?
How to list all triggers in the database with sys.triggers in ms sql server?
What are the different types of stored procedures?
Can a table be created inside a trigger?
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
what is the difference between delete,drop and truncate
What is buffer cash and log cache in sql server?
How to move database physical files in ms sql server?
Explain what is scheduled job and how to create it?
Can you force a query to use a specific index?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
