SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• check varchar column for values that are only numeric - HOW

  One column in the table is varchar(10). This has values like '6.7' , '3' , 'See Comment' ,'00.45' …

  mw_sql_developer

  5 replies

  11 years, 2 months ago

  By: Luis Cazares

• SSRS - remote configuration

  Hi, We are trying to install just the BIDS in a user machine to be able to develop reports remotely…

  shree_z

  1 replies

  11 years, 2 months ago

  By: spaghettidba

• How to tune INSERT query

  Hi all , I wonder how to tune this INSERT Query( it causes high CPU load) : INSERT INTO RTS ( …

  WhiteLotus

  4 replies

  11 years, 2 months ago

  By: Matt Miller (4)

• Backing up 2008 DB to the cloude

  I apologize but I made a mistake and put this in the "7,2000" Forum when it should have gone in the…

  kd11

  2 replies

  11 years, 2 months ago

  By: Grant Fritchey

• In Sql Server 2008, in what database do all the DMV's reside?

  I am trying to do performance tuning on a database that is in production and that I do not have acc…

  Bharatvip

  9 replies

  11 years, 2 months ago

  By: Bharatvip

• Stuck process?

  I'm not sure if I have a problem or not. I'm running an Access application against SQL Server 2008 …

  pdanes

  3 replies

  11 years, 2 months ago

  By: pdanes

• Update Audit Table

  Hi, I have some stored procedures that delete records, or update column values for records based on…

  scotsditch

  4 replies

  11 years, 2 months ago

  By: Steve Jones - SSC Editor

• ICD10 or SNOMED database

  Hi there! Does anyone ever had to work with ICD10 or SNOMED databases? Where did you find or downlo…

  amns

  3 replies

  11 years, 2 months ago

  By: amns

• Conditional logic?

  Hi Everyone, I am attempting to add some conditional logic to a query. The basic premise is as foll…

  david.dartnell

  2 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• need order by in update date column while creating the table

  Hi, I have a table persons,I need to do order by UpdatedDate.but giving the error as incorrect …

  mcfarlandparkway

  7 replies

  11 years, 2 months ago

  By: Steve Jones - SSC Editor

• Need logic - how to control the date from data loaded.

  Hi, I have a date column where the data is loaded every wednesday night,like next 2 weeks data…

  mcfarlandparkway

  3 replies

  11 years, 2 months ago

  By: Jack Corbett

• find if log backup can be run

  Hi, if i set database from full recovery into simple and then back to full recovery i can't run the…

  Mad-Dog

  3 replies

  11 years, 2 months ago

  By: MiguelSQL

• Standard Edition - SORT_IN_TEMPDB

  I got SQL Standard edition of version 2008R2 with a large database table. Initally, when I used to …

  DBA_Learner

  8 replies

  11 years, 2 months ago

  By: Jeff Moden

• Select specific part of the string

  Hi all I have got column in my database which stores referral url. sample values in table ie: http%…

  pahulyi

  3 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Invalid length parameter passed to the LEFT or SUBSTRING function while executing my function

  Hi Folks, While executing the below function iam getting issue , can anyone please help me out to r…

  lefrancisco1

  3 replies

  11 years, 2 months ago

  By: Gail Shaw