SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Count delimiters in field containing CSV

  A table has a column that holds the contents of a csv file, text identified with double quotes. I …

  1974lg

  3 replies

  14 years, 7 months ago

  By: 1974lg

• Optimization of Sql Server OLE DB connection to Db2

  HI My queries runs much faster on MS Access using ODBC connection to Db2 compare to SQL Server OLE …

  SAS.DHRUV

  1 replies

  14 years, 7 months ago

  By: PaulB-TheOneAndOnly

• Full backup of user database failed.

  hi...guys The backup of full-text catalog 'EMGR_Item1_FullText' is not permitted because it is not …

  Saggy

  7 replies

  14 years, 7 months ago

  By: Ant-Green

• Bulk Insert - (0 row(s) affected)

  Hello, I have a .csv file which contains 4 million records. I am using Bulk Insert command to impor…

  SQLRO

  6 replies

  14 years, 7 months ago

  By: Jared

• Converting data of column into column name

  Hi , I have a query which return the data like in sql server param_value display_value 6…

  visaforuk

  6 replies

  14 years, 7 months ago

  By: LutzM

• When is the inner query of the exists statment ran?

  Is the inner query of the exists statement ran for each outer query check? Or is it done before? …

  Libby

  2 replies

  14 years, 7 months ago

  By: Libby

• SPN

  I have installed default instane sql server 2008 r2 and found error in sql log about SPN. "The SQL…

  bala2

  5 replies

  14 years, 7 months ago

  By: Ant-Green

• NT AUTHORITY\ANONYMOUS LOGON - Login Failed - Token-based server access validation failed with an infrastrcture error

  Hi All Recently moved to a new company and just getting my head around the infrastrcture at the mom…

  Ant-Green

  8 replies

  14 years, 7 months ago

  By: calvo

• Update with order by

  -- I Have a table create table #temp ( Name varchar(10) ,ID int NULL ) INSERT INTO #temp select 'a…

  ramrajan

  6 replies

  14 years, 7 months ago

  By: Eugene Elutin

• setting affinity mask in sql 2008 ( not R2)

  I need to limit the number of CPU's to 20 for an instance of SQL Server 2008 (Not R2). Based on the…

  winston Smith

  1 replies

  14 years, 7 months ago

  By: Ant-Green

• Cannot update 2008 R2 Enterprise SP1 to CU3

  Hi All, having a frustrating problem, I have a default instance running 2008r2 enterprise (recent…

  Loundy

  4 replies

  14 years, 7 months ago

  By: Loundy

• Different Logical Read with same query and SP

  While i am executing the same query using SP,logical reads goes very high (About -80k). But when i …

  EasyBoy

  11 replies

  14 years, 7 months ago

  By: EasyBoy

• Upgrading SQL Server 2008 From Standard Edition to Enterprise.

  I am trying to upgrade SQL Server 2008 from Standard edition to Enterprise edition in a two node cl…

  Motomoto

  3 replies

  14 years, 7 months ago

  By: Loundy

• SQLServer 2008 R2 SP1 faile to start.

  Hi guys...... 2012-02-20 01:23:29.36 Server Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 …

  Saggy

  12 replies

  14 years, 7 months ago

  By: SQLCereal

• Current Date issue in where clause

  I am trying to write a query that pulls our new orders for the current day. Where FM.Openeddate =…

  Jeremy...

  22 replies

  14 years, 7 months ago

  By: Jared