What is the current issue with the stored procedures that you are trying to resolve? Duration? Reads? Writes? Is there a specific wait type that is an issue that you...

A couple of things:

- Partitioning is not what you are looking for (as pointed out by Gail) at least not SQL Server Partitioning. You may want to look into vertical...

ayemya (1/6/2014)

Thank you so much for looking into my question. I have watched Kendra's video and tried out your script. It works perfect.

In my case, the partition was already...

I would recommend that you use Adam Machanic's sp_whoisactive to see what is going on during these times of high CPU usage. You could also setup a server side trace...

Nice article Steve!

In my MCM prep I had to get pretty good at craving some time out for my studying. Problem is once I passed my test I stopped my...

Is there a reason you want to change MAXDOP or are you just looking for a best practice? Unless you are seeing CXPACKET waits (that are causing problems) I would...

Looks like you were following Kendra Little's examples[/url]. These are excellent examples, but note that she talks about having two empty partitions at the beginning and end of your data....

Your script is missing your DailyPS creation. Please add that back to the script. Thanks

Would this work for you?

CREATE TABLE [dbo].[duties](

[id] [int] NOT NULL,

[dutydate] [datetime] NULL,

[duty] [nchar](10) NULL,

CONSTRAINT [PK_duties] PRIMARY KEY CLUSTERED

(

[id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS...

Yes you would need 2 FKS back to the member table. It is fine to have multiple FKs back to the same parent table.

With the information that you have provided I would suggest creating another table (MemberFollow not crazy about the name, but oh well) and have two FKs back to the member...

Could you provide some DDL and also some sample data with expected outcome? Please look at the first article in my signature for additional help on posting questions to the...

Not sure that I understand your question. You want to be able to pick a point-in-time to restore to and have a script to generate all of the .trn files...

As pointed out by previous poster you need to have a tlog back that was taken after the time you want to restore to i.e. Wed 1pm Tlog backup. Make...

Do you need to know which table has the lower price?