October 7, 2014 at 11:16 am
ScottPletcher (10/7/2014)
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
USE [DBName]
GO
CREATE CLUSTERED INDEX [Company_FormName] ON [dbo].[COLUMN_NEXT_ID]
(
[Company], [Form_Name]
)WITH ( FILLFACTOR = 100 ) ON [PRIMARY]
Now this is the warning I am getting:
Warning! The maximum key length is 900 bytes. The index 'Company_FormName' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Unless you actually ever plan to use really, really long names, you can ignore that.
Got it. So if I ever update the table with very long name which is let's say 1030bytes, it will fail but other than, I should be OK.
Yes, exactly.
Thanks you SO MUCH. I really appreciate that! 🙂
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 7, 2014 at 11:37 am
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
USE [DBName]
GO
CREATE CLUSTERED INDEX [Company_FormName] ON [dbo].[COLUMN_NEXT_ID]
(
[Company], [Form_Name]
)WITH ( FILLFACTOR = 100 ) ON [PRIMARY]
Now this is the warning I am getting:
Warning! The maximum key length is 900 bytes. The index 'Company_FormName' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Unless you actually ever plan to use really, really long names, you can ignore that.
Got it. So if I ever update the table with very long name which is let's say 1030bytes, it will fail but other than, I should be OK.
Yes, exactly.
Thanks you SO MUCH. I really appreciate that! 🙂
You're welcome!
Please let me know it actually helps.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
October 7, 2014 at 2:37 pm
ScottPletcher (10/7/2014)
You're welcome!
Please let me know it actually helps.
It's working just fine. Before creating the index on the table, deadlocks occurred every half an hour but now I haven't seen any in 3 hours.
.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 7, 2014 at 2:57 pm
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
You're welcome!
Please let me know [if] it actually helps.
It's working just fine. Before creating the index on the table, deadlocks occurred every half an hour but now I haven't seen any in 3 hours.
.
Awesome!!
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply