SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• begin transaction

  Hi all, suppose you submit the following batches one hour apart using the same connection: Batch 1:…

  weston_086

  1 replies

  14 years, 7 months ago

  By: Adi Cohn-120898

• Regular Expressions in Update query

  Hi all, I've read about regular expressions in sql server, but have not seen examples of updating d…

  mcalexster

  1 replies

  14 years, 7 months ago

  By: spaghettidba

• Can we put thresholds for logn running queries.

  As i am executing the query it is running continusly but when i see with sp_who2 it is showing susp…

  mohan.bndr

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

  hello all. I work with sql server 2008 on windows xp service pack3.I use this : set @str='select *…

  elham_azizi_62

  1 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• char() vs. varchar()

  I have done research and I am not finding any detailed information about what I am looking for rega…

  dpulliam3

  8 replies

  14 years, 7 months ago

  By: kuldipMCA

• Add ranking field based on race name

  Hi, I'm working on a results processing procedure that takes raw race results data (race number, el…

  runweb

  4 replies

  14 years, 7 months ago

  By: Adi Cohn-120898

• Adding INSERT INTO ... to SELECT statement causes it to run significantly longer than expected

  Hi all, I have been having an issue with an INSERT INTO ... SELECT statement taking a disproportion…

  darrylc-ssc

  14 replies

  14 years, 7 months ago

  By: darrylc-ssc

• Query to update values

  can anybody help me with the query that updates the PRIMARY_DC_ID column in SHP_MANIFEST table? Th…

  Confusing Queries

  3 replies

  14 years, 7 months ago

  By: Possinator

• NEED HELP WITH ERROR MESSAGE

  I'm not sure what I'm doing wrong. This is my syntax and the error: INSERT INTO Employee (EmployeeI…

  spro1210

  2 replies

  14 years, 7 months ago

  By: spro1210

• IT Budget

  I need to consider tools,software and hardware that I have to forward to management.I do not want t…

  kapfundestanley

  9 replies

  14 years, 7 months ago

  By: Steve Jones - SSC Editor

• Maintenance Plan

  Hi All, I have two questions regarding to Maintenance Plan in specific to History Cleanup Task and …

  learningguy

  2 replies

  14 years, 7 months ago

  By: Jeffrey Williams

• SQL Query Assistance - Filtering on unique Patients by specific provider with shared patients

  What I am hoping to accomplish in this query is the following: 1. To find a list of patients that h…

  Jeffs1977

  2 replies

  14 years, 7 months ago

  By: Jeffs1977

• Is this a bug in SQL Server? A trailing space in a database name = Backups fail.

  Using SQL 2008 R2 Enterprise, create a database named 'MyDb ' with a space at the end of the databa…

  jpSQLDude

  8 replies

  14 years, 7 months ago

  By: cphite

• LCK_M_U lock wait

  I've got a SQL 2008 server experiencing a high percentage of LCK_M_U wait times. It's a service br…

  Steve-443559

  2 replies

  14 years, 7 months ago

  By: Gail Shaw

• SQL Jobs

  Can any one tell me Is there any way to find out whether a particular table is getting effected by …

  chandrika.r 91171

  10 replies

  14 years, 7 months ago

  By: spaghettidba