SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Production databases, people involvement

  I work in a small company with 90 people. I have been working as a database developer but recently …

  WonderPra

  8 replies

  12 years ago

  By: kevaburg

• transaction log eats up all the space and growing until sql is stopped

  Hi , I've got a peculiar problem with my VCENTER's SQL 2008 database. My Database is running on SIM…

  mJai

  18 replies

  12 years ago

  By: dan-572483

• Backup With Checksum

  In searching for information on checksum, I see statements like "When backing up a DB Checksums are…

  hayden_jones

  12 replies

  12 years ago

  By: hayden_jones

• Owner of prepared statements

  One of my production databases has in the exec plan cache a statement that needs to be modified so …

  jhager

  4 replies

  12 years ago

  By: Grant Fritchey

• Auditing to fetch the details of lastlogin date of user in SQL server

  How to use auditing to get the lastlogin date of the user in SQL?? or is there any other way to fet…

  navimir

  1 replies

  12 years ago

  By: Grant Fritchey

• Changing from 4 core to core on sql server

  What are the necessary changes and points to be noted when changing 4 core to 8 core on SQL SERVER …

  Penserver

  1 replies

  12 years ago

  By: VastSQL

• Policy Based Management(PBM): deny database backup process/task for certian users

  I would like to set a policy for backup process that database backups( any type, FULL/LOG/DIFFERENT…

  SumLasty

  1 replies

  12 years ago

  By: SumLasty

• Understanding heaps

  Hi, Can anyone explain the below behavior for HEAP tables? I have created a small heap table with …

  Oracle_91

  2 replies

  12 years ago

  By: Oracle_91

• CPU considerations for multiple instances

  I've been researching this and haven't found much info so I'm not sure what most people do. Consid…

  scogeb

  6 replies

  12 years ago

  By: MysteryJimbo

• SQL Jobs failed - Unexpectedly?

  Hi Recently SQL 2008 edition upgraded to enterprise edition from standard edition on top of windows…

  SQL Galaxy

  3 replies

  12 years ago

  By: SQL Galaxy

• backup script

  If I would like to create a script to back up a database to the default backup directory, how can I…

  sqlfriend

  8 replies

  12 years ago

  By: sqlfriend

• Query Suddenly Starts Taking Huge Time

  Hi All, We have a SQL QUERY which Extracts Data from 10 Tables, But the Query All of a Sudden bumps…

  sudhirnune

  5 replies

  12 years ago

  By: PravB4u

• Lazy Writer Activity

  Hi all In a system with no writes and just selects, lazy writer won't be doing anything at all? Cor…

  SQLSACT

  7 replies

  12 years ago

  By: SQLSACT

• Database Mail does not work

  I have configured Database Mail in SSMS with a public mail profile that includes an account and cou…

  long.nguyen 61027

  2 replies

  12 years ago

  By: PravB4u

• Shrink SQL Database Failed

  have a database which size is 40GB, but only 1% is used, so i wanted to shrink this database to a s…

  dingjianrui 22032

  3 replies

  12 years ago

  By: free_mascot