Forum Replies Created

Viewing 15 posts - 271 through 285 (of 497 total)

  • RE: Base-Lining info to compare before and after SPs Performance Tuning modifications ?

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

  • RE: How to partition table

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

  • RE: Table Partition - Can't drop a file group

    ayemya (1/6/2014)


    Hi Keith,

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

  • RE: High CPU Usage

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

  • RE: Budget for Training

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

  • RE: MAXDOP Setting

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

  • RE: Table Partition - Can't drop a file group

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

  • RE: Table Partition - Can't drop a file group

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

  • RE: Date in date range

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

  • RE: How to create member_follower table structure ?

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

  • RE: How to create member_follower table structure ?

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

  • RE: Date in date range

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

  • RE: how to restore TRN files dynamically

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

  • RE: How do you recover to a point in time?

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

  • RE: Help with Query

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

Viewing 15 posts - 271 through 285 (of 497 total)