Forum Replies Created

Viewing 15 posts - 136 through 150 (of 616 total)

  • RE: sql 2012 dumps

    ramyours2003 (9/2/2013)

    Can any one send the sql 2012 dumps for getting the certified ?

    Sure, for a small fee 😀

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    September 3, 2013 at 7:29 am

    #1647029

  • RE: Duplicate Rows in certain time

    My attempt:

    create table test (Attribute1 char(1), attribute2 char(1), attribute3 char(1), thetimestamp datetime)

    insert into test(Attribute1, attribute2, attribute3, thetimestamp)

    select 'A', 'B', 'C', '2013-09-02 16:06:30' union all

    select 'A', 'B', 'C', '2013-09-02 16:06:35' union...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    September 2, 2013 at 9:43 am

    #1646776

  • RE: high cpu and parallelism

    You no longer MCM?!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    September 2, 2013 at 9:10 am

    #1646767

  • RE: Simple Index question

    waxb18 (8/30/2013)

    Good Morning All,

    Just a quick question...

    I have a table which updates on a daily basis after 11pm when no-one is here.

    Is it good practise to have the indexes build...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 9:41 am

    #1646410

  • RE: Clause Group By

    Well then your other option is to include this in a case statement in your SELECT

    Something like this:

    SELECT

    CASE WHEN [NAMES] like '%[A-Z]S.R.L.%' THEN REPLACE(Names, 'S.R.L.', ' S.R.L.') ELSE [NAMES] END,...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 8:04 am

    #1646381

  • RE: Clause Group By

    Can you update the Names column in your T40 table?

    UPDATE T40

    SET Names = REPLACE(Names, 'S.R.L.', ' S.R.L.')

    WHERE Names LIKE '%[A-Z]S.R.L.%'

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 7:56 am

    #1646378

  • RE: Query performance

    Sorry Chris 😛

    Well, I've taken a slightly different approach as I can't seem to work out this puzzle. I know this is an ugly way of solving the problem but...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 6:39 am

    #1646335

  • RE: Query performance

    My bad, the latest actual execution plan is for match key type 13, it looks like I generated an actual execution plan for a different match key type before!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 6:09 am

    #1646317

  • RE: Query performance

    Good point about the data types. These have been changed to match the data type of the match key.

    Have a look at this though:

    Running the below (notice the TOP operator)...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 5:57 am

    #1646312

  • RE: Query performance

    Thanks for this Chris.

    I've run my original code again to get the actual execution plan (attached below). Interestingly my original query ran in 15 seconds to produce 234990 records but...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 4:40 am

    #1646287

  • RE: Query performance

    I've also tried materialising the result set of the below query into a table:

    SELECT a.RecordID AS Master_ID,

    b.RecordID AS Duplicate_ID,

    a.Forename AS Master_Forename, b.Forename AS Duplicate_Forename

    FROM MyTable AS a

    INNER JOIN MyTable AS...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 4:03 am

    #1646278

  • RE: Query performance

    Okay I will try again with a simpler version of my problem.

    Say I have the following table records:

    In order to look for duplicates I create hash keys (converted to BIG...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 30, 2013 at 3:53 am

    #1646274

  • RE: Using MERGE to perform the INSERT?

    I don't think its a problem with the code, it's the data that I'm using it's a mess!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 7, 2013 at 2:45 am

    #1639271

  • RE: Using MERGE to perform the INSERT?

    Thanks for this but I'm still getting this error. To be honest I don't even have to use the MERGE statement for this. I just want to be able to...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 7, 2013 at 2:05 am

    #1639248

  • RE: Using MERGE to perform the INSERT?

    Sure!

    INSERT INTO TargetTable (Uarn, BACode, VO_Ref, From_Date, To_Date)

    SELECT Uarn, BACode, VO_Ref, From_Date, To_Date

    FROM

    (

    MERGE TargetTable AS tgt

    ...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

    August 7, 2013 at 1:07 am

    #1639235

Viewing 15 posts - 136 through 150 (of 616 total)