SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Good, free, simple database modelling tools

  Hello Are there any good, free, simple database modelling tools out there? I'm not really after som…

  DamianC

  3 replies

  11 years, 1 months ago

  By: ScottPletcher

• SSRS design queries.

  Hi there, I'd appreciate a sanity check as I'm the sole DBA for my environment. I'm still digesti…

  snomadj

  1 replies

  11 years, 1 months ago

  By: roger.price-1150775

• Change Ship date on SSRS report

  Hello All, I've a SSRS report that reports the 'ScheduledShipDate' based on 'Requested Delivery dat…

  SSRS Newbie

  7 replies

  11 years, 1 months ago

  By: SSRS Newbie

• intersect issue

  Hi all I have 2 sql queries that each of them take 5 sec but when i am using INTERSECT its take 20…

  eyalso

  3 replies

  11 years, 1 months ago

  By: Grant Fritchey

• sp_updatestats behaviour

  Hi, just looking for some confirmation that what I'm observing is reasonable. I took advantage of s…

  Sporidium

  5 replies

  11 years, 1 months ago

  By: Gail Shaw

• SSIS Flat File Connection Issue

  Hi Guys I am having some trouble here. I have a package that should pick up a .csv package daily, h…

  coetzeehuman

  5 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• Steps to making a datawarehouse

  Hi, i was asked to make a datawarehouse. the way i understood things, i would say i am supposed to …

  feten_

  1 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• Join another table but with select conditions

  Hi, I have this sql.... Select DISTINCT p.dbPatID, p.dbpatfirstname, p.dbPatLastName, s.dbSchTy…

  mattech06

  14 replies

  11 years, 1 months ago

  By: ChrisM@Work

• Data Import issues with a CSV file for an SSIS package

  Hello all, I'm trying to create an import package using BIDS. I'm using SQL Server 2008. The data i…

  glycere2000

  4 replies

  11 years, 1 months ago

  By: glycere2000

• Data fetching 80 million records ??

  Hi, plz help me i have table below CREATE TABLE [dbo].[DR_Test]( [source_item_id] [int] NOT NUL…

  santoshkal

  3 replies

  11 years, 1 months ago

  By: ricardo_chicas

• job failed for time out of connection

  Hello, We have a web service job running nightly. But last night it failed with the following messa…

  sqlfriend

  4 replies

  11 years, 1 months ago

  By: sqlfriend

• How Can I Tell the Number of Times People Use SSMS to Change Client Data

  Guys, I'm trying to quantify the number of times folks use SQL Server Management Studio to change c…

  timthetraveler

  6 replies

  11 years, 1 months ago

  By: SQLRNNR

• rename hostname in SQL server cluster

  Good Day, Kindly i need your interaction and support regarding below case : I have Cluster SQL Serv…

  halmuslim12

  4 replies

  11 years, 1 months ago

  By: halmuslim12

• Data arrangement - columns to rows in a specific way

  Anju Renjith

  7 replies

  11 years, 1 months ago

  By: DaPainKiller

• Inner Join With Complex Condition

  I have Two tables @master-2 and @child Master Table : MasterID EntryNumber BranchId IsstockIn …

  pradeep.joy21

  6 replies

  11 years, 1 months ago

  By: pradeep.joy21