I've interviewed a bunch of people for DBA role. For me, cert or no cert comes in a package. I'm willing to pay good money for good skill. Ask me...

my comment of using Management Studio:

My role is just pure DBA but even that i've still got a bit difficulty using Ctrl+K Ctrl+C to comment code. Probably i'm too used...

totally agree, because that's what i've found out as well. there a limitation in 32-bit sql2005 cant assign >25% of data buffer for sorting, grouping, etc. i think you'll hit...

Reena,

With 8GB memory, /PAE, /3GB and AWE all needs to be enabled. On a SQL 2K standard edition, i dont think you can make the sql use more than 2GB...

when you say sql performance is running slow, run profiler and only track those t-sql or stored procs that runs more than certain time (4s, etc). analyze to see if...

first of all, you'll have to make sure your sql is configured to access memory more than 3GB first. since this is a 32-bit sql, you'll have to grant sql...

Avoid framing block comments.

This sounds not right. We've got very tight change management in place => you cant do as you please once its on production.

i dont find the block comments...

Mike,

Create a database snapshot to view your database. You should be able to find more info from BOL.

It goes like

CREATE DATABASE snapshotDB ON

( NAME = N'DB_datafile',

  FILENAME = N'E:\DB_Snapshots\DB_snapshot_2502061800.snap'...