Forum Replies Created

Viewing 15 posts - 3,181 through 3,195 (of 7,483 total)

  • RE: Global Configuration Settings

    An nice amusing question that demonstrates an unfortunate feature of SQL - using contractions is not a habit I would like to get into. so a good question about...

    Tom

    August 30, 2013 at 5:12 am

    #1646296

  • RE: Global Configuration Settings

    Sean Smith-776614 (8/29/2013)

    Lesson is use the complete name. For example, rather than using "advanced options" use "show advanced options". If MS ever introduces "hide advanced options" then you may need...

    Tom

    August 30, 2013 at 4:58 am

    #1646292

  • RE: Find integer at end of a string. There *must* be a better solution ?

    Thorkil Johansen (8/29/2013)

    select ISNULL(TRY_CONVERT(INT,SUBSTRING('Ejerskifte-45\Behandlet-45',

    NULLIF(PATINDEX('%-[0-9]%','Ejerskifte-45\Behandlet-45'),0)

    + 1,LEN('Ejerskifte-45\Behandlet-45')) ),-1)

    I get -1 I would like it to be 45

    The problem is that trying to convert the 26 character string '45\Behandlet-45'...

    Tom

    August 29, 2013 at 7:31 am

    #1645982

  • RE: Between & Collation

    Ed Wagner (8/29/2013)

    I find it interesting that lower case sorts ahead of upper case. In the ASCII character set I remember working with more than a few years ago,...

    Tom

    August 29, 2013 at 6:55 am

    #1645954

  • RE: Between & Collation

    Good question.

    Just to amplify what Hugo said, the wording in BOL (which is also in the explanation) is somewhat misleading. Hugo's statement that the tie break between upper and...

    Tom

    August 29, 2013 at 6:37 am

    #1645948

  • RE: Stunned

    It's a great pity that we will always have bigots amongst us because humanity is not perfect; but that's how it is. I wish I had been there to...

    Tom

    August 28, 2013 at 12:14 pm

    #1645699

  • RE: How to return list of all courses for which a student meets all the prerequisites.

    Stefan's version caters for retakes too, because it looks for the absence of success rather than the presence of failure - a nice and tidy way to handle retakes.

    Tom

    August 28, 2013 at 11:11 am

    #1645671

  • RE: NTILE

    tabinsc (8/28/2013)

    Good question. One of those code tricks where I go "this is really cool but I can't think of anywhere I would use it".

    Try a problem like "List...

    Tom

    August 28, 2013 at 11:00 am

    #1645668

  • RE: NTILE

    I think that the correct answer is badly worded. Certainly it is correct, whereas that's clearly impossible for each of the other three options. But it uses the...

    Tom

    August 28, 2013 at 4:11 am

    #1645470

  • RE: Lost in the Noise

    Craig-315134 (8/27/2013)

    ... the vandal wants to insert a picture of Minnie Mouse cuddling up to Kermit onto the home page of the National Bank of Grand Fenwick's website ...

    Grand Fenwick...

    Tom

    August 27, 2013 at 4:00 pm

    #1645371

  • RE: SQL Server Tables

    PHYData DBA (8/27/2013)

    I like this definition -

    If updating a row does not affect other records (though it affects secondary indexes) the table is a heap.

    Very short exact and clear.

    This might...

    Tom

    August 27, 2013 at 3:41 pm

    #1645361

  • RE: Lost in the Noise

    Steve Jones - SSC Editor (8/27/2013)[hrThe idea isn't just to have them attack a fake system, but also to learn about how they attack (and from where). The honeypots can...

    Tom

    August 27, 2013 at 12:26 pm

    #1645306

  • RE: Do we have possibility to update system tables in SQL..

    GilaMonster (8/27/2013)

    Jason.Reeves (8/27/2013)

    Most of the system information is now held in the Resource DB which is hidden read only (for good reason) you can't even do a SQL backup of...

    Tom

    August 27, 2013 at 12:03 pm

    #1645294

  • RE: Delete Vs Truncate difference on rollback

    sqlnaive (8/27/2013)

    GilaMonster (8/27/2013)

    sqlnaive (8/27/2013)

    Great... So the correct statement should be:

    "DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table and...

    Tom

    August 27, 2013 at 11:08 am

    #1645277

  • RE: SQL Server Tables

    PHYData DBA (8/27/2013)

    Nice easy question... I always wondered why you can have a Primary Key on a heap and its still a heap if there is no clustered index on...

    Tom

    August 27, 2013 at 10:23 am

    #1645269

Viewing 15 posts - 3,181 through 3,195 (of 7,483 total)