SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Error: 0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source 1" (1) returned error code 0xC0202009.

  Basic Info: Same package on SQL Server 2005 - Was working fine See Attachment. Upgraded to 2008. I…

  jd_gajera

  1 replies

  15 years, 5 months ago

  By: maria.thomadakis

• Does we should worry about informational message in error logs?

  Hi, SQL Server Logs some Informational messages in error log. I have found like "This instance of S…

  Ramdas

  2 replies

  15 years, 5 months ago

  By: Steve Jones - SSC Editor

• Report Processing Has Been Canceled By The User

  I am getting the below error when I execute SSRS report from asp.net application. Report Processing…

  amit-1143912

  2 replies

  15 years, 5 months ago

  By: amit-1143912

• Performance Tuning

  Performance Tuning

  vijay1327-891581

  11 replies

  15 years, 5 months ago

  By: mberry 51447

• MERGE statement performance

  Hi I have an SP that works on a few thousand rows at a time, and as part of its work, does multiple…

  Atat Rowcount

  3 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• Page Life Expectancy

  Hi, I have always monitored our server and looked at performance stats. The page life has always be…

  markganley

  14 replies

  15 years, 5 months ago

  By: Grant Fritchey

• sys.dm_db_index_usage_stats. why are there multiple values in the Database_ID column?

  I believe the dmv sys.dm_db_index_usage_stats is database dependent. What i mean is if i set the co…

  winston Smith

  1 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Foreign key displays null

  Attached is an example of the query. After writing this code and running the query , the Job Title …

  kennywashington2000

  10 replies

  15 years, 5 months ago

  By: kennywashington2000

• Some basic Clustering Questions

  I've been asked to build an Active/Active/Passive SQL 2008 R2 Cluster for our OLTP setup, and an Ac…

  PhilipC

  1 replies

  15 years, 5 months ago

  By: MysteryJimbo

• Buisness Intelligence (BI) Architect Document needed

  Hello Friends Can anybody please provide me Buisness Intelligence (BI) Architect Document ? Or Link…

  ajit.ghule

  4 replies

  15 years, 5 months ago

  By: steveb.

• TRIGGER and ERROR LOGGING

  Hi, I have a trigger that works well. But I do want errors logged. For starters, I added these line…

  Raymond van Laake

  3 replies

  15 years, 5 months ago

  By: Raymond van Laake

• SSIS Package or Script

  I do have one table in server - Production Server name.Table1 and second table in dev server- devel…

  EasyBoy

  6 replies

  15 years, 5 months ago

  By: saurabh.deshpande

• Apply partition concept to existing table

  I have created partition function and partition scheme. I already have a table with 70 lakhs of rec…

  amit-1143912

  4 replies

  15 years, 5 months ago

  By: winash

• Connecting to SQL Server from remote Linux box

  There are a few cases where I might need to connect to a SQL Server installation remotely, from a L…

  e1785

  1 replies

  15 years, 5 months ago

  By: Leju Geevarghese

• Duplicates returned even using DISTINCT and WHERE NOT IN

  I have a table with nearly 6,000 rows that needs to be updated with new rows periodically. The upd…

  jerry-621596

  10 replies

  15 years, 5 months ago

  By: Derrick Smith