Forum Replies Created

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

  • RE: Common questions asked in SQL Server DBA Interview

    Are you the DBA going to the interview or are you doing the interviewing?

    Search for 'sql server DBA interview questions' on google.

    One question that I ask that hardly anyone gets...

  • RE: Database size monitoring

    The script is quite complicated as it also does a lot more than just get the log size and would need a lot of explaining that I've not got time...

  • RE: xp_cmdshell priviledges problem

    I've sorted the problem, I found on a microsoft forum that someone had a similar problem, they had no idea why it worked but they rebooted and it worked.

    I rebooted...

  • RE: Arichtecture HELP

    Not using Standard edition, you don't have many options other than what you have mentioned or develop your own system of moving data about with SSIS but by the time...

  • RE: Arichtecture HELP

    If it's all 2005 it's a lot better, no more having to be on the same hotfix level etc you had with 2000 so it's a lot easier to manage.

  • RE: Arichtecture HELP

    If your bad experiences were in 2000 with the replication then I'd give replication another go, it's a lot better in 2005 and more stable. If not just have...

  • RE: DB available space ZERO!!!

    No problem, I run UPDATEUSAGE every night as I get stats for the database sizes etc so need them to be accurate but it's worth running this on a regular...

  • RE: Database size monitoring

    You say the used space for the transaction logs never grows but you are only running this script once a day.

    I have scripts that monitor the log space but I...

  • RE: DB available space ZERO!!!

    Have you tried running UPDATE USAGE to see if it's just telling you the wrong information?

  • RE: No Virtual Directories

    Thank you, this helped, having realised that 2008 did not use IIS I changed the ports to 8080 instead of the default 80 in the configuration manager and it stopped...

  • RE: No Virtual Directories

    I had run it in 2005 and it was working but then after I installed 2008, neither worked so I uninstalled 2005 as I wanted to use 2008 but it...

  • RE: Performance degradation after update statistics

    From BOL (2008 version but I couldn't find it in 2005 but sure it's there!!!!!!):

    "Updating statistics ensures that queries compile with up-to-date statistics. However, updating statistics causes queries to recompile....

  • RE: Rebuilding indexes

    For an online index rebuild it means that all the tables will not be locked, for offline the tables would be locked so if you want your database to be...

  • RE: SQLRAP

    You have to ask Microsoft to come and do it for you, it's a bit of consultancy on their part, you can download the description, which doesn't tell you much...

  • RE: SQLRAP

    Thanks, we get it free on contract here and they're booked in for next month, I was a bit skeptical at first but I'm now quite looking forward to it...

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