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.2093
my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.1 2032
what is advantages in sql 2005 over sql 2000?4 5710
Differnce between sel server 2000 and 20053 4316
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?1 3885
i need some interview questions on sql server developer plz any onee send some links.2 4197
what is mean by crystal repoart? ahere we will mainly use that?1 3051
how to rename the table3 5089
how many type of subquery?2 5466
Is mysql better than sql server?
What do you understand by user-defined function in the sql server?
what is isolation level at dead lock?
What is indexing a document?
How to test subquery results with the exists operator?
Explain filestream storage of sql server 2008?
What is a cursor, index in sql?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What are logical/boolean operations in ms sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Which joins are sql server default?
How to convert character strings into numeric values?
what is the information that can be stored inside a bit column? : Sql server database administration
Explain about builtinadministrator?
What is an identity column in insert statements?