SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• HTML in SSRS

  Hi, Can anyone help me in getting the output in SSRS for HTML input. In Textbox i have belo…

  jeganbenitto.francis

  9 replies

  12 years ago

  By: Koen Verbeeck

• Snippet Repositories

  Hello Now and again, I would spot someone saying they pulled a code response they gave a poster fro…

  CKX

  4 replies

  12 years ago

  By: CKX

• Problem Installing adventureworks2008 on windows8

  Hi I am trying to install adventureworks2008 on windows 8 on which sql 2008 is installed but getti…

  sej2008

  4 replies

  12 years ago

  By: Grant Fritchey

• Access to a table

  Hi I have a database and table dbo.Test_Table, with list of Users under Security -> Users. those…

  hoseam

  4 replies

  12 years ago

  By: Grant Fritchey

• PK column don’t have constraint?

  Hi, I verified the one of the vendor production database, By default PK does not allowed duplicate…

  SQL Galaxy

  8 replies

  12 years ago

  By: Grant Fritchey

• Using BIDS to load Flat Files, How to Skip Empty Rows?

  I'm building a package to load flat files and have found that some of my files have empty rows at t…

  bkmooney

  1 replies

  12 years ago

  By: SQLCJ

• Replication and Mirroring

  Hi guys, I have 3 sql servers A, B, C A has the principal DBs. B has the mirror DBs. A replicates t…

  _nzrdb6

  2 replies

  12 years ago

  By: Yuri55

• Networkname no longer available message.

  We have been receiving many of these lately. Sql Server 2008. (provider: TCP Provider, error: 0 - T…

  rocco_46902

  2 replies

  12 years ago

  By: rocco_46902

• How to change default query file directory in SSMS 2008R2.

  I am moving from SQL Server 2000 to SQL Server 2008R2. Using SQL Query Analyzer for SQL Server 2000…

  hmbtx

  5 replies

  12 years ago

  By: JJR333

• SSIS Expressions

  How to write a DATEDIFF function inside a Derived column of an SSIS Package. Im trying to have thes…

  nthetengm

  8 replies

  12 years ago

  By: kiran.vaichalkar

• large-ish tables, poor query plans - db architecture question

  Hi everyone, My client has a db that is 94% reads, 6% writes. There are two tables that have ~100…

  sqlnyc

  5 replies

  12 years ago

  By: Grant Fritchey

• please provide me a update statement for the below sql select statement to increase the time by one hour

  SELECT RiseSet.GregorianDate ,RiseSet.SunRise ,RiseSet.S…

  dheeraj.annavaram

  2 replies

  12 years ago

  By: dheeraj.annavaram

• Any risks placing tempdb on raid 0 ssd drive?

  Hi, I want to improve performacne of my SQL servers. recently I've used a test server where I place…

  shmuelk

  9 replies

  12 years ago

  By: Evil Kraig F

• Copy from Excel file into SQL table using BCP

  Hello, Is there a way to run a BCP utility to read excel file and copy into Sql table? I am aware o…

  tracmonali

  6 replies

  12 years ago

  By: Jeff Moden

• Update Query

  Hi All, I need help on updating following tables. Please suggest best way in terms of performance p…

  vijaykumar587

  5 replies

  12 years ago

  By: Jeff Moden