What is query optimizer in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is a natural primary key?
CTE(common table expression)
what are different types of backups available in sql server? : Sql server database administration
What are page splits? : SQL Server Architecture
What is constraints and its types?
What are different backups available in sql server?
how to get max salary with employee number by using one select query and max function ??
What is similarity and difference between truncate and delete in sql?
How can sql server instances be hidden? : sql server security
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are the five major components of a dbms?
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)