Forum Replies Created

Viewing 15 posts - 3,586 through 3,600 (of 8,416 total)

  • RE: Insert Column Default Values

    Peter Brinkhaus (4/30/2010)

    If the LunchPeriod is not explicitly inserted it's default value will be filled in the 'inserted' row set within the trigger. Given that it easy to modify and...

    April 30, 2010 at 7:36 am

    #1160406

  • RE: Insert Column Default Values

    How about:

    USE tempdb;

    GO

    CREATE TABLE dbo.Class

    (

    ClassID ...

    April 30, 2010 at 7:33 am

    #1160402

  • RE: Backups

    Christian Buettner-167247 (4/30/2010)

    Hi Paul, thanks for your reply. I managed to get it done with your second option, but the first option does not work for me. The screen looks...

    April 30, 2010 at 4:20 am

    #1160297

  • RE: Backups

    Christian Buettner-167247 (4/30/2010)

    Not sure what you mean. Just to clarify my question a bit: I have restored everything, except the tail log backup (and I am in no-recovery). If I...

    April 30, 2010 at 3:55 am

    #1160286

  • RE: The statistics affect the sort ?!

    Stefan_G (4/29/2010)

    Paul, could you possibly expand a little on what you mean here? What do you mean by logical and physical in this context?

    Hey, Stefan. I see Grant...

    April 30, 2010 at 3:39 am

    #1160282

  • RE: Backups

    Christian Buettner-167247 (4/30/2010)

    Tested it with SSMS and failed ("Select the Backup Sets to restore" shows no entries after selecting the tail backup in "From device:")

    ...

    If anyone could tell me if...

    April 30, 2010 at 3:05 am

    #1160270

  • RE: Backups

    awoodhouse (4/29/2010)

    The question threw me off. Tuesday @ 4pm is not the 'latest differential backup'. Wednesday 8am is.

    I have some sympathy with this view. So many QotDs have tried...

    April 30, 2010 at 12:32 am

    #1160222

  • RE: Backups

    CirquedeSQLeil (4/29/2010)

    The part that gets me with these questions is if the hardware failure was enough to corrupt the database and the full backup - it would seem to me...

    April 30, 2010 at 12:23 am

    #1160214

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/29/2010)

    You guys have more patience than I. That series would have torqued me off pretty good.

    Yep, glad I missed that thread.

    April 30, 2010 at 12:07 am

    #1160206

  • RE: Missing numbers in a series

    Atif Sheikh (4/29/2010)

    Not much. Basically, concept was of tally table. I implemented with the memory table, which was supposed to be created by sys.columns or other table like that.:-D.

    Yep I...

    April 30, 2010 at 12:05 am

    #1160205

  • RE: The statistics affect the sort ?!

    Matt Miller

    So - if the DB engine doesn't see there being any improvement in rebuilding (say - the index is so small that it will always fit in memory), you...

    April 29, 2010 at 11:12 pm

    #1160178

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/29/2010)

    Weird. You should complain to the guys that run the site.

    I should. Any idea who that is? 🙂

    April 29, 2010 at 9:22 am

    #1159802

  • RE: Cast Float to Char with Natural Rounding

    irobertson (4/29/2010)

    Paul, cast to double precision works perfectly, no complex functions required.

    Hey Iain,

    Double precision is just a synonym of float.

    I thought my function was reasonably complex 😉 😀 :w00t:

    Sounds like...

    April 29, 2010 at 8:25 am

    #1159733

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/29/2010)

    Thanks. I'll pass it on if you haven't already.

    I replied on Ask, but thanks for posting the thread reference there too.

    I don't usually post on Ask because every...

    April 29, 2010 at 8:21 am

    #1159729

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/29/2010)

    Jeff, or anyone else that knows a heck of a lot more about decimals than I do, please go check this question on Ask.SQLServerCentral. I really don't have...

    April 29, 2010 at 7:49 am

    #1159696

Viewing 15 posts - 3,586 through 3,600 (of 8,416 total)