Viewing 15 posts - 271 through 285 (of 497 total)
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...
January 7, 2014 at 9:04 am
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...
January 7, 2014 at 8:57 am
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...
January 7, 2014 at 8:42 am
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...
January 6, 2014 at 10:41 am
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...
January 6, 2014 at 9:50 am
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...
January 6, 2014 at 9:00 am
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....
January 6, 2014 at 8:48 am
Your script is missing your DailyPS creation. Please add that back to the script. Thanks
January 3, 2014 at 9:20 am
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...
December 23, 2013 at 11:14 am
Yes you would need 2 FKS back to the member table. It is fine to have multiple FKs back to the same parent table.
December 23, 2013 at 10:46 am
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...
December 23, 2013 at 10:21 am
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...
December 23, 2013 at 10:14 am
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...
December 23, 2013 at 9:04 am
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...
December 17, 2013 at 9:01 am
Do you need to know which table has the lower price?
December 16, 2013 at 6:31 pm
Viewing 15 posts - 271 through 285 (of 497 total)