Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 6,486 total)

  • RE: Stopping Duplicates with INSTEAD OF INSERT Problem

    The Dixie Flatline (3/26/2010)

    Hey Matt... I just got some new glasses.

    Is your avatar the Master Control Program from "Tron" ??

    The user "Matt" you speak of has been terminated from...

    March 26, 2010 at 11:48 am

    #1140621

  • RE: Stopping Duplicates with INSTEAD OF INSERT Problem

    Eric Zierdt (3/24/2010)

    The Dixie Flatline (3/24/2010)

    The duplicates you mention: Are they simply duplicates of the [TableID], or is the [createdTime] also identical. Since it's a...

    March 26, 2010 at 9:01 am

    #1140429

  • RE: Importing XML through SSIS

    Slick84 (3/25/2010)

    Matt,

    I was able to import the XML at the very simple level. But it seems very tedious to define multiple XSDs for each level as my XML file is...

    March 25, 2010 at 10:26 am

    #1139791

  • RE: Importing XML through SSIS

    I usually just start easy. Having been bitten before by trying too much difficulty at once with SSIS, I "simplify the scenario" first: make a single level work with Preview,...

    March 24, 2010 at 8:26 pm

    #1139353

  • RE: Importing XML through SSIS

    What have you tried?

    I just created an XMLsource, let it generate a schema for it, then tied the two together and dumped the results to a table. Data ensues.

    Where...

    March 24, 2010 at 4:13 pm

    #1139290

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/20/2010)

    Lynn Pettis (3/20/2010)

    Yes, READ UNCOMMITTED can be the right choice for many applications, the problem comes when it is selected and it isn't appropriate and people start...

    March 20, 2010 at 7:13 pm

    #1137288

  • RE: Does the choice of Simple vs Full Rec. Model in non-system DBs affect tempdb space?

    Ray Laubert (3/19/2010)

    I have to take acception to one of the comments above. The selection of simple vs full is not made based on when you do a full...

    March 19, 2010 at 9:40 am

    #1136838

  • RE: Send output of "Execute Sql Task" to a table

    Elliott W (3/18/2010)

    Before saying "don't use SSIS for this" you need to ask more questions. The biggest one is how much data are we talking about?

    Lets say 100,000 rows....

    March 18, 2010 at 12:50 pm

    #1136228

  • RE: Send output of "Execute Sql Task" to a table

    VG-619426 (3/18/2010)

    Why do you want to use SSIS for this? A simple insert into, select will do right?

    If you have to in SSIS, then have dataflow task with oledb source...

    March 18, 2010 at 12:46 pm

    #1136222

  • RE: Security Regulations

    Kevin Wood-419472 (3/17/2010)

    I agree with the industry-wide best practice solution and certification agruments. The free market has done fairly well guarding against problems. There's no Utopian solution. Security...

    March 17, 2010 at 2:12 pm

    #1135543

  • RE: Statistical formula question

    Steve Jones - Editor (3/11/2010)

    It looks like some sort of weighted average. Not sure. The denominator label throws me off. You really have

    sum (count * average) / sum ( count)

    It's...

    March 11, 2010 at 2:11 pm

    #1132316

  • RE: Brain Fried

    Lynn Pettis (3/10/2010)

    Matt Miller (#4) (3/10/2010)

    Jeff Moden (3/9/2010)

    Most DBAs, whether System, Application, or Hybrid, don't know everything about SQL Server. There's just not enough time in the day. ...

    March 11, 2010 at 9:52 am

    #1132163

  • RE: where clause need to pull datetime column for yesterday at 3:00 pm to current time

    The second is likely failing because you're not in SQL 2008 (or your DB is set to a lower compatibility level).

    #2 doesn't work without the "simpler date" data type, so...

    March 10, 2010 at 2:45 pm

    #1131661

  • RE: Brain Fried

    Jeff Moden (3/9/2010)

    Most DBAs, whether System, Application, or Hybrid, don't know everything about SQL Server. There's just not enough time in the day. Some do better than others...

    March 10, 2010 at 2:38 pm

    #1131660

  • RE: SQL QUERY TAKES more than 4 mnts....any help me plz..

    Agree with above comments. One thing that jumps out immediately: using DISTINCT in an EXISTS or IN clause just slows it down.

    Also - how many rows are in...

    March 10, 2010 at 7:46 am

    #1131415

Viewing 15 posts - 1,441 through 1,455 (of 6,486 total)