SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 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

  11 years, 8 months ago

  By: mikeg317X

• Update rows using triggers

  Hi, I have a table with a column which has list of ID in numbers. Any number can be master and chil…

  vigneshkumart50

  2 replies

  11 years, 8 months ago

  By: Sean Lange

• Load flat file data into SQL database.

  Hi, I have nearly 1 TB of CSV file data .I need to load this data into SQL database using SSIS.What…

  gstarsaini

  3 replies

  11 years, 8 months ago

  By: Ed Wagner