SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• problem with ISNULL syntax

  I'm trying to use 'ISNULL' to get rid of the NULLS in my results for this cube/pivot query. I've tr…

  SQLalchemy

  3 replies

  12 years ago

  By: Luis Cazares

• SQL Server updates and fixes

  Yesterday MS released a "hotfix" for SQL Server 2008 R2 (and others) MS14-044. I installed this upd…

  SQL_Padre

  1 replies

  12 years ago

  By: Dawn W

• Problem with passing Connection String to Sub-Packages

  Hello everybody, i hope you can help me on this one because i couldn't fix it since monday.. I have…

  moz987

  1 replies

  12 years ago

  By: moz987

• Duplicate Values

  HI There I want to pick someones brain I am using a Trigger to search for existing values in a colu…

  Stix83

  6 replies

  12 years ago

  By: sgmunson

• Clustered index in uniqueidentifiers column

  Hi All, Is it true that putting Clustered indexes on columns that are uniqueidentifiers is not good…

  WhiteLotus

  5 replies

  12 years ago

  By: Jeff Moden

• Display single row

  Hi, I have requirement to display only a single unique row out of the 2 rows. In the attached scree…

  pwalter83

  7 replies

  12 years ago

  By: TomThomson

• Help with SQL Query

  Hi, is it possible to do the following? I have this table: CREATE TABLE test1( [A] [int] NULL, …

  manssourianm

  6 replies

  12 years ago

  By: sgmunson

• CDC from other sources like Teradata

  is it possible to use CDC in SQL 2008 R2 to pull the changes from Teradata? I dump database "as is"…

  Tara-1044200

  1 replies

  12 years ago

  By: sgmunson

• SSIS Script Task - Reading RecordSet object in a loop is failing

  I've collected a dataset and assigned it to an object variable using the RecordSet destination. Bas…

  TheGreenShepherd

  3 replies

  12 years ago

  By: sgmunson

• cannot find database

  I had to database one on my local machine (LM) and one on the network machine (NM). NM had a websit…

  earlcools

  14 replies

  12 years ago

  By: earlcools

• Struggling on Duplicates while Join Three Table Produce

  Hi, I need help on join three tables and wont be duplicate records. I have tried and attached the c…

  SPtrt

  5 replies

  12 years ago

  By: kbhanu15

• Integration Services - test for file exists in folder

  I have a ssis package that reads data in flat files into a sql 2008 r2 database. The flat files ar…

  OldCursor

  1 replies

  12 years ago

  By: TEJABI

• Server and user databases using different collations

  Hi, I have managed to end up with a server and its' system databases using Latin1_General_CI_AS and…

  Fishbarnriots

  4 replies

  12 years ago

  By: John Mitchell-245523

• Tuning a query that takes 60 minutes to run,

  Hello, I have a SQL query that takes 60 minutes to complete, the query is selecting data from 4 tab…

  rajsin7786

  33 replies

  12 years ago

  By: ChrisM@Work

• Help, shrink file not releasing space

  As there are lack of space in the DB hdd and i got several databases in there. I purged lots of rec…

  kenwood0305

  8 replies

  12 years ago

  By: SQLRNNR