SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• DB server comes to a crawl every two weeks

  We have had an on going issue with our ERP system that neither Microsoft nor three consulting forms…

  TC-416047

  15 replies

  12 years, 3 months ago

  By: TC-416047

• Can this be done with analytics?

  hi, i have a minor dilemma, you've never let me down before. thanks in advance. i have this table: …

  manssourianm

  2 replies

  12 years, 3 months ago

  By: Nevyn

• Moving files while the database is online

  Hi, I am trying to moving the database files while it is online, instead of detach and attach metho…

  ramana3327

  10 replies

  12 years, 3 months ago

  By: chandan_jha18

• dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72 ??

  Hi Sorry for the upcoming vagueness.... I have a replication job and have recently run out of space…

  jbalbo

  2 replies

  12 years, 3 months ago

  By: jbalbo

• High Availability Clustering and SQL SERVER 2008

  We have been implementing High Availability Clustering which includes disk mirroring (data mirrorin…

  darklight_arizona

  8 replies

  12 years, 3 months ago

  By: EdVassie

• Query for specific format

  I'm trying to find discrepancies in a telephone column in the client table and identify any telepho…

  caippers

  8 replies

  12 years, 3 months ago

  By: Jeff Moden

• Transactional Log file issue

  Dear All, There have been issues in the past where the transactional log file has grown too big tha…

  tt-615680

  7 replies

  12 years, 3 months ago

  By: george sibbald

• BaseLine

  Hi, I am new to the SQL Server. I am trying to take baseline. I saw some videos and took some count…

  ramana3327

  5 replies

  12 years, 3 months ago

  By: Grant Fritchey

• Exporting Data directly into Excel from SQL makes it too big to handle

  Hi, I have a situation where I have to pull 2.2 million records with 302 columns. I cannot run quer…

  pujain

  10 replies

  12 years, 3 months ago

  By: Greg Edwards-268690

• How to learn ssis (step-step)

  Hi, I am totally new to SSIS, please guide me where to start learning SSIS 2008. Is there any e-boo…

  llllllllllllllllll

  5 replies

  12 years, 3 months ago

  By: prabhu.st

• Checking columns in two similar tables

  Can u help me with this query? For every table in my database there is a duplicate table with same …

  gautham.gn

  6 replies

  12 years, 3 months ago

  By: Perry Whittle

• Interaction between MS Access/ODBC and SQL on remote host.

  I have an MS Access 2007 database that I use to connect, via ODBC, to a SQL Server DB on a remote h…

  matt6749

  3 replies

  12 years, 3 months ago

  By: rf44

• Memory Allocation Across Multiple Database Instances

  Hi there, I have a query on how SQL allocates memory across separate database instances. I have…

  arrjay

  11 replies

  12 years, 3 months ago

  By: Gail Shaw

• using datediff against datapart

  Hi, Am using sqlserver 2008 R2 Below is my current Query select sum(Amount) from Coupon_Amount whe…

  born2achieve

  4 replies

  12 years, 3 months ago

  By: born2achieve

• Data Export to .csv file

  Hello I need to export data to .csv file, but problem in some of the FirstName contain commas value…

  yogi123

  2 replies

  12 years, 3 months ago

  By: Revenant