Forum Replies Created

Viewing 15 posts - 16 through 30 (of 75 total)

  • RE: Help required for a Strange procedure cache problem

    Nothing in the SQL Server Error Log, or other logs.

    One 'cache flush' coincided with a Transaction Log backup (done every 15 minutes). But the two subsequent 'flushes' did not.

    August 22, 2011 at 5:57 am

    #1371355

  • RE: Querying XML - datatype weirdness (REAL versus NUMERIC)

    Thank you for your reply, opc.three.

    Still confusing stuff, but what you say makes kind of sense.

    Using the REAL datatype instead of a NUMERIC(12,3) solved a tricky problem for a customer,...

    March 29, 2011 at 2:16 am

    #1304718

  • RE: Trust People

    Keith Langmead (1/13/2011)

    On the other hand, if you look at the British SAS (generally considered the worlds best special forces people)

    What about the Dutch 24th Wielrijdersbrigade? :w00t:

    OK, some...

    January 14, 2011 at 12:31 am

    #1273424

  • RE: Trust People

    djackson 22568 (1/6/2011)

    Joe Johnson-482549 (1/6/2011)

    200 years to be a force to be reckoned with? That just doesn't seem that impressive.

    What's really impressive is that in 5 years (from...

    January 7, 2011 at 12:21 am

    #1270451

  • RE: Trust People

    Ok, this is off-topic, but I can't help it.

    From the original article:

    In 4 BC, the Gauls sacked Rome, a horde of individual warriors defeating other individual warriors. But by the...

    January 6, 2011 at 12:07 am

    #1269885

  • RE: Fun(?) with DATETIME2

    The transition from Julian to Gregorian Calendar: http://www.rundetaarn.dk/engelsk/observatorium/gregorian.html

    September 14th 1752 - England and Scotland with colonies. Thursday, September 14th came after Wednesday, September 2nd.

    Hmm, undoubtedly this Q will come...

    December 27, 2010 at 12:28 am

    #1266367

  • RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

    As of midnight would be perfectly fine

    Good stories usually have a happy ending. Not exactly an eye-opener, but nevertheless a good reminder.

    We had it the other way round. Every night...

    July 14, 2010 at 12:47 am

    #1192584

  • RE: Time Bomb Design - A Longer Fuse

    sipe_16 (5/27/2010)

    If you wanted to be super-clear you could skip the aliases and simply:

    select [Order].ID, Customer.ID from dbo.[Order]

    inner join dbo.Customer on Customer.ID = [Order].ID

    Nope, doesn't make it easier for...

    May 27, 2010 at 2:49 am

    #1173177

  • RE: Simple LIKE with wildcard

    First thought: How can values like 'AA' be found with LIKE '_' ?

    Zero rows. Click. Zero points.

    Next time I will wait for the caffeine to do its work. I...

    May 27, 2010 at 12:41 am

    #1173133

  • RE: Time Bomb Design - A Longer Fuse

    sporran (5/25/2010)

    As a result, when I clicked on what I thought was 5 stars, I actually gave 1 star.

    Added one star extra. If 3 other persons will do that...

    Good article.

    May 26, 2010 at 12:35 am

    #1172484

  • RE: Check status of HEAP tables

    Thanks, it helped me to spot a potential problem that I was yet unaware of.

    March 18, 2010 at 2:22 am

    #1135781

  • RE: Music for DBAs

    Queensryche - Disconnected

    July 16, 2009 at 12:09 am

    #1025491

  • RE: Music for DBAs

    Just found a brace of Snow Patrol songs on the album A Hundred Million Suns:

    * Engines

    * Disaster Button

    😀

    July 7, 2009 at 1:49 am

    #1020910

  • RE: Music for DBAs

    (Oops, got an error the first time...)

    July 7, 2009 at 12:23 am

    #1020897

  • RE: Music for DBAs

    Some songs on my PC. Without title-alterations: not just for the DBA

    Lock and key - Rush

    Careful with That Axe, Eugene - Pink Floyd (advice for a disgruntled user)

    Leave no...

    July 7, 2009 at 12:21 am

    #1020895

Viewing 15 posts - 16 through 30 (of 75 total)