Hi Gail,

We are hoping to...

# Be able to mange our data in smaller more manageable chunks.

# Be able to manage index maintenance on the table more efficiently.

# Archive data more...

Thanks.

Just to clarify, from what you have said, I take it that you are suggesting that I don't create a non-clustered index on the [PartitionKey] column as this defeats the...

All the indexes are partition aligned.

I'm just wondering if it's worth creating a non-unique non-clustered index on the [PartitionKey] and leaving the current clustered index alone?

Or from your experience would...

Thanks Gail,

Completely agree with your comment on #2, #3 #4 and #5. I have see in the past some performance improvements following a bit of clever partitioning on extremely...

Hi Gail,

We are hoping to achieve (

# Faster data searches.

# Be able to mange our data in smaller more manageable chunks.

# Be able to manage index maintenance on the table...

Thanks Johan for the updated post.

Hi Johan,

Thanks for your response. I've previously read through that article a few times, and it doesn't really answer my question.

I'm basically curious as to whether or not it...

H,

Thanks for your reply. Apologies, I will try and be a little more specific.

Using Sql Server 2008 SSMS if I run the query:

select distinct ([type]) from sys.dm_os_memory_clerks;

The following rows are...

Hi Rex/Lowell,

Thanks for your replies. I am aware of how to script all objects in a database into individual files, the question is, I have to include the "IF...

Hi Guys,

Thanks for all your replies, at the moment there is nothing set in stone, we are just reviewing the different options available:

1. Set "Identity" to "Yes" for all PK...

Thanks Lowell, I found the list extremely useful.

Thanks again for your help, it's greatly appreciated. I'm just having a play around with the "Data Collection" tool now and from what I have seen I will definitely...

Hi Grant,

Thanks for your comments, much appreciated.

With regards to looking at what code the users are executing and SQL Server query plans I was planning on using something like:

select qs.execution_count...

Thanks for your help guys, much appreciated.

Hi,

Thanks for you reply, I never stated that we were restoring the master database every night. We are planning on using the system db restore process as a backup...