Forum Replies Created

Viewing 15 posts - 136 through 150 (of 285 total)

  • RE: SQL Script to check SQL Server cluster Nodes.

    Koen Verbeeck (3/15/2011)

    Chris Houghton (3/15/2011)

    Tested select * from ::fn_virtualservernodes() on both 2005 and 2008 clusters and it returned correct results for both.

    So apparently all the three answers are correct?

    Everybody wins!...

    March 15, 2011 at 3:54 am

    #1298739

  • RE: SQL Script to check SQL Server cluster Nodes.

    Koen Verbeeck (3/15/2011)

    When I run "select * from ::fn_virtualservernodes()", this returns no error but an empty resultset (I don't run any failover cluster, so that is to be expected).

    What is...

    March 15, 2011 at 2:42 am

    #1298721

  • RE: SQL Server 2008 R2 Features

    Abi Chapagai (3/13/2011)

    Koen Verbeeck (3/13/2011)

    Very nice question, thanks.

    Thank you all for the comments. This is my first question.

    I look forward to your second one!

    Duncan

    March 14, 2011 at 2:30 am

    #1298222

  • RE: SQL Server 2008 R2 Features

    Really good question. And useful too - I'd written off backup compression as an Enterprise-only feature, and since our clients only use Standard I'd not investigated it properly. I will...

    March 14, 2011 at 2:25 am

    #1298219

  • RE: Upgraded to SQL 2008 but SQL 2005 Services still trying to run

    Glad to hear you got things fixed.

    Duncan

    March 11, 2011 at 8:30 am

    #1297673

  • RE: LOB Data

    Wow, sounds like you're all having some fun this weekend!

    I'm having the in-laws to stay, and taking some junk to the tip. Lucky me!

    March 11, 2011 at 4:44 am

    #1297531

  • RE: LOB Data

    Koen Verbeeck (3/11/2011)

    Relax, it's Friday, even for questions 😀

    Exactly. So, anyone doing anything interesting this weekend?

    😎

    March 11, 2011 at 4:04 am

    #1297517

  • RE: Upgraded to SQL 2008 but SQL 2005 Services still trying to run

    When you say "upgrade" do you mean you upgraded the 2005 instance to 2008, or did you do a side-by-side install? I'm guessing side-by-side if you say you uninstalled afterwards.

    And...

    March 11, 2011 at 1:29 am

    #1297469

  • RE: LOB Data

    Nice easy question! It was obvious that more than one answer was meant to be correct, so I took a punt and figured that the first had been marked as...

    March 11, 2011 at 1:13 am

    #1297464

  • RE: DBA Concerns

    Steve Jones - SSC Editor (3/10/2011)

    This also typically violates the SOX rules of separation of duties. I don't agree with developers having access to production by default. There are security...

    March 10, 2011 at 10:39 am

    #1297237

  • RE: Sorting data issue

    UMG Developer (3/10/2011)

    Yes, you could use an SP, as long as the user doesn't need to be able to write adhoc queries against it. (Even then you could handle that...

    March 10, 2011 at 10:16 am

    #1297217

  • RE: DBA Concerns

    cfradenburg (3/10/2011)

    Duncan Pryde (3/10/2011)

    I've got an email thread somewhere that runs into tens of messages between me and a contractor that was working on a database server of ours. Every...

    March 10, 2011 at 10:13 am

    #1297214

  • RE: DBA Concerns

    SanDroid (3/10/2011)

    drowlfs (3/10/2011)

    TravisDBA (3/10/2011)

    I once worked with a company where the IT manager gave SYSADMIN access to all of his developers on the production db servers.

    I kind of agree with...

    March 10, 2011 at 8:54 am

    #1297152

  • RE: Visual Studio Tools

    Jamie Thomson (3/10/2011)

    Duncan Pryde (3/10/2011)

    Jamie Thomson (3/10/2011)

    The big benefits as far as I can see them are:

    -Development-time error checking (i.e. find out about errors before you actually run the code...

    March 10, 2011 at 6:31 am

    #1297048

  • RE: Visual Studio Tools

    Jamie Thomson (3/10/2011)

    The big benefits as far as I can see them are:

    -Development-time error checking (i.e. find out about errors before you actually run the code - so you wont...

    March 10, 2011 at 6:18 am

    #1297035

Viewing 15 posts - 136 through 150 (of 285 total)