Viewing 15 posts - 5,731 through 5,745 (of 7,616 total)
Hmm, I read it as going to varchar to nvarchar.
That is tricky, if any code uses local variables of type "varchar" to hold those columns. Given the implicit conversion...
October 7, 2014 at 3:50 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...
October 7, 2014 at 2:57 pm
Luis Cazares (10/7/2014)
ScottPletcher (10/7/2014)
For consistency, I'd stick with just explicitly CASTing the second value to an int:
SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS int)
I agree with you, but you missed...
October 7, 2014 at 11:39 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...
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)
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!...
October 7, 2014 at 11:14 am
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...
October 7, 2014 at 11:05 am
For consistency, I'd stick with just explicitly CASTing the second value to an int:
SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS int)
October 7, 2014 at 11:01 am
USE [DBName]
GO
CREATE CLUSTERED INDEX [Company_FormName] ON [dbo].[COLUMN_NEXT_ID]
(
[Company], [Form_Name]
)WITH ( FILLFACTOR = 100 ) ON [PRIMARY]
October 7, 2014 at 10:57 am
The db must be SQL 2000, or in SQL 2000 compatibility mode (80).
Yikes and gadzooks! You need to move it forward to at least 2005 as fast you can,...
October 7, 2014 at 10:55 am
New Born DBA (10/7/2014)
ScottPletcher (10/6/2014)
The index I suggested was on Company and Form_Name.
Do you think I should test it out in Dev and QA first before I add a clustered...
October 7, 2014 at 10:37 am
New Born DBA (10/6/2014)
ScottPletcher (10/6/2014)
New Born DBA (10/6/2014)
ScottPletcher (10/6/2014)
Add a clustered index to the "COLUMN_NEXT_ID" table on "Company" and "Form_Name".And how creating an index will help?:-D
It will avoid a full...
October 6, 2014 at 4:29 pm
New Born DBA (10/6/2014)
ScottPletcher (10/6/2014)
Add a clustered index to the "COLUMN_NEXT_ID" table on "Company" and "Form_Name".And how creating an index will help?:-D
It will avoid a full table scan, locking as...
October 6, 2014 at 4:06 pm
Suggested query below. If you're willing to add a nonclustered index, you can try the affect of adding the index below before running the query. I can't tell...
October 6, 2014 at 4:02 pm
Add a clustered index to the "COLUMN_NEXT_ID" table on "Company" and "Form_Name".
October 6, 2014 at 3:17 pm
Code below appears to confirm that. Although I did notice that if you added "TOP (100)", it became a KEYSET cursor, even w/o you explicitly indicating that.
DECLARE csr1 CURSOR...
October 3, 2014 at 10:28 am
Viewing 15 posts - 5,731 through 5,745 (of 7,616 total)