SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Remote query parameterization problem.

  Hi All, In stored procedure i have used the remote query it tooks very long time insert records al…

  deepak.a

  1 replies

  14 years, 9 months ago

  By: deepak.a

• Linked Server query - "Invalid Object Name"

  I have 3 servers that each have a link to "SERVER4". On two of the servers I can run this query: S…

  marykdba

  10 replies

  14 years, 9 months ago

  By: IGW

• database performance

  can any one suggest on this how to achieve on the below of the database pefromance ?…

  ramyours2003

  3 replies

  14 years, 9 months ago

  By: Gail Shaw

• i Can't generate my transact SQL to run ETL system

  i Can't generate my transact SQL to run ETL system, I have an error Microsoft (R) SQL Server Execu…

  redinetsis

  3 replies

  14 years, 9 months ago

  By: Fal

• Please help error : Could not load package "\File System\XXXXX" because of error 0xC00160AA.

  Please help error : Could not load package "\File System\XXXXX" because of error 0xC00160AA. This i…

  redinetsis

  1 replies

  14 years, 9 months ago

  By: SQLRNNR

• Settings for "Script Table As..."

  It used to be that when you right clicked on a table to script it, one of the menu options on the p…

  Jeff Moden

  7 replies

  14 years, 9 months ago

  By: Jeff Moden

• Distributed DB Decision Tree - SQL Server Specs

  I am working on developing a decision tree for a distributed database solution. I am tasked with d…

  atmonge

  5 replies

  14 years, 9 months ago

  By: Maxim Picard

• Counting multiple records as one

  I have a temp table that has millions of records. Some of these records would be the same call that…

  bopeavy

  6 replies

  14 years, 9 months ago

  By: LutzM

• Cannot view query execution plan because of "select into" temp table statement

  Is there a way in SSMS to view the query plan for t-sql that includes a temp table created using "s…

  cgm/

  1 replies

  14 years, 9 months ago

  By: SQLRNNR

• Performance of LIKE with leading wildcard

  I am currently working on a project for a state agency that has requested "auto complete" functiona…

  Jeff K

  1 replies

  14 years, 9 months ago

  By: sturner

• Summarizing showing non criteria data

  Hi guys, i have this code that works: declare @Station nvarchar(4), @BeginDate datetime, @EndDate …

  timotech

  11 replies

  14 years, 9 months ago

  By: Sean Lange

• DTS Package Error

  Hi I am getting following error can anyone give solution The execution of the following DTS Package…

  naresh.talla

  1 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• Problems with DBCC SHRINKFILE

  Hi I've got an transaction log that is 5110mb with 99% free space and would like to shrink this to …

  andy.l

  5 replies

  14 years, 9 months ago

  By: Jim Murphy

• Error while copying from View to Table (1M+ Records)

  Hello, When I try to copy the records from my view(1M+ records) to another table, I am getting the …

  Mounish

  2 replies

  14 years, 9 months ago

  By: Mounish

• Scripting modifications to a maintenance plan

  Hi everyone, Is it possible to script modifications to a maintenance plan? Lets say I would need to…

  Carl B.

  2 replies

  14 years, 9 months ago

  By: Carl B.