How to rename databases in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
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 are built in functions?
What is difference between temp table and cte?
How can you list all the table constraints in a database?
What does top operator do?
Explain the properties of the relational tables?
What is inline variable assignment?
How to disable a login name in ms sql server?
What is the difference between DTS and SSIS?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
What is the default Port No on which SQL Server listens?
How to provide values to stored procedure parameters in ms sql server?
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)