Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 10,144 total)

  • RE: Are the posted questions getting worse?

    BLOB_EATER (9/30/2016)

    Thanks to those that have given me advice! this is a great forum.

    So you and Mrs Blobby are talking to each other again? 😀

    October 3, 2016 at 1:43 am

    #1904331

  • RE: Are the posted questions getting worse?

    BLOB_EATER (9/30/2016)

    I'm super pumped at the moment 1 of my tutorials on Azure DWH will be moving over to the Microsoft website-wiki. :w00t:

    Gosh, nice job Blobby!

    October 3, 2016 at 1:42 am

    #1904330

  • RE: One to Many relations

    moranamon (9/30/2016)

    Hi Leo,

    Thanks for your reply.

    With your permission i would to explain again approach #1.

    Three entities, let's name them all.

    Employees, Houses, Cars. lets assume that each one of them should...

    September 30, 2016 at 8:16 am

    #1904164

  • RE: Assign result of dynamic sql to variable

    sanjaydut26 (9/30/2016)

    I modified the query to

    Declare @query nvarchar(max)

    set @query = dbo.ufn_GetHcmDesignFields(3, 31418)

    Declare @query2 nvarchar(max)

    EXEC sp_executesql N'@query','@query2 nvarchar(max) output',@query2 output

    select @query2 as Test

    I get the same error

    Can you post the...

    September 30, 2016 at 8:01 am

    #1904160

  • RE: Today's Random Word!

    Kaye Cahs (9/30/2016)

    djj (9/29/2016)

    Grumpy DBA (9/29/2016)

    HappyGeek (9/29/2016)

    Coat

    Paint

    Brush

    Hair

    Today

    September 30, 2016 at 7:34 am

    #1904154

  • RE: Method to compare on resultset to part of another

    Some pointers in the right direction - and kudos for asking for them instead of a solution. The type of problem you are investigating is called "Relational Division".

    The late...

    September 30, 2016 at 4:57 am

    #1904115

  • RE: Deadlock error MERGE

    javirsantos (9/30/2016)

    I set up a test environment with S2 CU1 patch level and gives the same error, deadlock.

    There's a strong relationship between transaction duration and deadlock occurrence. Speeding up your...

    September 30, 2016 at 3:49 am

    #1904107

  • RE: Intentional Normalization Violation

    BSavoie (9/29/2016)

    ...

    Many of our queries could care less about the many statuses for a given Order, all they care about is the current status. For these queries, having to join...

    September 30, 2016 at 3:37 am

    #1904103

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/18/2016)

    Now where is that crystal ball again?

    😎

    You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years...

    September 19, 2016 at 1:52 am

    #1901567

  • RE: finding max value between dates

    astrid 69000 (9/18/2016)

    this is the result i need

    i have attached an excel cause i dont know how to make a sample of a table to show it.

    That's similar to...

    September 19, 2016 at 1:49 am

    #1901566

  • RE: Warning: The join order has been enforced because a local join hint is used. ( two views )

    Kevin.J.Small (9/16/2016)

    I was encountering this error also and did a search and found this thread. I think there is also an issue in SQL Server in reporting this error...

    September 16, 2016 at 8:03 am

    #1901357

  • RE: Index guidance needed

    MickyD (9/16/2016)

    Thanks all some great topics for me to continue comms with the Devs there.

    I will extract execution plan on the simple select I have been sent.

    thanks again

    Please could you...

    September 16, 2016 at 4:47 am

    #1901304

  • RE: delete millions of rows

    Jeff Moden (9/13/2016)

    ChrisM@Work (9/13/2016)

    Eric M Russell (9/12/2016)

    4 million rows is actually not a lot, but it depends on the speed of your storage system and whether the table will need...

    September 16, 2016 at 1:34 am

    #1901286

  • RE: Split string using multiple delimiters - version 2

    Iwas Bornready (9/15/2016)

    ChrisM@Work (9/15/2016)

    Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter?

    Here's one I knocked up in a couple of...

    September 15, 2016 at 8:40 am

    #1901126

  • RE: Split string using multiple delimiters - version 2

    Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter?

    Here's one I knocked up in a couple of minutes to show...

    September 15, 2016 at 3:01 am

    #1901047

Viewing 15 posts - 1,171 through 1,185 (of 10,144 total)