Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 2,462 total)

  • RE: Critique My Understanding of Window Functions Please...

    I think you're on the right track, you'll notice in Jason's excellent example that he includes a number in his lag/lead functions (you did not not which is the problem)...

    "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

    May 26, 2015 at 1:48 pm

    #1800696

  • RE: Big Data for SQL folks: The Technologies (Part I)

    This is hands down the best big data article I have read in some time. We'll done sir, very informative yet concise. 5 stars!

    "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

    May 23, 2015 at 7:40 am

    #1800204

  • RE: SSMS's intelliSense

    Beatrix Kiddo (5/22/2015)

    Ctrl+Shift+R will refresh the Intellisense local cache. (Or Edit > Intellisense > Refresh Local Cache.)

    See if that helps?

    That has never helped me with the problem the op 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

    May 22, 2015 at 8:20 am

    #1800021

  • RE: Archieving Data

    ramana3327 (5/21/2015)

    I write the sp below and tested. When I tested it is not coming out of loop after the deletion of the records from the Error table.

    Is it performance...

    "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

    May 21, 2015 at 4:34 pm

    #1799854

  • RE: Self Contracting Licensing, Insurance, Questions

    I think Lowell's advice was spot-on. I would definitely go the self-employed route. I started working on my own a couple years ago and wish I had done so earlier....

    "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

    May 21, 2015 at 4:21 pm

    #1799853

  • RE: Multiple Apps in one Database

    I have been told that numerous applications each today with their own database are to be migrated to a common database thereby requiring that all table/object names be prefixed with...

    "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

    May 21, 2015 at 3:45 pm

    #1799848

  • RE: SSIS Performance Degradation

    It's hard to guess without looking at what your SSIS packages are doing or seeing the changes in your servers' state throughout the day. Also I'm no SSIS guru but...

    "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

    May 21, 2015 at 3:13 pm

    #1799845

  • RE: Understanding CAST(INT AS DATETIME)

    Yep

    "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

    May 20, 2015 at 9:38 pm

    #1799535

  • RE: Understanding CAST(INT AS DATETIME)

    Day 0 is 1/1/1900. 1 = 1 day...

    SELECT CAST(0 AS DATETIME) -- 1/1/1900

    SELECT CAST(1 AS DATETIME) -- 1 day afterr 1/1/1900

    SELECT CAST((1.1) AS DATETIME) -- 1.1 days after...

    SELECT CAST((1.5) AS...

    "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

    May 20, 2015 at 7:24 pm

    #1799525

  • RE: Reporting Services expertise

    joffwilliams (5/20/2015)

    We have some analyst staff who are coming from a Crystal Reports background and converting their reports. They're looking for some in-depth Reporting Services training and a person to...

    "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

    May 20, 2015 at 7:11 pm

    #1799523

  • RE: Creating a pivot like table result

    I'm thinking that this should do the trick:

    WITH cntByYrMnth AS

    (

    SELECT

    yr = ISNULL(r1.yr, r2.yr),

    mnth = ISNULL(r1.mnth, r2.mnth),

    cnt1 = ISNULL(r1.cnt1,0),

    cnt2 = ISNULL(r2.cnt2,0)

    FROM #raw1 r1

    FULL...

    "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

    May 20, 2015 at 6:05 pm

    #1799519

  • RE: SQL Developer Skills

    Rizk.Christopher (5/20/2015)

    I have been working with SQL Server 2012 and T-SQL for almost 2 years, on the development side. I have also been working with SSRS, more on a beginner...

    "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

    May 20, 2015 at 5:11 pm

    #1799515

  • RE: SSMS's intelliSense

    Jason A. Long (5/20/2015)

    Alan.B (5/20/2015)

    I have noticed that in SQL Server 2012 and 2014 (perhaps previous versions as well but I don't remember) Intellisence is just downright flaky. It goes...

    "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

    May 20, 2015 at 4:54 pm

    #1799511

  • RE: View referencing table with ## in the name?

    Luis Cazares (5/20/2015)

    Reactions like this make me wonder if I should change my signature.

    Those questions are there because some people just copy, paste and execute code without analysing what they...

    "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

    May 20, 2015 at 4:53 pm

    #1799510

  • RE: SSMS's intelliSense

    I have noticed that in SQL Server 2012 and 2014 (perhaps previous versions as well but I don't remember) Intellisence is just downright flaky. It goes away and comes back...

    "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

    May 20, 2015 at 4:41 pm

    #1799507

Viewing 15 posts - 1,456 through 1,470 (of 2,462 total)