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.1618
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 1523
what is advantages in sql 2005 over sql 2000?4 4882
Differnce between sel server 2000 and 20053 3630
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 3410
i need some interview questions on sql server developer plz any onee send some links.2 3625
what is mean by crystal repoart? ahere we will mainly use that?1 2493
how to rename the table3 4036
how many type of subquery?2 4884
If we delete pack Spec what will be the status of pack Body ?
What are the dis_advantages of stored procedures, triggers, indexes?
Working with TLogs
how to use DTS package in 2000,2005,2008 in sql server
can any body tell me how to know the password of current user in sql server
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
how to take backup bcp out for a column in table in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
role of sql sever 2005 in database rather than any other database
What is data modeling and Reterminal integrity?