Forum Replies Created

Viewing 15 posts - 571 through 585 (of 2,462 total)

  • RE: Learning to Search

    you should all know about site: searches on search engines

    Amen!

    Knowing how to use the "advanced" search engine features is huge. Anyone in technology (as an example) who took 20 minutes...

    "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

    July 27, 2016 at 10:39 am

    #1892340

  • RE: Clustered Index on Multiple Fields

    the use of every ID column (first 4 columns)

    No column in itself allows to greatly filter the data.

    The users are using the table in various and unmonitored way...

    Not always...

    "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

    July 26, 2016 at 4:43 pm

    #1892167

  • RE: How do you know when it is time to leave a job?

    Rod at work (7/26/2016)

    If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't see any evidence of...

    "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

    July 26, 2016 at 11:33 am

    #1892110

  • RE: Azure SQL Limitations compared with a SQL Server Enterprise

    Nice read, well done Daniel.

    "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

    July 26, 2016 at 8:35 am

    #1892060

  • RE: How do you know when it is time to leave a job?

    If you're a good DBA, Developer or Architect it's time to go when you don't love what you're doing. The market is too starved for talent to be at 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

    July 25, 2016 at 8:34 pm

    #1891949

  • RE: Table joins

    amanspschauhan (7/25/2016)

    Hi All,

    I have two Tables as shown below-

    Details-

    Company Name CEO ID Manager ID

    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

    July 25, 2016 at 2:20 pm

    #1891923

  • RE: Combine 9 SSRS reports into one report

    not all reports will use the same date parameters, fortunately all of the reports have same parameter names.

    First, can you clarify what you mean here?

    •Would all the 9 reports...

    "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

    July 25, 2016 at 2:13 pm

    #1891922

  • RE: Better method for computed column?

    mike 57299 (7/25/2016)

    Unfortunately, your suggestion is greek to me. Can you explain a bit more? And yes, it is killing performance.

    Thank you.

    I was going to suggest that you create...

    "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

    July 25, 2016 at 1:12 pm

    #1891904

  • RE: Better method for computed column?

    Luis Cazares (7/25/2016)

    What are you using the product_stat table for? Will you have more than a row per product? Will it keep history? If it'll always show the products in...

    "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

    July 25, 2016 at 12:55 pm

    #1891886

  • RE: Better method for computed column?

    Scalar functions for computed columns or constraints will hurt performance too. For one, queries that reference the table that uses a scalar udf for the computed column will likely 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

    July 25, 2016 at 11:37 am

    #1891859

  • RE: Are the posted questions getting worse?

    Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:

    [Gender] varchar(100) NULL,

    "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

    July 25, 2016 at 9:15 am

    #1891837

  • RE: Additional Data Files and Proportional Fill

    Great work David. Very interesting, I was not aware that you could do this with Extended Events.

    "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

    July 25, 2016 at 6:29 am

    #1891800

  • RE: URGENT Please -Substring Formation in SQL SERVER 2014

    If we're busting out splitters then another way would be using PatternSplitCM[/url].

    DECLARE @SomeTable TABLE (SomeString varchar(100));

    INSERT @SomeTable VALUES ('Recalc 2015659341589653'),('Recalc of 2015658926358915 revised'),

    ('Recalc to clm 15649687415315781536 error');

    SELECT SomeString, 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

    July 20, 2016 at 11:10 am

    #1891115

  • RE: Repetitive Tasks Please Help on Populating Table

    no prob. 😛

    Read up on tally tables if you don't know about them. They're an invaluable tool.

    "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

    July 20, 2016 at 9:54 am

    #1891105

  • RE: How to search exact match case

    One approach using the DelimitedSplit8K_LEAD[/url]:

    DECLARE @searchstring varchar(100) = '2,5';

    SELECT searchstring = @searchstring, [count] = COUNT(*)

    FROM

    (

    SELECT c.ComponentInfoID, mx, [count] = COUNT(*)/mx

    FROM ComponentInfoID c

    CROSS APPLY dbo.DelimitedSplit8K_LEAD(c.ComponentInfoID,',')...

    "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

    July 20, 2016 at 9:52 am

    #1891104

Viewing 15 posts - 571 through 585 (of 2,462 total)