SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Daily Comulative Report in SQL Server

  Hi All, Suppose that a have a table in sql server that store sales information ( Product; Date, Qty…

  abdul.badru

  12 replies

  14 years ago

  By: Jeff Moden

• Any point in backup of MDF/NDF/LDF files

  We are running into some challenges with our nightly disk/disk/tape backups. The amount of data bei…

  joffwilliams

  5 replies

  14 years ago

  By: joffwilliams

• 4 TB SQL Server EDW database

  We currently have a EDW that is around 800 GB. It is running on a VM (16GB, 4core). We are antici…

  cbarus

  1 replies

  14 years ago

  By: Sean Bowden

• Replace Cursor with CTE

  My script drops a specific set of views by using a cursor to loop through the view names. Can the f…

  gorthog

  2 replies

  14 years ago

  By: gorthog

• SQL Server 2008 books recommedations

  SQL Server 2008 books recommedations, For Development and administration Thanks

  APA0876

  1 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Import Wizard not allowing "Run Immediatly"

  This is an issue I run into periodically that drives me crazy. I am importing an excel sheet to add…

  tshad

  2 replies

  14 years ago

  By: tshad

• ForEachfile container capture "file not found" event

  Hi all - I'm working error handling in a package and one of the requirements is to log an error w…

  Uripedes Pants

  3 replies

  14 years ago

  By: Orlando Colamatteo

• Transaction Log Setup

  Hello Everybody, I have SQL 2008 R2 server and a production database that was in simple recovery mo…

  sql_hammy

  23 replies

  14 years ago

  By: Ant-Green

• grouping, or aggregating columns of figures by date

  Hi, What would you suggest for a formula to group a column of figures into 3 (or more) coumns accor…

  robert.hall

  3 replies

  14 years ago

  By: Sean Lange

• Setting alert when CPU usage 100% for continous 1 minute

  Hi One of our prod server is showing 100% CPU usage for continous long times, at times 5 minute. I …

  S_Kumar_S

  4 replies

  14 years ago

  By: S_Kumar_S

• Maintenance Plans to Local Storage in a Clustered environment

  Hi, I’m hoping somebody can be of help or point me to a similar post: I have an Active/Active SQL S…

  InFrA007

  1 replies

  14 years ago

  By: John Mitchell-245523

• Dynamic Dataflow and mapping in SSIS

  Is there a way to make a dynamic dataflow object, with dynamic mapping at the same time? I'm curren…

  richard.noordam

  3 replies

  14 years ago

  By: richard.noordam

• User 'Domain\XXX' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

  I'm trying to setup permission for the user to access specific reports in the Report Manager 3.0 i …

  preetid2

  4 replies

  14 years ago

  By: preetid2

• Capacity Planning

  good Day. We were used to build an sql server and space is never an issue , but lately this bubble …

  lianvh

  3 replies

  14 years ago

  By: Thomas Stringer

• Performance Units and Performance 'times'.

  Dear reader, There are a number of Performance indicators. For me it is not totaly clear what the U…

  ben.brugman

  3 replies

  14 years ago

  By: Gail Shaw