So, did anyone else have a strangely intense dream recently about being, outside looking up at the night sky, and then a constellation of stars coalesce into a UFO that...

Assuming that the default trace is running (which it should be by default) and the retention window covers the time frame you're interested in, then that query I posted earlier...

The following default trace query will tell you when file growth events occurred, the database name and size of the growth, and login name of the user who executed the...

I've ported database schemas (tables, stored procedures, and SQL) between RDMS platforms on a handful of occasions, and there is always the urge to refactor as I'm porting. One thing...

If what you're doing is running a report or ad-hoc query where the results are returned to an external application, then perhaps NOLOCK and less trustworthy data is not a...

The slight differences in SQL syntax between database platforms are mostly trivial. However, when porting SQL code between PL/SQL and T-SQL, it is essential to remember that in the parallel...