Forum Replies Created

Viewing 15 posts - 91 through 105 (of 264 total)

  • RE: hyperthreading on enterprise licenses??

    Thanks that was what I was thinking too. I think our reseller is being a bit daft - we'll get quotes from some other resellers and see what they say.

    worst...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    August 2, 2012 at 6:09 am

    #1520748

  • RE: Using Technology In New Ways

    paul.knibbs (7/19/2012)

    How do you determine that without knowing the circumstances, though? They might have got a massive g-force spike because they were braking to avoid running into a jaywalking nun,...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    July 19, 2012 at 9:37 am

    #1514950

  • RE: Using Technology In New Ways

    jay-h (7/19/2012)

    BenWard (7/19/2012)

    jay-h (7/19/2012)

    Well in a less privacy intrusive direction:

    Lol it's only 1 insurance product of many that we sell, it's only used for customers who request it 😛

    Funny enough...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    July 19, 2012 at 6:38 am

    #1514803

  • RE: Using Technology In New Ways

    jay-h (7/19/2012)

    Well in a less privacy intrusive direction:

    Lol it's only 1 insurance product of many that we sell, it's only used for customers who request it 😛

    Funny enough despite working...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    July 19, 2012 at 6:30 am

    #1514790

  • RE: Using Technology In New Ways

    I work for an insurance company who sell a product that uses telematics equipment to monitor drivers performane.

    Essentially we install a black box in their car that has a 3G...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    July 19, 2012 at 2:02 am

    #1514656

  • RE: stupid question about tcp connections

    Thanks that's very useful information that I will file away to the back of my mind for future reference! Does assist to prove the point that our SQL Server is...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    July 13, 2012 at 9:13 am

    #1512609

  • RE: Fix Failures Fast

    thadeushuck (7/3/2012)

    I'd like to see the linux/Unix community do a similar study on their installed user base. Better not hold your breath the Unix guys will complain they can't do...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    July 3, 2012 at 7:34 am

    #1508236

  • RE: Fix Failures Fast

    Very interesting topic this. There are lots of servers out there running consumer grade equipment for sure so definately worth looking out for.

    Although I'm not sure that server grade stuff...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    July 3, 2012 at 3:02 am

    #1508086

  • RE: Why does my scalar funtion not complete?

    in case any-one else stumbles accross this thread having had similar issues, theres a great explanation of the issues with out-of-date statistics here:

    http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

    essentially, the way I have understood this, if...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    June 28, 2012 at 10:48 am

    #1506752

  • RE: Why does my scalar funtion not complete?

    FIXED IT!!!!!!!!!!!!!!!!!!

    I am calling the function with literals which was causing the execution plan to fall back on out-of-date statistics. I updated statistics and got the thing running in 5...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    June 28, 2012 at 10:28 am

    #1506738

  • RE: Why does my scalar funtion not complete?

    hmm I shall give that a go thanks.

    a udf is slow... still defies logic to me - a query is a query, a table is a table. unless of course...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    June 28, 2012 at 10:09 am

    #1506726

  • RE: Why does my scalar funtion not complete?

    lol if I copy and paste the query out of the udf it completes in just 5 seconds.

    I just can't get my head around why exactly the same code...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    June 28, 2012 at 9:59 am

    #1506718

  • RE: Why does my scalar funtion not complete?

    Thanks Both

    The recursive element is as simple as the example code, if the parameter = 'A' it calls itself a few times and adds the results together, the parameter it...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    June 28, 2012 at 9:52 am

    #1506715

  • RE: Updating first three characters

    you can probably achieve what you need with a combination of CASE, LEFT and SUBSTRING. but it depends on the details of your requirement. it might be as simple as

    UPDATE...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    June 28, 2012 at 8:10 am

    #1506638

  • RE: easy way to extract data to csv?

    awesome thanks that looks good.

    should be able to run that through xp_cmdshell with a trusted connection.

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    June 21, 2012 at 4:25 am

    #1503860

Viewing 15 posts - 91 through 105 (of 264 total)