Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 2,458 total)

  • RE: SELECT COUNT(*) vs DMVs to get row count

    Sean - I am interested in why you say that COUNT(*) is the only way to get a row count. I'm not disagreeing with you - just curious looking for...

    "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

    April 10, 2015 at 3:36 pm

    #1790318

  • RE: ? A select top1 within a select ?

    Could you perhaps include a little DDL, sample data and an example of expected output?

    "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

    April 10, 2015 at 2:51 pm

    #1790304

  • RE: blank screen when using http://servername/Reports

    Have you tried http://<your actual server name>/Reports ? I think I have seen this in the past and, for some reason, localhost was not working.

    "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

    April 10, 2015 at 2:47 pm

    #1790303

  • RE: Temp DB question

    Thank you Grant and 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

    April 10, 2015 at 8:01 am

    #1790167

  • RE: Need to convert a SQL field based on delimiter

    I don't fully understand what you are trying to do but the splitter referenced in my signature line is the best way to split a string. This should get you...

    "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

    April 9, 2015 at 2:33 pm

    #1790007

  • RE: Guidelines to setup db part of data centre

    This is a loaded topic. A few thoughts....

    Get your disk configuration right. It's nice to split up your IO between different physical disks; such as:

    C: OS Files

    D: Program File/SQL Install

    E:...

    "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

    April 9, 2015 at 12:47 pm

    #1789977

  • RE: Raiserror syntax in 2008R2 Vs 2012

    I have run into this before too. Note this thread on stackoverflow: RAISERROR issue since migration to SQL Server 2012

    "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

    April 9, 2015 at 11:15 am

    #1789941

  • RE: Determine running occurence of SQL statement

    Below are a couple functions that I am working on that will get you the queries that are creating the most CPU pressure and IO pressure.

    These are based on...

    "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

    April 9, 2015 at 10:41 am

    #1789929

  • RE: Anyone Tell me what regular Housekeeping is needed for SQL DB's

    This does fall into the category of Log Backups which Grant mentioned..

    I would expand it to Log File maintenance. This includes changing the recovery model to Simple for Databases...

    "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

    April 9, 2015 at 9:53 am

    #1789915

  • RE: Cardinality Estimator – What’s new in SQL Server 2014

    Excellent article. 5 stars from me. I have not seen an article that discusses the new 2014 Cardinality Estimator in such detail. Well done sir!

    "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

    April 9, 2015 at 8:36 am

    #1789882

  • RE: XML Nodes to retreive the child and its list of values.

    Thanks!

    I actually had a few moments to kill and optimized that query further; this will be much, much faster, uses less code and creates a simplified query plan...

    DECLARE @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

    April 8, 2015 at 2:31 pm

    #1789699

  • RE: XML Nodes to retreive the child and its list of values.

    Alan.B (4/8/2015)

    pawan.clong10 (4/8/2015)

    HI Alan Thanks for that quick help.

    i really appreciated. well, i am actually able to retrieve the data

    However, the data is coming with the same token Names for...

    "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

    April 8, 2015 at 1:37 pm

    #1789686

  • RE: XML Nodes to retreive the child and its list of values.

    pawan.clong10 (4/8/2015)

    HI Alan Thanks for that quick help.

    i really appreciated. well, i am actually able to retrieve the data

    However, the data is coming with the same token Names for all...

    "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

    April 8, 2015 at 1:18 pm

    #1789681

  • RE: Group data into 15 minute intervals

    PSB (4/8/2015)

    Thanks work perfectly .

    😎

    "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

    April 8, 2015 at 11:35 am

    #1789635

  • RE: XML Nodes to retreive the child and its list of values.

    Ok, never mind the DDL; From your XML that you posted I have a temp variable to mimic what you have.

    We'll use this sample data:

    DECLARE @xml xml =

    '<?xml version="1.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

    April 8, 2015 at 11:31 am

    #1789631

Viewing 15 posts - 1,606 through 1,620 (of 2,458 total)