SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL multiple key index query : How to find where a combined index contains a unique column on all tables in db

  Let me create an example to illustrate my issue. table = Orders[ RID - Unique autogenerate BigInt, …

  MadAdmin

  5 replies

  14 years, 9 months ago

  By: LutzM

• SQL Server 2008 Convert Rows into INSERT statement

  Hello All, I am working on dynamically generated web form with bunch of controls in an ASP.NET proj…

  SQL_Developer

  1 replies

  14 years, 9 months ago

  By: LutzM

• Question about includes in indexes

  I am using SQL 2008 (64-bit) on Windows 2003 (64-bit), if that makes a difference. Say I have two s…

  n.heyen

  5 replies

  14 years, 9 months ago

  By: n.heyen

• Loading data into database preserving RI with SSIS

  Using VisualStudio2008 Historical Data Migration Migrating data from one Database_A to other Databa…

  kishoremania

  1 replies

  14 years, 9 months ago

  By: kishoremania

• Binary Tree Node Counting Problem Please Help Me!

  Hi all... i am new to SQL Server 2008. For Creating Table : CREATE TABLE binary_tree ( aid bigin…

  talktosivas

  10 replies

  14 years, 9 months ago

  By: talktosivas

• Cell Level Encryption/Decryption

  Hi Folks, I wanted to check if someone has any functions or stored procedure that I can use to encr…

  Laura_SqlNovice

  20 replies

  14 years, 9 months ago

  By: Laura_SqlNovice

• MAXDOP - Multiple Instances question

  Hello, When configuring a SQL Server 2008 R2 server with 5 instances is there a best practice for c…

  David_104

  1 replies

  14 years, 9 months ago

  By: Ninja's_RGR'us

• error message - An invalid floating point operation occurred

  Hi, I get this error message when i run the following code; ERROR: Msg 3623, Level 16, State 1, Lin…

  sdgray01

  3 replies

  14 years, 9 months ago

  By: Ninja's_RGR'us

• Upgrade a SQL Servr 2005 Cluster under Windows 2003 to SQL Server 2008 R2 Cluster under Windows 2008

  Hey all, Firstly apologize if this has already been posed before, i did a search and didn't find a …

  Schadenfreude-Mei

  7 replies

  14 years, 9 months ago

  By: adb2303

• Shrink

  1) Lately I noticed our company developers are hampering the tempdb and every time they run process…

  sqlbee19

  12 replies

  14 years, 9 months ago

  By: jasonmorris

• tempdb going inconsistent after 24hrs

  SQLS: 2008 R2 Express (10.50.1600.1) Hello, I encountered a very strange problem one of my customer…

  Pavle-192195

  8 replies

  14 years, 9 months ago

  By: Ninja's_RGR'us

• Sqlserver 2000 DTS designer components are required to edit the dts packages. Install the special web download "SQLSERVER 2000 DTS Designer Components " to use this package

  Hello, we have n number of dts packages, it has to be migrated from dts to ssis. we have installed …

  balaji.ganga 68339

  2 replies

  14 years, 9 months ago

  By: chandan_jha18

• CAREER ADVICE : From DBA to the world of BI

  Just thought I would put this one out there to see if any of my peers have some advice or maybe som…

  JayK

  3 replies

  14 years, 9 months ago

  By: JayK

• Add a Reference to SSIS

  Hi, Could anybody Please advice how can we add the Reference to GAC or the Object Library in SSIS. …

  gauravin2007

  3 replies

  14 years, 9 months ago

  By: sabotta

• Pleae help: Source of massive new tempdb IO (bytes & stall)

  Hello, On 7/18 my company enabled "pull" Transactional Replication for a large production database,…

  field_ian

  5 replies

  14 years, 9 months ago

  By: field_ian