Viewing 15 posts - 361 through 375 (of 3,738 total)
I'm looking at another table that is much worse:
/****** Object: Table [dbo].[tblCall] Script Date: 11/30/2015 12:27:50 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblCall](
[Call_ID]...
November 30, 2015 at 10:59 am
ScottPletcher (11/30/2015)
--Edit: removed, exact dup of next post, I got an error during posting and didn't realize it had actually posted anyway.--
I'm sorry but what index are you referring to?
Thanks...
November 30, 2015 at 10:40 am
Welsh Corgi (11/30/2015)
Welsh Corgi (11/30/2015)
ScottPletcher (11/25/2015)
Hopefully this helps a little more:
Chg1) Add column contr_id...
November 30, 2015 at 9:37 am
Welsh Corgi (11/30/2015)
Welsh Corgi (11/30/2015)
ScottPletcher (11/25/2015)
Hopefully this helps a little more:
Chg1) Add column contr_id...
November 30, 2015 at 9:18 am
Welsh Corgi (11/30/2015)
ScottPletcher (11/25/2015)
Hopefully this helps a little more:
Chg1) Add column contr_id as an...
November 30, 2015 at 8:39 am
ScottPletcher (11/25/2015)
Hopefully this helps a little more:
Chg1) Add column contr_id as an INCLUDEd column...
November 30, 2015 at 8:27 am
Scott,
If I have to go with partitioning what changes to the indexes would you recommend?
Thanks.
November 30, 2015 at 8:08 am
ScottPletcher (11/25/2015)
Hopefully this helps a little more:
Chg1) Add column contr_id as an INCLUDEd column...
November 30, 2015 at 8:02 am
Sergiy (11/28/2015)
Welsh Corgi (11/27/2015)
I am against partitioning in this situation.I have archive procedure that is very complex.
How can I convince my VP that partitioning is not the way to go?
First...
November 30, 2015 at 7:55 am
SoHelpMeCodd (11/27/2015)
Welsh Corgi (11/25/2015)
It does not work but it...
November 27, 2015 at 11:19 pm
Thank you very much for your help.
I'm looking to partition by year.
My current archive code looks up the year in a lookup table.
I want to mimic that logic in a...
November 26, 2015 at 1:10 am
The following example baffles me about Indexes Where it uses a date file in the indexes and it talks about aligned indexes.
It does not work but it is similar to...
November 25, 2015 at 2:37 pm
The "partitioned aligned" part has me confused.:unsure:
There are a couple of gotchas to be aware of. Switching in and switching out partitions can be very fast, but an exclusive lock—...
November 25, 2015 at 1:55 pm
I thought that since I was partition by BeginDate I had to include that in the Clustered Index?
November 25, 2015 at 1:09 pm
Viewing 15 posts - 361 through 375 (of 3,738 total)