It doesn't really matter if the log is truncated by the differential backup, if there is little activity overnight then the 9PM - 5AM activity is not growing the log...

The whole reason that database servers lock records for the duration of a transaction is because they have considered the fact that multiple clients may be trying to change the...

I think you can be reasonably confident of being able to restore your database to any point in time between 3AM and 9PM.  But there are some things in your...

CASE is a function, even if it looks like a statement, and it can be used anywhere an expression is legal including WHERE, GROUP BY, ORDER BY, and so on. ...

I went through this a while back when I found out (for the second or third time) that once anyone in the development group has the sa password for any...

I should clarify that my last post was just a response to "does 64 bit give you any extra processing speed?".  You still have to look at everything you are...

64-bit can potentially give you a big performance boost, depending on your workload.  32-bit systems with AWE can use memory beyond 4GB for additional buffer pool space, while other structures...

I tried posting the script but the Confirm Submission function wouldn't work.  I have emailed it to the article email address, maybe someone there can get it taken care of. ...

You must have SQL Server running under a domain account to access network resources, but the GUI will still only let you point-and-click to local drives on the server.  If...

The best graphical environment for managing SQL Server is Management Studio, but it's not the only way.  The fancier versions of Visual Studio also include database management tools.  There are...

An important point is that while the file format is proprietary, there are two ways to restore them on other servers without installing more copies of LiteSpeed.  There is an extractor...

You should try to figure out why tempdb growth is out of hand and fix the problem.  But the options you mention are also good ideas.

You should size tempdb to...

For about 23 years of my 30-year career I have worked in jobs that I got because someone who knew my work asked me to come work for them.  I...

The space occupied by deleted rows is available for storage of new data in the same table when new rows are inserted, so technically the documentation is correct, although misleading. ...

It doesn't get fixed because it isn't a bug, it's the way a heap table must be managed.  The page in Books Online for DELETE spells it out quite clearly,...