sp_MSforeachtable @command1="select count(*), '?' from ?"

I was a few months ago

Note that if the value you are testing is blank or just spaces, then either LTRIM or RTRIM will reduce it to a zero-length string.  You don't need to do...

Have you started the service with trace flag 1400?

See: http://support.microsoft.com/default.aspx?scid=kb;en-us;907741

[Quoting the above article]

Currently, Microsoft support policies do not apply to the database mirroring feature in Microsoft SQL Server 2005.

By default,...

Placing the "$" character in front of a formatted number makes it a character value, which is not a number, and cannot be stored as a number.

Formatting rules are not...

#include usual and customary warnings about using undocumented features (test outside of production, have good backups, etc.)

...that being said...

There is an undocumented trace flag that will disable lock escalation.  I...

I've used that technique - performing an XSLT translation on data to convert it to an Updategram document - several times to deal with stuffing data from several different sources...

> I’ve noticed in the search option for adding logins the only object types for logins that are available are "users", "groups" and “Built-in security...

With few execptions (bulk inserts in the bulk-logged recovery model), all database changes are written to the log first.  Later, another process captures those changes that have been committed and...

Using it for what purpose?  Reading in XML?  Producing results as XML?  Using the SQLXML ISAPI framework with template queries?  Updategrams & diffgrams created with XSLT transformations of inbound XML...

Eight years ago, answering this question spawned an entire industry.

You could put something together with a derived table, by adding a column to your original query, wrapping at all up...

> What do you mean by foreign key column?

In an enforced relationship, there are two sides to the equation:  The parent table (such as a list of customers), and the...

Create a nonclustered index on the foreign key column(s).  Then the relationship-checking will use the indexes instead of running through the entire table.  SQL Server automatically creates an index on...

If I were an internal admin, and it would be my butt on the line or me getting the midnight call when there was a problem with the server, then...

It's stored in sysindexes, although that number isn't always up to date.  Take a look in BOL for the system stored procedure sp_spaceused for the recommended way to retreive that...