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...

The question I would ask myself in order to answer your question, what is the most common access path? What will be used more often than anything else to query...

Personally, I'd suggest using a tool that works well with scripts and source control. The three that come to mind are DBGhost, in which I have no experience, Red Gate...

How about disappointed. I was hoping for more. I guess I've been spoiled by Red Gate's SQL Prompt.

Are you kidding, thank you. I hate posting bad information.