SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Reduce size of TRN log & backup DB to UNC path (SQL2008) - Help please

  Hi - I have a couple of DB's that have trn logs that are far bigger than the data files. MDF file a…

  dax.latchford

  11 replies

  12 years, 5 months ago

  By: Grant Fritchey

• Maintenance Plan Error - File in Use by Another Process

  We just moved to Server 2008 (from 2000) and after setting up the maintenance plans, everything see…

  brian.stewart

  7 replies

  12 years, 5 months ago

  By: webtomte

• Display Sum() value based on Grouped datafield value

  Good Day This is my SQL Query. Everything after the 3rd line is required due to dependancies. SELE…

  BlackIceAngel

  3 replies

  12 years, 5 months ago

  By: Sean Lange

• Memory trouble shoot

  i have 3 instances in a cluster , one of th einstance is using high memory utilisation , how cna w…

  ramyours2003

  2 replies

  12 years, 5 months ago

  By: ramyours2003

• DateTime Problem

  Hello All, I am running into a problem trying to subtract my datetime cloumn from current datetime…

  RazorbackDBA

  2 replies

  12 years, 5 months ago

  By: RazorbackDBA

• Odd issue with leading zero's from a varchar being dropped.

  Hi all, Got an issue that I can't work out. I have 2 tables, with "clientcode" field that in both i…

  Matthew.Procter

  4 replies

  12 years, 5 months ago

  By: Lynn Pettis

• Faster Querying

  Hi Everyone, Total records : 2,50,0000. select A.C1, Max(DateDiff(D, Coalesce (Date1,Date2,Date3…

  koti.raavi

  6 replies

  12 years, 5 months ago

  By: ScottPletcher

• Help With Trigger Delete SQL

  Hello everyone. I have a problem and hopefully help me. I created a delete trigger after the time o…

  boks_18

  5 replies

  12 years, 5 months ago

  By: ScottPletcher

• SSIS - how to make the control flow continue before the current step is complete?

  I have a query that polls a table for scheduled ETL tasks to initiate. The query gives me the packa…

  TheGreenShepherd

  4 replies

  12 years, 5 months ago

  By: TheGreenShepherd

• Backing up and index creation will those have cross effects on each other

  Hi all, I am backing up a 3 tb database and it's spawning across multiple threads and at the same t…

  Feivel

  4 replies

  12 years, 5 months ago

  By: Grant Fritchey

• Execution Plan

  Good Day, I sometime see in the Execution plan's output it displays the solution chk**** . what doe…

  lianvh 89542

  4 replies

  12 years, 5 months ago

  By: Grant Fritchey

• Need assistance writing a sql script for sql 2008

  Hello, I am new to SQL and scripts in general so please bear with me. There are 3 tables involved:…

  wcharlton1

  3 replies

  12 years, 5 months ago

  By: wcharlton1

• Total in pivot Statement

  Hello, I am using the query below to find the number of anti-coagulant medications prescribed per h…

  M Joomun

  8 replies

  12 years, 5 months ago

  By: Luis Cazares

• Will Database backup help in performance ?

  My database is a stand alone, The database was not backup for past 2 years. The data will be insert…

  yuvipoy

  5 replies

  12 years, 5 months ago

  By: Ed Wagner

• (Could not find stored procedure 'msdb.dbo.sp_dts_getfolder'. - sql 2005 - > 2008 R2

  I have a package on 2008r2 and job on 2005 pointing to the package on 2008r2. When i run the job i …

  rockon_dba

  7 replies

  12 years, 5 months ago

  By: mikeg317X