Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 2,458 total)

  • RE: Maze Runner The Scorch Trials Full Movie Download

    Spam reported.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 10, 2015 at 12:13 pm

    #1825790

  • RE: Autogenerating SSIS file import packages using Biml

    Great article Johan. I work with people who swear by BIML and I see why. This is the kind of thing I have tried to do before without success. I'm...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 10, 2015 at 7:58 am

    #1825674

  • RE: First Occurance of the string from text

    Perhaps I'm not understanding this correctly but this seems to get the correct answer based on my interpretation of the requirement.

    DECLARE @string varchar(1000) =

    'ABNAGENDRACSURENDRADJITHENDRAXNRENDRABVEERNDRAXDRMNDRAXRVINDRABNAGENDRACSURENDRADJITHEN';

    SELECT TOP 1 'A'+Item

    FROM...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 8, 2015 at 10:20 pm

    #1825316

  • RE: Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions

    Great article Greg. Concise, informative and to-the-point. I love Window Ranking Functions and could not live with out them.

    One minor correction:

    A ranking value is just a number, which...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 2, 2015 at 5:23 pm

    #1824166

  • RE: Resources for SQL Server security

    Books Online for this is actually pretty good. Its thorough and links to some other useful articles about TDE.

    I know this is the 2014 forum but the SQL...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 2, 2015 at 12:45 pm

    #1824118

  • RE: SQL server 2014 SSIS package fails when run as sql server agent job

    That's most likely because you are running the package using your credentials which has rights to run the package and the SQL Agent (which runs as a Windows service) is...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 2, 2015 at 12:27 pm

    #1824109

  • RE: JSON Select - Easily query values from JSON

    SQL-DBA (8/31/2015)

    This could come in very handy. XML is a dying format and I deal with lots of json data. It's good to see movement in this direction....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 2, 2015 at 9:55 am

    #1824056

  • RE: JSON Select - Easily query values from JSON

    Great article Josh! I have not yet played around with SQL Server 2016 but, based on everything, Microsoft is trying to make it more "big data friendly". That would be...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 2, 2015 at 9:40 am

    #1824047

  • RE: Reaping the benefits of the Window functions in T-SQL

    Hope it's not too late to say, "Great article Eirikur!". I just finished reading this for a second time (there is a problem that I was struggling with that your...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    September 1, 2015 at 2:59 pm

    #1823822

  • RE: The Tally Table

    dwain.c (8/25/2015)

    Thank the Buddha for whoever came up with the idea of a Tally table in the first place! I just love 'em (but probably everybody knows that).

    BTW. ...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 26, 2015 at 8:11 am

    #1822493

  • RE: What are your five most common T-SQL commands

    Brandie Tarvin (8/24/2015)

    USE MyDatabase;

    GO

    SELECT Table_Name, Column_Name

    FROM INFORMATION_SCHEMA.Columns

    WHERE Column_Name LIKE 'MyColumn%'

    ORDER BY Table_Name, Column_Name;

    --Find all tables containing a certain column name

    Yep, Amen! I forgot this... This (and/or variations of) should have...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 25, 2015 at 8:09 pm

    #1822373

  • RE: What are your five most common T-SQL commands

    I made a point at not looking at other people's replies. I use WHOISACTIVE and sp_askbrent quite a bit but that's not what you're looking for. I haven't been doing...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 25, 2015 at 7:50 pm

    #1822370

  • RE: Fine tuning Queries

    Read the article Luis posted.

    Without DDL, sample data there's not much help we can provide. That said, here's a couple bits of advice.

    If you don't need that ORDER...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 20, 2015 at 12:05 pm

    #1821508

  • RE: text mining

    Full text indexing may help but I don't know enough about it or have enough details about your requirement to say for sure. I do have a function, however, which...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 19, 2015 at 11:32 am

    #1821142

  • RE: Collecting contents of a package

    Hey Charmer. I will get back to you tomorrow. (Long day)

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    August 17, 2015 at 10:51 pm

    #1820612

Viewing 15 posts - 1,276 through 1,290 (of 2,458 total)