SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Serach for a particular string in different columns in a table

  Hi, is there a simpler way to search for a partcular string in different columns in a table. curren…

  Trybbe

  3 replies

  13 years, 4 months ago

  By: Dung Dinh

• understanding client statistics information in sql 2008

  I just want to know how exactly client statistics works and as DBA for query performance what param…

  sej2008

  1 replies

  13 years, 4 months ago

  By: Vegard Hagen

• =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1) Errors, but does not give me an error code

  =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates,…

  Gillian_Pappas2002

  5 replies

  13 years, 4 months ago

  By: Ant-Green

• weird memory usage on sql server

  Hi Folks, I got this weird issue on sql server. I am running window 2008 r2 enterprise 64 bit with …

  djordan 4543

  16 replies

  13 years, 4 months ago

  By: Bhuvnesh

• I NEED HELP WITH SQL EXPRESS 2008 R2

  I am a newbie just been doing this for about 3 mo's. I installed sql and all went well. During setu…

  lonhanner

  3 replies

  13 years, 4 months ago

  By: lonhanner

• I need help with my query. I found part of this, but doesn't work. Please help.

  I need to get the emails from the n.Note field, which is a nVarchar(max) column. I have the follow…

  tbmabry

  44 replies

  13 years, 4 months ago

  By: Dwain Camps

• Schedule DTS package

  Hi Team, How should I schedule DTS package for 2000 server using sql management studio?? I dont hav…

  mssqlsrv

  2 replies

  13 years, 4 months ago

  By: @SQLFRNDZ

• Need to create report with sql query

  Hi Friends, I am having data structure like: create table tbl_student (studentid int identity(1,1),…

  shubham.saxena67

  1 replies

  13 years, 4 months ago

  By: Sean Lange

• Problem inserting values from one column to another in a different table

  Processing Database Procedural Code insert_into_agency_deplo_plan failed. declare @nCount int selec…

  johnhg9

  9 replies

  13 years, 4 months ago

  By: johnhg9

• Need help using the most efficient aggregation method in SQL Server 2008 R2 to sum up child rows in same table

  I need to find a way to do an INSERT into the same table (named ResultsHistory) by summing up the c…

  steve.pantazis

  13 replies

  13 years, 4 months ago

  By: steve.pantazis

• Restoring database from DPM snapshot

  Hi there, We are currently reviewing our backup routines/recovery plans as we found that we were ma…

  christina.constantinou

  5 replies

  13 years, 4 months ago

  By: jasona.work

• Sequential YYYYMM calc problem

  First the code... DECLARE @Current INT DECLARE @Prev1 INT DECLARE @Prev2 INT DECLARE @Prev…

  Digs

  8 replies

  13 years, 4 months ago

  By: Steven Willis

• Shrink database

  I received this from a vendor as part of recommended maintenance for sql 2008R2 databases. I alway…

  Terrie

  18 replies

  13 years, 4 months ago

  By: GSquared

• Restore from network drive

  Hi All, i have a backup on the network drive. and i want to restore it on my local server.....but t…

  R.KU.PA_DBA

  8 replies

  13 years, 4 months ago

  By: Ant-Green

• Column Name Case Sentive

  Hi, im Matias from Argentina, i need to know if exist a way to change the collation of the TABLE co…

  matiaskenig

  8 replies

  13 years, 4 months ago

  By: matiaskenig