Forum Replies Created

Viewing 15 posts - 1 through 15 (of 667 total)

  • Reply To: Offline Files

    Why then does SQL Books Online say

    OFFLINE Sets the file offline and makes all objects in the filegroup inaccessible.

    Or am I misinterpreting that?

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    August 8, 2020 at 8:58 am

    #3778376

  • RE: Friday the 13th

    tomaz.kastrun - Monday, May 7, 2018 11:53 AM

    Couple of shorter solutions:

    --Solution 1
    SET DATEFIRST 1
    DECLARE @d DATE = '2016-05-13 00:00:00.000'--GETDATE()
    WHILE (@d...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 8, 2018 at 9:01 am

    #1989712

  • RE: Friday the 13th

    Luis Cazares - Monday, May 7, 2018 8:34 AM

    Luis Cazares - Monday, May 7, 2018 8:28 AM

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 8, 2018 at 8:32 am

    #1989696

  • RE: Localized Upgrades

    Hey, I would have expected a Friday the 13th fun question today. But thanks, learned something.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    April 13, 2018 at 3:38 pm

    #1986843

  • RE: Combine 3 SQL queries

    Mando_eg - Sunday, January 7, 2018 12:20 AM

    Well, Let me explain the scenario of this procedure
    I have 3 tables 
    Suggestions, Complains, Payments
    I'm getting...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    January 15, 2018 at 8:21 am

    #1975906

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Friday, December 29, 2017 4:32 PM

    Sergiy - Friday, December 29, 2017 4:20 PM

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    December 29, 2017 at 4:48 pm

    #1973918

  • RE: Graph DB edge tables

    My question remains, why did MS decide to add this useless suffix to the @from_id and @to_id columns? It just makes a joke of the "Explicitly name columns" best practice...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    December 21, 2017 at 3:53 pm

    #1973221

  • RE: Graph DB edge tables

    sgmunson - Wednesday, December 20, 2017 12:49 PM

    Well, there's always INFORMATION_SCHEMA.COLUMNS to play with.   If you go the dynamic SQL route, you...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    December 20, 2017 at 1:12 pm

    #1972982

  • RE: stored procedure returns a blank cell instead of NULL

    Change the

    IF @ID = NULL

    to

    IF @ID IS NULL

    You cannot compare a value directly to NULL.

    And that's...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    December 18, 2017 at 2:09 pm

    #1972590

  • RE: Restore of the Database

    Junior Galvão - MVP (5/9/2016)

    Hi,

    Please check the correct answer!!!

    The official Microsoft documentation informs the operation of verifyonly is written in the table.

    To learn more visit: https://msdn.microsoft.com/en-us/library/ms187408.aspx

    Uhmmm... This question is...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 9, 2016 at 8:49 am

    #1877505

  • RE: Collation Sequence

    Thanks, Brandie. I found a script on this site (http://www.sqlservercentral.com/scripts/Collation/113863/) that actually takes care of converting all the character and text based columns to a different collation. Quite handy. I...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 20, 2015 at 5:28 am

    #1813619

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (7/29/2014)[And Aerosmith is now country, or is that Kenney Chesney is now classic rock?

    Aerosmith country? Wow, I must have fallen into hibernation, or American Idol has eventually adopted...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 29, 2014 at 4:19 pm

    #1733411

  • RE: Are the posted questions getting worse?

    Hi Everyone!

    Wow, it has been 6 months or so since I last was on this thread. I haven't even been lurking, just too busy to keep up. And no, I'm...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 29, 2014 at 3:14 pm

    #1733402

  • RE: Merge Statement Help

    Not sure what exactly you want. From the SQL statement you posted it will always insert data for NY and KT if it does not match Fname and Sname, but...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    March 17, 2014 at 7:28 am

    #1697625

  • RE: Reseed Max value

    I think the discussion went a bit off the OP's topic. Yes, he mentioned performance in his last sentence, but basically, the answer has been provided early on. Change the...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    March 8, 2014 at 4:17 pm

    #1695335

Viewing 15 posts - 1 through 15 (of 667 total)