Forum Replies Created

Viewing 15 posts - 841 through 855 (of 2,462 total)

  • RE: Where is my DB instance?

    From the looks of your first and last picture - it would appear that SQL Server is not installed. There is a checkbox during the install for "Database engine services"...

    (Note...

    "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 16, 2016 at 10:57 pm

    #1872582

  • RE: Connection to AS via SSMS

    What PB_BI said.

    It's also worth noting that you can access SSAS via BIDS or SSDT (depending on the version of SSAS you ate running).

    "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 16, 2016 at 9:05 pm

    #1872577

  • RE: Where is my DB instance?

    Have you tried clicking the drop-down and selecting "<browse for more>" then looked at local servers? If there's nothing in there then there may have been an issue with 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 16, 2016 at 8:53 pm

    #1872576

  • RE: Best practices for replication (?) from Production to reporting dbs, also joins between on/off-prem dbs?

    Transactional replication is a viable choice but implementing, maintaining and troubleshooting Replication is not a trivial task. If you go that route with production servers then push subscriptions are the...

    "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 16, 2016 at 8:46 pm

    #1872575

  • RE: Record Matching in FIFO Basic in Stock data

    FYI... The FIFO problem was the subject of an SSC competition some years ago. Many interesting techniques to take into consideration: The ‘FIFO Stock Inventory’ SQL 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

    April 16, 2016 at 7:59 pm

    #1872574

  • RE: Select records in hierarchical order

    I was going to post what Jeff posted. :Whistling:

    "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 16, 2016 at 7:49 pm

    #1872573

  • RE: Need to update stats when CPU is high for a particular Query

    Luis Cazares (4/15/2016)

    Alan.B (4/15/2016)

    nagkarjun1 (4/15/2016)

    Hi Folks,

    I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

    Updating/defrag Stats...

    "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 15, 2016 at 7:55 pm

    #1872543

  • RE: ISNULL VS COALESCE on nullible and not null columns Sargability comparison

    MadAdmin (4/15/2016)

    Hugo Kornelis (4/15/2016)

    TheSQLGuru (4/15/2016)

    Wrapping a function around a column in the WHERE clause is probably the second worst thing I see in aggregate in my consulting (with the first...

    "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 15, 2016 at 2:03 pm

    #1872516

  • RE: Need to update stats when CPU is high for a particular Query

    nagkarjun1 (4/15/2016)

    Hi Folks,

    I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

    Updating/defrag Stats and rebuilding indexes...

    "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 15, 2016 at 1:55 pm

    #1872512

  • RE: REPLACE CHARACTERS

    Below is how you'd do it if the data is stored as money or varchar...

    -- if stored as money data type

    DECLARE @x money = '$154,111.85';

    SELECT CAST(@x AS decimal(10,2));

    GO

    -- if...

    "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 13, 2016 at 1:29 pm

    #1871852

  • RE: Splitting Strings in SQL Server 2016

    Interesting read Wayne. Good work 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 12, 2016 at 10:20 am

    #1871455

  • RE: What is the difference between Left Outer join and Left Outer join restricted- Interview question

    This:

    I believe that these aren't official terms and they shouldn't be treated as such.

    "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, 2016 at 1:31 pm

    #1870921

  • RE: Replace a capital letter in a string

    drew.allen (4/7/2016)

    Alan.B (4/6/2016)

    You could also do this:

    REPLACE(value, char(88), '/')

    The replacement depends on the collation, and the default collation is case insensitive. Using the CHAR() function, does not change...

    "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, 2016 at 9:33 am

    #1870853

  • RE: *** In case you missed it, SQL Server Developer's Edition is now FREE!!!! ***

    "SQL Server 2016 Developer Edition, when released later this year, will also be free. ":w00t::w00t:

    "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 7, 2016 at 8:27 pm

    #1870700

  • RE: Talking baseball

    Steve Jones - SSC Editor (4/7/2016)

    Well, I'm going to opening day in CO tomorrow, for the first time in like 10 years. I used to go ever year when I...

    "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 7, 2016 at 2:15 pm

    #1870657

Viewing 15 posts - 841 through 855 (of 2,462 total)