Forum Replies Created

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

  • RE: Missing Index proposed by SQL Execution Plan

    But if you're in a hurry and cannot wait for enlightenment, I suggest you find and download sp_BlitzIndex

    +1 😉

    "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 11, 2015 at 4:46 pm

    #1839247

  • RE: Missing Index proposed by SQL Execution Plan

    sgrimard (11/11/2015)

    Any suggestion on good books or site to learn how to create good index?

    SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) by Grant Fritchey is a...

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

    #1839238

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

    MonkSup (11/10/2015)

    Thanks for your response. I've been digging around the MSDN documentation...

    Is OPENXML something I should look into?

    https://msdn.microsoft.com/en-us/library/ms187897(v=sql.110).aspx

    I can find plenty of examples for importing and creating structures for XML...

    "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 6:47 pm

    #1839017

  • RE: SQL Pivot Table Nulls

    How about ISNULL? ISNULL(<whatever>,'') for blank values, ISNULL(<whatever>,0) to get a 0.

    "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 6:35 pm

    #1839013

  • 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

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