Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 2,458 total)

  • RE: Question for All DBAs (What can I learn to enahnce my career?)

    Like others have said, it will take some time to learn the basic so learn, learn, learn... practice, practice, practice and you'll figure out what you love.

    Whatever you do,...

    "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

    November 10, 2015 at 11:09 am

    #1838920

  • RE: Parallelism execution from a table

    ypeng5 (11/4/2015)

    I have a table with thousand of queries are waiting for execute in sql server. I am using an store procedure to execute those queries one by one. 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

    November 9, 2015 at 6:11 pm

    #1838739

  • RE: Procedure to create schema defined XML from a set of tables

    Play around with/get comfortable with FOR XML. There are 4 FOR XML methods, RAW, AUTO,EXPLICIT, PATH once you are comfortable with them you can export data into any XML format....

    "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

    November 8, 2015 at 9:24 pm

    #1838469

  • RE: return Fiscal Year based on YYYY-week format

    Here's a couple solutions (if I'm understanding this correctly).

    The caveat here is that I'm understanding you problem, which I think I am.

    If you can create an inline table...

    "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

    November 6, 2015 at 9:19 pm

    #1838390

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    Sergiy (11/4/2015)

    I would suggest (if NOLOCK is a requirement) to use NOLOCK, not WITH (NOLOCK).

    NOLOCK without brackets is not a hint, but a table name alias.

    So, the query 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

    November 5, 2015 at 3:41 pm

    #1838118

  • RE: 101 help with CASE inside of CURSOR statement

    As Lynn said, you probably don't need a cursor.

    That said, you have no THEN statement in your CASE. A WHEN must be followed by a THEN.

    "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

    November 3, 2015 at 3:49 pm

    #1837495

  • RE: SSRS Report: pulling data from two different database servers in SSRS

    To get values that exist in one table that do not exist in another you want to do an anti-join. You can accomplish with using WHERE NOT IN or WHERE...

    "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

    October 31, 2015 at 9:07 am

    #1836864

  • RE: SQL 2014 Standard Edition Clustering in AWS

    I'm sorry. I misunderstood your question. Like I said, I'm unfamiliar with SIOS and DxEnterprise. 🙁

    "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

    October 30, 2015 at 4:05 pm

    #1836842

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (10/30/2015)

    jasona.work (10/30/2015)

    Brandie Tarvin (10/30/2015)

    Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables...

    "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

    October 30, 2015 at 3:01 pm

    #1836837

  • RE: TSQL Query - Field has format and is saved as an Alias field name - Trying to reuse the alias later in the query

    Just to clear something up. You absolutely can use an alias inside a SQL query but only after the alias has been created. It's important to clear that up.

    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

    October 30, 2015 at 2:38 pm

    #1836834

  • RE: SQL 2014 Standard Edition Clustering in AWS

    Michelle-138172 (10/30/2015)

    I've been searching info on sql server clustering for 2014 standard edition on AWS, but it hasn't come up with a lot of options. Are there not many companies...

    "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

    October 30, 2015 at 2:10 pm

    #1836826

  • RE: Can this be done without a loop

    J Livingston SQL (10/29/2015)

    see this article and read the comments from Jeff at the bottom of the article

    https://www.mssqltips.com/sqlservertip/3576/generate-random-strings-with-high-performance-with-a-sql-clr-function

    Thanks Mr. Livingston. I just installed and played around with both of Jeff...

    "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

    October 29, 2015 at 9:12 pm

    #1836566

  • RE: Can this be done without a loop

    Phil Parkin (10/29/2015)

    Alan.B (10/28/2015)

    Hi folks. I needed to write a stored proc that takes generates a string of random characters @minlen to @maxlen characters long for testing some functions. What...

    "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

    October 29, 2015 at 7:38 pm

    #1836563

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

    allnelsons (10/28/2015)

    So, question about these splitter functions (which are pretty much the most used tools in my arsenal, btw!), are they faster/more efficient being run from the I.B.G. CTE tally...

    "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

    October 28, 2015 at 1:15 pm

    #1836193

  • RE: More wildcard searches

    an even correcter answer would be:

    It depends

    (5 with a case insensitive collation, three if the collation is case sensitive. )

    "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

    October 28, 2015 at 8:47 am

    #1836089

Viewing 15 posts - 1,171 through 1,185 (of 2,458 total)