Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 2,463 total)

  • RE: SQL HTML

    Since nobody else is providing a solution I'll give it a try. I am simplifying the query against sys.columns because I don't really understand what you are doing. That said,...

    "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 1, 2015 at 8:18 pm

    #1788174

  • RE: Expression to TRIM

    You could also modify your stored proc (or ad hoc query) that feeds the dataset to format the data before it gets to SSRS. Your query would look something like...

    "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 1, 2015 at 8:12 pm

    #1788173

  • RE: Identity on Uniqueidentifier

    If you wanted to get a column to act like an identity column but to be a uniqueidentifier instead of an int you could do this:

    CREATE TABLE dbo.yourtable

    (

    pk_col AS newid(),

    xxx...

    "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 1, 2015 at 7:49 pm

    #1788171

  • RE: T-SQL Help...probably pretty simple but I'm tired :)

    Eirikur Eiriksson (3/31/2015)

    ScottPletcher (3/31/2015)

    As a side note, but still critical, let me warn everyone to use lowercase only for data type names in SQL Server. That is, "int" not...

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

    #1787847

  • RE: Need Sample Data

    Thanks Luis. That stack overflow thread led me in the right direction.

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

    #1787845

  • RE: Parameter Validation ?

    Sorry, I almost forgot about this post. I put together an example of how you would do what I was talking about; attached is the RDL so you can just...

    "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 27, 2015 at 3:48 pm

    #1787055

  • RE: Microsoft and R

    chrisn-585491 (3/25/2015)

    Plus F# isn't a wallflower. F# is the best of the functional first languages. If you are a serious developer and not just a CRUD developer, F# is 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

    March 27, 2015 at 2:54 pm

    #1787039

  • RE: Employee status on first and last day of a pay period

    I am still working on a solution to this, (I thought I had something but just saw your reply to Jeff)...

    In the meantime I came up with a better way...

    "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 27, 2015 at 11:12 am

    #1786995

  • RE: Help Cannot update ID Witn Xquery

    This is a somewhat ambiguous request. Can you explain what the @NewID, @GroupID, and @i variables are for. We're those something you were attempting to use to solve 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 27, 2015 at 2:52 am

    #1786775

  • RE: Problem with creating XML file by nesting functions

    Not to take anything away from what joe put together for you I bet if you put Eirikur's solution into an inline table valued function it would perform much better...

    "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 27, 2015 at 2:37 am

    #1786771

  • RE: SSMS or SSDT

    others bemoan the demise of isql/w

    Yep. I was one of those people. This thread brought back some memories.

    I do all my SQL in SSMS. SS%S happens in Visual Studio.

    "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 27, 2015 at 2:18 am

    #1786767

  • RE: does anyone here still use database triggers?

    Alvin Ramard (3/26/2015)

    Grant Fritchey (3/26/2015)

    Piling on.

    ...

    Now, multi-statement, table-valued, user-defined functions on the other hand, those things are all things evil.

    You mean in a trigger? 😀

    I suspect he meant that...

    "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 26, 2015 at 4:23 pm

    #1786713

  • RE: Create Temp Table vs Truncate & Insert - Performance

    Lowell (3/26/2015)

    my fast proof of concept: drop and recreate is definitely slower

    in a measly 1000 iterations,these were my stats:

    2113 milliseconds for Drop and Recreate

    543 milliseconds for Truncate Existing Table

    and my...

    "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 26, 2015 at 4:17 pm

    #1786712

  • RE: Parameter Validation ?

    Just to add to what Magoo said, if you don't have a dates table (and can't create one) you could create a stored proc that produces one like so (just...

    "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 26, 2015 at 3:25 pm

    #1786701

  • RE: does anyone here still use database triggers?

    I don't think there is anything wrong with Triggers when used for the right reasons and used correctly. I have seen people do bad things with triggers.

    Dwain Camps recently...

    "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 26, 2015 at 2:33 pm

    #1786687

Viewing 15 posts - 1,666 through 1,680 (of 2,463 total)