Server Configuration
in [Microsoft SQL Server]
|
How to compress my log file Sql Server 2005. I just created a new database in SQL. I imported data amoutning to about 15 MB. However, when I look at the database files associated with my new database (Grading.mdf and Grading_log.ldf) I notice that the Grading.mdf is 7 MB and the Grading_log.ldf is 1.4 GB. I have been doing some experi... 8 Apr 2010 16:20
SQL Server 2008 functionality Hi, In my SQL Server 2008 ,I just restore a database DB1 from a .bak file which is from my SQL Server 2000. I have a user UserA in the DB1, how do I set up the SELECT/UPDATE/DELETE privilege for UserA on DB1's tables? Thanks for help. Jason ... 8 Apr 2010 06:10
Question on SET COMPATIBILITY_LEVEL Hi, I'm wondering if I set the COMPATIBILITY_LEVEL of my SQL Server 2008 db to 100, will this improve the efficiency of that db? Thanks for help. Jason ... 8 Apr 2010 06:10
find a certain table from sql server Dear SQL Server Export, How do I find a certain table in sql server assuming I do not know the name of the database. sysobjects does not work. and INFORMATION_SCHEMA.TABLES does not work either. You have to know the db name in both cases. ... 11 Apr 2010 02:38
sp_who2 and system background processes I need help interpreting the following sp_who2 output. I'm not sure if this is a problem or not. SPID Status Command CPUTime DiskIO LastBatch 1 BACKGROUND RESOURCE MONITOR 45004812 17967 03/11 09:03:05 2 BACKGROUND LAZY WRITER 656562 ... 7 Apr 2010 16:54
CacheHitRatio Hello, [SQL2005] We use a monitoring software that checks various system resources and alerts us based on the threshold values. As part of this, it tracks the CacheHitRatio where it is set as to error when the value goes down 95% and warn when it does down 98%. Of late we notice that the alert triggers o... 8 Apr 2010 01:50
Unable to script database I am trying to script a database and then create another database to see what problems I may see converting to 2008. But all the triggers and one stored procedure is encrypted so the scripting stops right away. Are the triggers normally encrypted. Is there a way to tell the system script the data then encr... 7 Apr 2010 16:54
owner of databases All, Currently, the database owner is set to the person (to the person's login id - sql login or windows login) who creates the database. In almost all the cases, it is the DBA that creates the databases in our setup. So when “exec sp_help” is executed it lists all the databases on the server along with t... 7 Apr 2010 03:31
Checking for Ghost Cleanup Job Status I have a HEAP with 500 million rows in SQLServer 2005 - Standard Edition - SP2 (I know!). The table keeps growing and even though I've deleted 50million+ rows WITH TABLOCK this hasn't reclaimed any of the space ... These are still marked as Ghost records in dm_db_index_physical_stats (DB_ID() ,,,,'DETAILED'). ... 7 Apr 2010 04:37 |