How would you choose between a clustered and a non-clustered index?
No Answer is Posted For this Question
Be the First to Post Answer
What is Peer to peer Replication?
1 Answers CarrizalSoft Technologies, HCL,
What is WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
What is the difference Between Sql-server 2000 & 2005
Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation
What is multilevel indexing?
Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?
How to recreate an existing index in ms sql server?
Explain Geography datatype in SQL Server
Why normalization is used?
What do you mean by subquery?
1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format
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?
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)