Backups always work if they complete successfully and have a valid header. Once upon a job the other DBA deleted 50,000 records by mistake. Many of them were...

The optimizer won't grab a field if it doesn't have to. If you use, for instance, a covering index, it won't even hit the main table at all but...

Also verify that the 2008 instance is set to receive remote connections on the protocol you are using (pipes vs. TCP/IP only). This can be turned off and you...

And specifically in Profiler, you can profile completed queries using a certain amount of CPU time. Set a threshold for what would be a "long" query and set the...

From BO:

"Individual DELETE or UPDATE statements can start a series of cascading referential actions. For example, a database contains three tables: TableA, TableB, and TableC. A foreign key in TableB...

Because of the non-uniqueness of col1 by itself, it alone cannot be a primary key by definition and in all truth it is not a generic key candidate at large....

Greg Snidow (7/6/2010)

---

Asif, we kind of need some rules here. For example, is the first instance of Ignition=1 meant to signify the engine was turned on at this time?...

No particular ideas except to say that 80 GB isn't a particularly large database, and the data sets you describe don't strike me as unusually large either. I supported...

One other practical concern with GUIDs for PKs is the ability to run queries. When you troubleshoot, most often I find that I use the PK to specify the...

Put it this way -- as long as there are things like SOX and HIPAA there will need to be some forms of DBA tiers. Developers usually don't have...

I recently made a jump from a small-to-midsizeish company where I was the only DBA to a Fortune 20 company. The small company, which is cost-cutting and looks for...

No -- DBCC ShrinkDatabase is not one of the minimally logged operations, so bulk logging won't help you.

Besides -- SIMPLE is going to be better for log space than bulk...

Not much more you can do. If you are in SIMPLE mode, you're truncating the log as fast as you can, and shrinking a database is a logged operation....

And in my experience, you'll probably need more than just the log table, if you are doing reports (since logs can be inefficient in joins for reports). You'll probably...

It helps, it confirms my thinking. 1) and 3) are not options here -- they want to use the existing schema for all reporting (since this is a report...