Forum Replies Created

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

  • RE: Query Processing Question

    Thanks Eirikur, you always seen to have the answer. Very interesting stuff - I have never really played around any Undocumented Query Optimizer Trace Flags (I used to play around...

    "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 11, 2015 at 3:13 pm

    #1826169

  • RE: "send me some of your code"

    Maybe the recruiter is clueless, I don't know.

    If a recruiter wanted to see some of my code without any explanation I would blow them off. I had some take home...

    "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 10:00 pm

    #1825876

  • RE: Transaction logs

    The Gail Shaw book Jacob recommended is great.

    An appropriate follow-up question is, "Why do you ask?"

    "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:43 pm

    #1825871

  • RE: BI Internship help

    Everything Koen said, especially the Itzik Ben-Gan books.

    I would add:

    Kimball's The Microsoft Data Warehouse Toolkit, 2nd Edition[/url] is essential for any new BI developer. That's my BI bible....

    "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:25 pm

    #1825795

  • 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

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