Forum Replies Created

Viewing 15 posts - 196 through 210 (of 2,462 total)

  • RE: sp_msforeachdb

    sqlguy80 - Wednesday, October 4, 2017 5:18 PM

    Hi,

    Can you suggest some T-SQL code  to automate so that a script say select *...

    "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

    October 4, 2017 at 6:11 pm

    #1962379

  • RE: We Have a Date

    Jason A. Long - Thursday, September 28, 2017 6:05 PM

    Alan.B - Thursday, September 28, 2017 5:07 PM

    "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

    September 28, 2017 at 9:43 pm

    #1961506

  • RE: We Have a Date

    The Data Tuning Adviser is going to recommend columnstore indexes for me? October 2nd can't come soon enough! </sarcasm>

    It's cool to finally see some new T-SQL commands. TRIM and...

    "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

    September 28, 2017 at 5:07 pm

    #1961500

  • RE: SQL Server 2017

    sqlfriends - Thursday, September 28, 2017 11:22 AM

    Have SQL server 2017 officially released or not?
    From Microsoft site, I can see there 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

    September 28, 2017 at 4:46 pm

    #1961499

  • RE: SQL Server 2017

    Thom A - Thursday, September 28, 2017 11:36 AM

    sqlfriends - Thursday, September 28, 2017 11:22 AM
    "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

    September 28, 2017 at 4:42 pm

    #1961498

  • RE: Using Code Snippets in SSMS

    SQLvis - Monday, December 19, 2016 7:43 PM

    Have you tried directly adding your folders under:C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\SQL\Snippets\1033I would also assume...

    "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

    September 27, 2017 at 5:51 am

    #1961118

  • RE: Are the posted questions getting worse?

    Tom_Hogan - Monday, September 25, 2017 12:29 PM

    According to the asterisk, SQL Server 2017 will be available for download on October 2nd.

    "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

    September 26, 2017 at 12:03 pm

    #1961028

  • RE: Hierarchy in a Fact table - Referring to itself

    You are all over the place here. As xsevensinzx said, some examples/visuals would be helpful. Also, a better explanation of what you mean by, "Up until now, we used 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

    September 24, 2017 at 11:13 am

    #1960650

  • RE: How to encrypt Credit Card numbers?

    NEVER be so as to STUPID say "Before I will start Google.."; This just ended your care\er because anyone hires you, they will see this posting and know.

    Everyone...

    "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

    September 21, 2017 at 2:18 pm

    #1960419

  • RE: Are the posted questions getting worse?

    SQL Server is so weird sometimes. 

    select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
    returns abc.

    "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

    September 19, 2017 at 4:44 pm

    #1960055

  • RE: Year to date calculation

    I don't fully understand the req but here's some sample data and some t-sql code which might point you in the right direction. 

    -- sample data
    declare @order...

    "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

    September 19, 2017 at 10:31 am

    #1959994

  • RE: ? on Parsing an XML field

    Eirikur Eiriksson - Monday, September 18, 2017 10:25 PM

    Here is something to get you started
    😎

    USE TEEST;
    GO
    SET NOCOUNT ON;

    DECLARE @TXML...

    "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

    September 19, 2017 at 9:31 am

    #1959973

  • RE: remove spaces in strings

    As drew said, you are likely dealing with a non-space whitespace character; what Luis posted will help you identify what that character is. 

    This can easily be resolved using...

    "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

    September 13, 2017 at 12:10 pm

    #1959310

  • RE: comma separated values

    Expanding on Jeff's comments - this is one of those things that's worth understanding as FOR XML can be a complicated topic. Wayne Sheffield's article, Creating a comma-separated...

    "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

    September 12, 2017 at 1:23 pm

    #1959174

  • RE: If you weren't a DBA, what would you be doing?

    I'm not a DBA anymore (SQL Developer.)  In high school I was studying to be an artist but chickened out only because of fear that I would not make any...

    "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

    September 7, 2017 at 12:50 pm

    #1958629

Viewing 15 posts - 196 through 210 (of 2,462 total)