Forum Replies Created

Viewing 15 posts - 46 through 60 (of 1,033 total)

  • RE: Behavior of trigger

    Jeff.MSSqlSage (9/10/2013)


    You guys certainly have an interesting definition of what defines "basics".

    I don't think an undocumented feature of the ALTER TRIGGER functionality qualifies as "basics".

    I don't know why or where...

  • RE: Monitoring job history using Reporting Services

    Nice Article... reminds me of Idera's SQL Job manager (free).

    http://www.idera.com/productssolutions/freetools/sqljobmanager

  • RE: SQL Server Tables

    Koen Verbeeck (8/27/2013)


    Too easy question, but nice discussion. 🙂

    Isn't that always the case? 🙂

    That said, around here I believe the statement is... "That table can't be a heap, because...

  • RE: CONCAT 1

    Koen Verbeeck (8/22/2013)


    2 points for this easy question? :w00t:

    Thanks Ron, always nice to have SQL 2012 questions.

    Wow missed that... it's 2 points?

    Good question, thanks Ron!

  • RE: User with total points more than 30000?

    Koen Verbeeck (8/16/2013)


    Apparently a bug in the total leader board not showing the correct levels above SSChampion.

    If you go to the thread mentioned in the reference, you see the correct...

  • RE: Object binding

    Thanks for the question... glad I managed to get through that one without morning caffeine. 🙂

  • RE: SSIS Deployments with SQL Server 2012

    Hey Koen,

    Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂

    Especially with the headaches that come...

  • RE: Sales puzzle

    Good Question. Made my brain engage for a moment or three... now sadly... I must return to the land of MDS.

  • RE: SSIS 2012 -SSISDB

    TaylorMade (8/13/2013)


    I don't even have 2012 installed yet, so I did some research, and found:

    "A folder contains one or more projects and environments in the SSISDB catalog."

    http://technet.microsoft.com/en-us/library/hh479588.aspx

    but the...

  • RE: Exists

    Hugo Kornelis (8/7/2013)


    My coding style is to:

    * Use joins only when I actually need columns from all joined tables;

    * Use EXISTS and NOT EXISTS for any check of existence in...

  • RE: What's in a name?

    george sibbald (7/19/2013)


    renamed to SSDTBI to avoid confusion! could have fooled me.

    So with SQL2012 and 2014 install media we dont get the option to install the BIDS equivalent? that sounds...

  • RE: What will convert return?

    Koen Verbeeck (7/11/2013)


    Good question, oldie but a goodie.

    Explanation however is incorrect. The problem is not that the value exceeds the upper limit of an integer , I'm pretty sure 5555555...

  • RE: Temporary Stored Procedures

    Roland Howard Boorman (6/26/2013)


    Why would you want to write billions of lines of Exec Code?

    Decoding that is utter madness.

    Used carefuly and thoughtfully it avoids precisely sphagetti Code and supplies a...

  • RE: Indexing

    Good question... apparently especially after Steve fixed it.

    🙂

  • RE: SHOWPLAN_XML

    Hugo Kornelis (6/13/2013)


    Given my utter lack of mindreading skills, I flipped a coin. And I got lucky this time, so I picked the correct answer. Which is a good thing...

Viewing 15 posts - 46 through 60 (of 1,033 total)