its important that your current job title accurately reflects the nature of the work that you do and closely alligns with the titles used in the job market. Putting...

IMO the single biggest reason why enterprises do not go down the 3rd party SQL monitoring software route is cost. Some of these performance monitoring tools are close to...

who is using SQL Server in Curacao? Banking or gambling? Its hard to tell the difference these days 😉

yes, but this doesn't tell me how much free space you'll need for the SORT.

the reports are blocked by the CREATE INDEX

my BCP OUT just finished...

turns out a data load kicked in while I was BCPing OUT so the BCP waited for that to finish. Never knew BCP was so clever....

personally I dont like spanned volumes. AFAIK it offers no extra IO or resilience. The only reason we landed up with spanned volumes on a few servers was because we...

I still use:

EXEC sp_who2 active

to check for blocking and slow, long running queries.

I can't talk for others but many times you have transaction log backups configured to run quite regularly like every hour - 24 hours/day. Log shipping is an example. Often...

was there a failover? This will clear proc cache as SQL will re-start.

Its Ok to run a tran log backup job at the same time as FULL backup. The tran log backup job will wait for the FULL to finish.

Sure, you can use SQL Profiler to log the durations on the stored procs. Use RPC:Completed or SP:completed event and check the duration there.

I would.t use port 1434. isn't that reserved for the Browser service? Have you tried a different port?

in addition if you still see inconstencies then run @updateusage=TRUE to update space figures.

No, not necessary. ResourceDB is used for upgrading and rolling back service packs. You new install on the new hardware will create one of these for you. AFAIK you...