Viewing 15 posts - 61 through 75 (of 85 total)
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...
June 18, 2009 at 2:45 am
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...
June 18, 2009 at 2:33 am
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...
June 17, 2009 at 6:45 am
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...
June 17, 2009 at 4:54 am
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.
June 17, 2009 at 4:25 am
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...
June 17, 2009 at 4:16 am
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...
June 17, 2009 at 4:13 am
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...
June 17, 2009 at 3:44 am
Have you tried running UPDATE USAGE to see if it's just telling you the wrong information?
June 17, 2009 at 3:33 am
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...
May 25, 2009 at 4:03 am
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...
May 25, 2009 at 2:16 am
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....
May 11, 2009 at 8:33 am
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...
May 11, 2009 at 3:38 am
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...
May 11, 2009 at 1:59 am
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...
May 11, 2009 at 12:42 am
Viewing 15 posts - 61 through 75 (of 85 total)