For input? No. It can render to both word, html and other formats though.

I would configure it in a separate cluster group.

If you put in a cluster group with one of your instances, a failover of that group would bring down MSDTC...

Ok, let's moderate my statement a bit. DTA may be an ok topplister og you Know indexing well, otherwise it is a dangerous took which can cause you trouble. The...

Well, we may have different opinions here. The sum of a column in an empty record set does not make any sense to me. The only aggreate function which makes...

DTA is not very good either. I've had a few cases where my customers had applied the suggestions from DTA, and I had to undo those operations to get the...

I'm impressed that people clearly states that you need the sencond. I find it extremely unlikely that you need both, but which index you need is a different matter.

I'd...

This is indeed the correct behavior if no rows are matching:

select SUM(ISNULL(object_id, 0))

from tempdb.sys.objects

where type = 'X'

What you may want to do is to swap isnull and sum:

select ISNULL(SUM(object_id), 0)

from...

depending on the format of your date:

select count(*) from yourtable where cast(column as datetime) between '2010-01-01' and '2011-01-01'

select count(*) from yourtable where convert(datetime, column, 112) between '2010-01-01' and '2011-01-01'

More information...

Are you running the setup as a domain user? Local users don't have access inn the domain. If you don't pay attention, you can easily end up logging in using...

Gail is absolutely right. Percentages are always estimates, and should be taken with a grain of salt (or sometimes a whole refinery). As Kimberly tripp once told me: Actual execution...

Thanks for the feedback. I did not mention Lock Pages in Memory simply because it's a post on Maximum and Minimum Server memory. The service account should always have the...

I'd guess that this is happens because MSDTC is not correctly configured in the cluster.

As I said, take it with a grain of salt, there are some time since I tested it 🙂 When comparing backup, which is sequential read/write, I measure thoughput. I...

As for maximum memory option as you mention, I'll have to disagree. I've written about it on my blog. These guidelines are pretty much the same as Brent Ozar's (MVP...

It depends on the memory configuration of your instance. If it is not limited to 6-8GB memory, I would say that you should not worry. SQL Server can allocate approximately...