Forum Replies Created

Viewing 15 posts - 901 through 915 (of 2,458 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/24/2016)

    <headdesk>

    One of my coworkers just came up with the worst joke ever.

    Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't join a table!

    Will...

    "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

    March 24, 2016 at 8:38 am

    #1867458

  • RE: Split without delimiter based on postion into multiple columns

    I was curious and looked at the thread.

    ChrisM@home (10/22/2012)

    yuvipoy (10/22/2012)

    Ok, thanks. Can you give an example of how the data from this output table would be used please?

    ChrisM 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

    March 24, 2016 at 8:28 am

    #1867447

  • RE: indexes-non clustered

    db8 (3/23/2016)

    preparing T-SQL ,

    they told me we can sort by using ,with index clause.

    don't know what exactly use of this with index clause I will confirm on this...

    "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

    March 23, 2016 at 10:43 pm

    #1867311

  • RE: FOR XML Path

    ringovski (3/23/2016)

    Thanks Orlando and Alan for the replies.

    Is dbo.splitcsv a reserved table or function somewhere as i am unable to find it within the DB?

    It's a custom, user-created function which...

    "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

    March 23, 2016 at 8:42 pm

    #1867299

  • RE: FOR XML Path

    Let's reformat the code to make it more readable:

    SUBSTRING

    (

    (

    SELECT ', ' + gen_Firstname + ' ' + gen_Lastname

    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

    March 23, 2016 at 7:35 pm

    #1867288

  • RE: Talking baseball

    Ray K (3/23/2016)

    Steve Jones - SSC Editor (3/23/2016)

    Who believes it?

    http://espn.go.com/mlb/story/_/id/15051882/alex-rodriguez-new-york-yankees-retire-2017-season

    Interesting.

    I won't say whether or not I believe it, but whether or not he actually does, that's his prerogative. ...

    "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

    March 23, 2016 at 6:08 pm

    #1867282

  • RE: Are the posted questions getting worse?

    ChrisM@Work (3/23/2016)

    How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

    The idea of presenting...

    "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

    March 23, 2016 at 1:56 pm

    #1867230

  • RE: Counting

    This is my "get numbers" or "fntally" function which has served me well.

    I started with what I've learned from Jeff Moden including the 0 or 1 start functionality. Then added...

    "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

    March 23, 2016 at 12:20 pm

    #1867196

  • RE: Avoid Blank Values in a column

    Stephanie Giovannini (3/23/2016)

    David McKinney (3/23/2016)

    A slight variation (although I've not got SQL installed to test it.)

    CONSTRAINT ck_xxx CHECK ('' not in (c1,c2,c3,c4,c5))

    Would you kindly check and let me...

    "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

    March 23, 2016 at 11:26 am

    #1867180

  • RE: Which indexes out of MISSING INDEXes report are most important to implement?

    Grant Fritchey (3/23/2016)

    Happy to help out. I'm rewriting the execution plans book. It should be done soon I hope.

    I finished your execution plan book while I was on vacation last...

    "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

    March 23, 2016 at 11:18 am

    #1867179

  • RE: how to export and import table single table in databe

    There's a bunch of ways. Easiest would be:

    In SQL Server Management Studio right-click the table then navigate to "export" and walk through use the wizard. The most common format/output 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

    March 22, 2016 at 11:07 pm

    #1866988

  • RE: ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

    An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

    I love the precision in these errors....

    "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

    March 22, 2016 at 9:05 pm

    #1866985

  • RE: Advice on query optmization - Multiple Unions

    Also, try to post the DDL and some sample data for the tables referenced in your query. Note the link on how to get help in my signature...

    In 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

    March 22, 2016 at 8:00 pm

    #1866979

  • RE: Advice on query optmization - Multiple Unions

    Can you post the actual (not estimated) execution plans?

    "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

    March 22, 2016 at 7:26 pm

    #1866976

  • RE: SQL

    Interviewing for what position?... DBA? SQL Developer? Data Architect? BI Consultant?

    What kind of interview?... Purely technical, e.g. "what's an index?" Strategic, e.g. "why would you create an index"?

    More...

    "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

    March 21, 2016 at 9:56 pm

    #1866656

Viewing 15 posts - 901 through 915 (of 2,458 total)