SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SSRS Page set up

  I created SSRS report. When I print the report after moved to excel, only half width is in one page…

  mak12

  1 replies

  14 years, 5 months ago

  By: Ant-Green

• CPU and Memory usage

  hi , how to find that a single procedure using how much memory and CPU to execute the particular pr…

  gajananhatkar

  6 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• Unable to shrink transaction log on replicated database - SQL 2008

  Hi, Our main database backup recently started ballooning (rising from 35gb to 75gb) and then starte…

  liam.gavin

  11 replies

  14 years, 5 months ago

  By: liam.gavin

• best practice or Standards for Maintanance task planing

  hi, I need the basic standards or rules or steps to follow when creating a maintanace plan. 1)First…

  FTdenali

  8 replies

  14 years, 5 months ago

  By: Divine Flame

• Audit table

  I want a audit on table which can provide me records deleted ,updated ,insert and also select if po…

  Satya_0000

  3 replies

  14 years, 5 months ago

  By: Devendrakumar

• Unable to import all rows from .csv

  I'm trying to import data from a .csv file into a table and it consistently imports 2033 less rows …

  Kevin Drysdale

  10 replies

  14 years, 5 months ago

  By: tommey152

• index column order for a clustered primary key

  Recently I noticed that some of the indexes supporting primary keys on our tables did not have the …

  R.P.Rozema

  3 replies

  14 years, 5 months ago

  By: R.P.Rozema

• SQL Globalization - DateTimeOffset

  What is recommended/best practice when it comes to storing date/time for an application that needs …

  matt_f

  16 replies

  14 years, 5 months ago

  By: matt_f

• See overview of schedules

  Is there a way to see an overview of all the schedules you have running so you don't set loads of j…

  kyle.doouss

  2 replies

  14 years, 5 months ago

  By: Divine Flame

• Problem with incremental load of data in SQL Server 2008

  Hello, I'm currently migrating SSIS packages from SQL Server 2005 to SQL Server 2008. All loads fro…

  Hans80

  6 replies

  14 years, 5 months ago

  By: Hans80

• enable filestream

  i want to create a data base that works with filestream so i enabled it thru server configuration t…

  jcgldr

  9 replies

  14 years, 5 months ago

  By: Divine Flame

• Splitting a Date range

  Hi, facing a challenge in splitting a date range. Any help is appreciated /* Example Data */CREAT…

  MathewK

  8 replies

  14 years, 5 months ago

  By: Jeff Moden

• High-level overview question - important SQL topics?

  Hi guys, I'm looking for your input on something more highlevel. What I'm looking for is your view…

  chrisph

  6 replies

  14 years, 5 months ago

  By: Steve Jones - SSC Editor

• File group backup and restores

  We have a 1tb database that is expected to grow to 4tb. Right now we are doing full backup weekly …

  Grace Lenz

  4 replies

  14 years, 5 months ago

  By: Gail Shaw

• Intra-query parallelism caused your server command (process ID #50) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).

  Intra-query parallelism caused your server command (process ID #50) to deadlock. Rerun the query wi…

  stephenhai

  5 replies

  14 years, 5 months ago

  By: Elliott Whitlow