To capture the Sql executed by a spid, get the spid's handle from sysprocesses, then pass into table-valued function fn_get_sql in master. Note, if the handle no longer exists in...

I have used Spotlight but never monitored the error log. They caution you that doing so may result in performance degradation. Did you check with the vendor? If so, I'd...

I couldn't agree more! I recently changed jobs specifically because I wanted to be more active with my kid's sports and extracurricular activities. She'll be going to college in another...

GO is not a T-Sql construct. It is only recognized by SQL Server utilities such as QA. See BOL for explanation.

It's not recommended that you force a shrink on...

You're welcome! 🙂

Do a subquery to get your total number of grades per course and divide each grade counts per course (already have) by this to get percentage:

Subquery: SELECT COUNT(Grade)

...

Someguy (5/28/2008)

---

I'm afraid that oil is going to be around for a while. Conserve? Sure. Invest in alternatives? Sure. But let's still keep an open mind about drilling for our...

If you do a search on Recovery Models for SQL Server, you should find several good sites that will answer most of your questions.

See following link for shrinking log...

I have been in my current job for about six months and have been struggling with these very issues. I think both are important, but am not sure one breeds...

My background is in the physical sciences and many of the people I knew were either serious musicians (myself included) or liked to dabble in it as a hobby. When...

It looks like you need single quotes around the IN clause: Where Severity in ('Critical'). Without them, SQL Server thinks you're referencing a column name instead of a column value....

Thanks for the advice G!

It's a pretty basic environment, no Analysis or Reporting Services, data warehousing, etc..., just DTS. So an in-place upgrade is not possible, just detach/re-attach or backup/restore as you mention?

Thanks for...

I enabled AWE and set the max memory setting to 3GB. After rebooting, SQL Server is now using 3GB of memory. Thanks for your help!

The /3GB switch is not in the boot.ini file. It's also not in the other server that is using 3GB of memory.

I did a little more digging and found...