Forum Replies Created

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

  • 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

  • RE: Get the maximum Row number for the duplicate valued rows

    Ditto everything Jason said. Some DDL and an example of what you are doing/trying to do would help.

    Perhaps you can use this code as an example of how 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 3:40 pm

    #1799498

  • RE: SQL 2012 table read performance

    20 GB seems rather large for a table with 4000 rows even with the max data types, and especially since your clustered index and 1-column non clustered index is taking...

    "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 11:10 am

    #1799389

  • RE: Replace Statement

    TJT (5/19/2015)

    Sorry, I should have provided more information. The IP Addresses could be any IP addresses.

    I was trying to use REPLACE with RIGHT statement

    Ok, by "any IP address" 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

    May 19, 2015 at 2:37 pm

    #1799165

  • RE: Replace Statement

    Luis Cazares (5/19/2015)

    Alan.B (5/19/2015)

    You could do this:

    DECLARE @ipaddresses TABLE (ip varchar(30));

    INSERT @ipaddresses VALUES

    ('175.139.45.127'),

    ('175.139.45.12'),

    ('175.139.45.1'),

    ('10.10.10.100'),

    ('10.10.10.10'),

    ('10.10.10.1');

    SELECT ip = PARSENAME(ip,1)+'.'+PARSENAME(ip,2)+'.'+PARSENAME(ip,3)+'.0'

    FROM @ipaddresses

    Alan, that's cheating. You didn't test your code. 😛

    I guess I didn't :blush:

    "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 19, 2015 at 2:32 pm

    #1799161

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