Forum Replies Created

Viewing 15 posts - 61 through 75 (of 146 total)

  • RE: How many rows will be returned?

    Carlo Romagnano (9/23/2014)

    Triggers on tables execute only if at least ONE row is affected. So, explanation is wrong.

    Ummm..... Nope, that's not true.

    I think the question reflects exactly how that isn't...

    September 23, 2014 at 6:16 am

    #1747391

  • RE: How many rows will be returned?

    Good question.

    This is something to consider when using triggers. If you need to execute the code inside the trigger only if it affects some rows, you can use the @@ROWCOUNT...

    September 23, 2014 at 6:12 am

    #1747388

  • RE: ISNULL

    Good question.

    I anticipate many people will go for the NULL answer.

    September 22, 2014 at 5:41 am

    #1747009

  • RE: Which is the correct spatial data type?

    This is a very interesting question.

    I haven't worked with spatial data yet but after eliminating a few of the incorrect answers, went with my gut and got it right.

    Thanks!

    September 19, 2014 at 6:39 am

    #1746690

  • RE: Parameters may improve SQL Backup Performance in SQL Server 2008

    marks_262 (9/18/2014)

    Good question.

    How much can the increase the backup performance by?

    I guess it would depend on the situation.

    For example, as per BOL, the Blocksize default is 65536KB for tape...

    September 18, 2014 at 5:51 am

    #1746348

  • RE: Parameters may improve SQL Backup Performance in SQL Server 2008

    This was a very good question.

    Made me think about options that I would normally not consider.

    Oddly enough I had a brain fart while answering and checked the "Log Consistency Checking"...

    September 18, 2014 at 5:45 am

    #1746346

  • RE: Pausing

    Interesting to know you can't start a new DAC session when the service is paused.

    I was wondering about that. Thanks Hany Helmy!

    Yep.This got me thinking.

    Got it...

    September 17, 2014 at 11:12 am

    #1746174

  • RE: Pausing

    This was a good question, Steve. Thanks.

    September 17, 2014 at 5:52 am

    #1746015

  • RE: Which type of Numbers?

    Hany Helmy (9/16/2014)

    Sean Pearce (9/16/2014)

    And this relates to SQL Server how? I am not here for maths lessons.

    + 1

    + select floor(log(square(POWER(substring (cast (1000 as varchar(10)),1,1),5000))*3))

    September 16, 2014 at 6:41 am

    #1745755

  • RE: Synonyms 2

    Easy one, Steve.

    Thanks!

    September 15, 2014 at 6:23 am

    #1745444

  • RE: Storing code in Version control

    +1.

    Good weekend to all!

    September 12, 2014 at 5:47 am

    #1745041

  • RE: Truncate table query

    Hehehehe... I was thinking about posting this exact same msg :hehe:

    twin.devil (9/11/2014)

    Koen Verbeeck (9/11/2014)

    Please don't say truncate table data isn't logged unless you understand the concepts involved.

    😉

    The Myth that DROP...

    September 11, 2014 at 5:46 am

    #1744713

  • RE: Merge Targets

    Yep.

    Somebody made a boo boo.

    September 9, 2014 at 6:09 am

    #1744079

  • RE: Synonyms 1

    Mighty (9/8/2014)

    Eirikur Eiriksson (9/7/2014)

    ...but it works for Joe in HR (that's his default schema);-)

    😎

    It depends. It only works if Joe (or anyone else with default schema 'HumanResources') would create...

    September 8, 2014 at 5:59 am

    #1743828

  • RE: Central Respository

    Thanks for the question, Steve.

    September 5, 2014 at 5:37 am

    #1743477

Viewing 15 posts - 61 through 75 (of 146 total)