SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• how i can set as a PK_ID as Buisnesskey and use Changing Attribute Slowly Changing Dimension in SSIS

  hi I have two different servers, but both have same set of DB and Table Schema. Daily basis Source…

  kumar.atk85

  3 replies

  13 years, 5 months ago

  By: Jason-299789

• Hierarchy: Check Constraint to Prevent Child->Parent and Parent->Child

  How do I write a check constraint which precludes this situtation in a hierarchy table: Child |P…

  trapnell

  3 replies

  13 years, 5 months ago

  By: Jeff Moden

• Query Performance - Advice needed on small query -- plan attached

  I'm not sure why it is using index scans and not seeks. I have indexes on all the tables. SELECT T…

  Michael T2

  16 replies

  13 years, 5 months ago

  By: dave hants

• Image in sql server

  I have a small doubt about image...... In sql server image datatype size has give 2gb or 2,147,483,…

  rajeshjaiswalraj

  4 replies

  13 years, 5 months ago

  By: Ant-Green

• Advanced backup solution - how do we make sure we dont delete the wrond backup file?

  Basic : We take a full backup (BAK) once a week, a differential backup every days (not the day we m…

  ksj 60318

  3 replies

  13 years, 5 months ago

  By: ksj 60318

• Report to have servername as parameter display data

  Hi all, Iam designing report to display the index stat of the server we choose from the dropdown li…

  Minaz Amin

  7 replies

  13 years, 5 months ago

  By: Abu Dina

• INDEX

  Hi All, Today i was working on index i created on table CREATE TABLE EMPLOYEE ( E_ID INT , D_…

  rajeshjaiswalraj

  3 replies

  13 years, 5 months ago

  By: Gail Shaw

• index in sql server

  what are the reason for missing index in sql server

  rajeshjaiswalraj

  3 replies

  13 years, 5 months ago

  By: Gail Shaw

• When AutoShrink will occur in SQL server 2008?

  When AutoShrink will occur in SQL server 2008? When autoshrink set true... But in SQL server 2000, …

  saran.dharsh

  7 replies

  13 years, 5 months ago

  By: Gail Shaw

• Restrict insert or update when taking backup

  Hi, Is there any way to restrict insert or update or delete operation while taking backup.. Thank…

  rj529

  8 replies

  13 years, 5 months ago

  By: Joy Smith San

• Best Way to avoid duplicate rows insertion

  Hi, I am using sql server 2008 enterprise edition. I need to insert large number of rows to my tabl…

  sarankamal2k12

  5 replies

  13 years, 5 months ago

  By: Jeff Moden

• Need assitance interpreting Execuation plan

  Hi, I have a query that needs to be optimized. I have inserted a Tally table to untilize its indexe…

  mpdillon

  4 replies

  13 years, 5 months ago

  By: TheMaskedDBA

• Datetime Syntax

  Hi, I am trying to insert a record in datetime and datetime2 datatype columns. ex: insert into tabl…

  tanvishriya

  6 replies

  13 years, 5 months ago

  By: Gail Shaw

• Purging Data Increases IO performance?

  TLDR: I purged about 50% of the data in a data warehouse during an upgrade and 3 days later, the IO…

  richykong

  5 replies

  13 years, 5 months ago

  By: ScottPletcher

• Loop through table to pass variables?

  I'm looking for a way to run the each of the values in a table to populate a single SELECT statemen…

  DataAnalyst011

  9 replies

  13 years, 5 months ago

  By: DataAnalyst011