Forum Replies Created

Viewing 15 posts - 17,356 through 17,370 (of 39,834 total)

  • RE: Need assistance in reconfiguring our backup jobs

    I would. It should patch things up. SP2 had a couple maintenance plan bugs that were fixed in a CU, but if you're going to patch, I'd just go and...

  • RE: help me code for trigger:

    This

    letanduc (12/6/2010)


    I want: on my table (Department_ID nvarchar(2),Possition_ID nvarchar(2))

    never occur: exists

    Makes no sense. What is "never occur: exists?"

    Please spend more than 10 sec and write something that describes the...

  • RE: backup error

    It is a permissions error. Likely you have a problem with the client or your account having permissions to the tool.

    Can you use your account and run a backup from...

  • RE: Function multiple outputs, multiple inputs?

    Are you sure this isn't a join you need to make?

    It's hard to say what you need without more information. As Nigel mentioned, cross apply might do what you want,...

  • RE: System performance limitations

    I'd tend to agree with GSquared. 1GB of RAM is tiny, and you might easily be causing yourself issues with that little memory. Between that and the disk IO, most...

  • RE: Coding With Music

    Kenneth Wymore (12/6/2010)


    I think this could be a whole other forum discussion. "How much of your time is spent doing work other than coding and how much time do you...

  • RE: Need assistance in reconfiguring our backup jobs

    I tend to side with Michael, though if you don't want to touch what the old DBA did, you could add in transaction log backups every 15 minutes and then...

  • RE: Talking baseball

    Jeter signs (http://sports.espn.go.com/new-york/mlb/news/story?id=5884052), though I think they overpaid a bit.

    Still, glad he's still a Yankee.

  • RE: Poor Restore Times

    I don't think that you'd get substantially better performance on SS2K8, but if you want (and have time) install Dev edition on the same hardware and test that.

  • RE: Quick Question.

    Not a lawyer, but my understanding is that standby servers not being used do not need a separate license.

  • RE: Poor Restore Times

    Are you restoring across the network?

    While the backup/restore should be faster in SQL 2005+, I'm not sure it would make a huge difference. Compressing the backups (reducing i/O) and having...

  • RE: cannot login sql server as an administrator

    Did you change anything else? Did you add a deny login for any group?

    Are you sure your Windows account is still a local administrator on the server? Did you verify...

  • RE: LIKE and = Operators

    I updated the explanation to the SS@K8 R2 documentation

  • RE: Are the posted questions getting worse?

    Kit G (12/6/2010)


    Steve Jones - SSC Editor (12/6/2010)


    ... It's actually impossible to get a real person at google.

    Ah ha! I knew it! Google is run by Space Aliens!

    They...

  • RE: Are the posted questions getting worse?

    I'm not saying that GoDaddy is right or wrong, just that mail is hard. And shared mail is harder and extremely frustrating.

    They are a large company, and they run into...

Viewing 15 posts - 17,356 through 17,370 (of 39,834 total)