Forum Replies Created

Viewing 15 posts - 17,431 through 17,445 (of 59,102 total)

  • RE: Best way to filter columns

    On the serious side, how are these feeds stored in the staging table? VARCHAR, NVARCHAR, VARBINARY, XML or ???? Within that question, are they the MAX datatype? ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 5:05 pm

    #1886869

  • RE: Best way to filter columns

    frontrunner148 (6/23/2016)

    I have been asked to exclude RSS items where words like Kardashian is in the description. What we would rather have are topics about disasters, terror, crime, politics, scandal.

    Odd......

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 5:02 pm

    #1886868

  • RE: Have You Designed a Database from Scratch?

    WHUT!!??? Design a database??? Isn't that what ORM tools are for? :sick::-):-D:-P;-):hehe:

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 4:54 pm

    #1886867

  • RE: Massive Performance Issues with on TempDB and SharePoint 2013

    sith (6/22/2016)

    ... SharePoint Developer (with no SQL Skills).

    Not quite on-subject but you have no idea how much I enjoyed that little bit of irony. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 4:52 pm

    #1886866

  • RE: Concatenate strings

    curious_sqldba (6/24/2016)

    Jeff Moden (6/23/2016)

    curious_sqldba (6/22/2016)

    Sean Lange (6/22/2016)

    curious_sqldba (6/22/2016)

    Thanks. This is just displaying, i want to store the data in the variable and then use the variable different places.

    Do you know...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 4:46 pm

    #1886865

  • RE: What's the reason?

    Charmer (6/23/2016)

    Hi Friends,

    I had a question during my interview, as saying that What could be the reason when I am trying to drop all these tables , views, functions, SP's...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 4:30 pm

    #1886864

  • RE: Query

    If the hierarchy is large, consider the use of Nested Sets while still maintaining the Adjacency List. See the following articles for how to do such a thing in...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 4:17 pm

    #1886861

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/24/2016)

    Sean Lange (6/24/2016)

    Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.

    create view [dbo].[getNewID] as select newid() as new_id;

    Really? A view to get a guid???

    But wait...it...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 10:22 am

    #1886798

  • RE: Are the posted questions getting worse?

    Sean Lange (6/24/2016)

    Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.

    create view [dbo].[getNewID] as select newid() as new_id;

    Really? A view to get a guid???

    But wait...it gets even...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 24, 2016 at 10:20 am

    #1886796

  • RE: Monitor/alert - Table row growth

    SQL!$@w$0ME (6/22/2016)

    Hi Folks,

    Anyone has a script/documentation to monitor/alert table growth by percentage or number of rows.

    Many thanks.

    Based on what and when? The condition just before'n'after a given insert or...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 23, 2016 at 3:34 pm

    #1886637

  • RE: Concatenate strings

    curious_sqldba (6/22/2016)

    Sean Lange (6/22/2016)

    curious_sqldba (6/22/2016)

    Thanks. This is just displaying, i want to store the data in the variable and then use the variable different places.

    Do you know how to use...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 23, 2016 at 2:36 pm

    #1886632

  • RE: Are the posted questions getting worse?

    On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10% import tax and GB sells 4...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 23, 2016 at 1:25 pm

    #1886616

  • RE: A SQL Server Date Handling Issue

    trboyden (6/21/2016)

    Jeff Moden (6/20/2016)

    trboyden (6/20/2016)

    SQL Server expects the date to be passed in as "2016-06-20 00:00:00"

    That's not true at all. SQL Server will take a couple dozen date/time formats...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 23, 2016 at 7:45 am

    #1886531

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    David Moutray (6/22/2016)

    Classic article, Jeff. I have loved it (and used it extensively) since it first came out five years ago (and the discussion is still going strong!)

    With SQL...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 22, 2016 at 9:22 pm

    #1886410

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/22/2016)

    Grant Fritchey (6/22/2016)

    Being a different kind of science fiction fan, one of my horrors is the world government that will tell us all what to do, how to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 22, 2016 at 8:54 am

    #1886287

Viewing 15 posts - 17,431 through 17,445 (of 59,102 total)