SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Procedure Executionn Time Problem

  Hi All, I have a interesting problem and I dont understand cause of problem. Please help me =) On p…

  pektas.isil

  9 replies

  14 years, 11 months ago

  By: pektas.isil

• SQL Server: 70-432 Study Material

  Hi Guys. I just recently passed my SQL Server 2005: 70-431 exam. For that I used the Official Micro…

  seany1977

  12 replies

  14 years, 11 months ago

  By: bravestarr082

• Database Attach Logical consistency error

  Hi All I am trying to attach a database, this has got 4 files one mdf, one ndf and 2 logfi…

  CrazyMan

  2 replies

  14 years, 11 months ago

  By: CrazyMan

• How to remove all keys (including indexes) in a database?

  What is the easiest approach? Many thanks for any input.

  SQL ORACLE

  4 replies

  14 years, 11 months ago

  By: WayneS

• Weird SP issue with CONTAINS taking 10 times longer than LIKE statement.

  I am trying to make the following SP a bit quicker by using the CONTAINS statement vs the LIKE stat…

  isuckatsql

  13 replies

  14 years, 11 months ago

  By: isuckatsql

• Connection Error

  I received the error message below from the application when tried connecting to the database using…

  Eshika

  4 replies

  14 years, 11 months ago

  By: Eshika

• Primary Key and Foriegn Key

  I have a 'Root' table with 8 columns. First 5 columns are to be declared as a Primary key(Composite…

  rohaandba

  4 replies

  14 years, 11 months ago

  By: Steve Jones - SSC Editor

• Data Base design (Table Relationships)

  I have a 'Root' table with 8 columns. First 5 columns in 'Root table ' are used in all 10 child tab…

  rohaandba

  4 replies

  14 years, 11 months ago

  By: Johan Bijnens

• PACKAGE WITH SLOWELYCHANGING DIMENSION TRANSFORMATION

  i have a ssis package the source for the package comes from three different tables and a union all …

  koolme_85

  5 replies

  14 years, 11 months ago

  By: koolme_85

• Service Broker process but stays in CONVERSING state

  I'm trying to take a stab at learning how the service broker works. I need to have a process runni…

  JD Gonzalez

  3 replies

  14 years, 11 months ago

  By: Nils Gustav Stråbø

• Random ordered groups

  CREATE TABLE #TESTSORTING (ID INT ,GroupedCol INT) INSERT INTO #TESTSORTING SELECT 1,1 UNION ALL SE…

  Andy Lucas

  12 replies

  14 years, 11 months ago

  By: ColdCoffee

• Create Index performance - what am I missing?

  Brand new database server (Dell R10, 4 x 8 core), SQL enterprise 256 Gig x 64 bit, attached to EMC …

  Ferguson

  14 replies

  14 years, 11 months ago

  By: Derrick Smith

• SQL 2005 Management Studio / Visual Studio will not load

  I have had SQL 2005 Client tools installed and operating on a Windows 7 64bit system and working fo…

  Chris-174832

  2 replies

  14 years, 11 months ago

  By: Chris-174832

• tempdb best practices on 24-core machine

  Hello, In http://www.sqlservercentral.com/articles/SQL+Server/70505/ it says, "Best practices call …

  Tim L-309246

  1 replies

  14 years, 11 months ago

  By: Gail Shaw

• Change Data Capture (CDC) Retention

  We are looking to utilize CDC in SQL 2008 as a replacement for a long-term historical table. So in…

  datagoat

  2 replies

  14 years, 11 months ago

  By: smart_research