In the past I used Foglight from Quest, but I wasn't crazy about it. We're using Operations Manager from Microsoft for server monitoring. It also works pretty well on the...

You might want to lookup the term "sql injection" because you're pretty vulnerable.

First, try using BETWEEN instead of >= <= on the date fields.

Can you post the execution plan?

I agree with the last post, it doesn't sound like an optimal approach. Transactional replication is usually only, at most, a few seconds behind the replicated database. Is this a...

And, as always, an execution plan or two.

The columns defined in the INCLUDE statement are stored at the leaf level of the non-clustered index. There's no need to go to the cluster or a heap to retrieve...

Or you can query against the INFORMATION_SCHEMA.TABLES.

1) There are too many things to list. It starts with, is the server on? Is the database online? and extends out to blocking transactions or any number of other...

Straight out of the Books Online:

CREATE PARTITION FUNCTION myRangePF1 (int)

AS RANGE LEFT FOR VALUES (1, 100, 1000) ;

GO

CREATE PARTITION SCHEME myRangePS1

AS PARTITION myRangePF1

TO (test1fg, test2fg, test3fg, test4fg) ;

GO

CREATE TABLE PartitionTable...

I'm beginning to see the same thing. As more and more shops start to use generated databases through products like nHibernate, the idea of laying out the data structure, of...

And yes, for large tables, they can increase performance.

I'm as curious as Brandie is and you'll have to agree, that's pretty abbie-someone.

That's great news. Thanks for sharing.

Not really unless you get the Team System Database Edition.

Well, I'd say you have to reign it in. First, you need to get the core code into source control. After that, you can start working to label builds so...

Jeez. I read the question twice and I still don't notice this:

That should probably be the leading edge...