Viewing 15 posts - 136 through 150 (of 309 total)
Gazareth (12/12/2014)
Which version & edition are you running? Backup compression on standard...
December 12, 2014 at 10:38 am
John Mitchell-245523 (12/12/2014)
What sort of data is in the database? If it's mainly text, the backup will compress well. If it's mainly LOB data, it won't.John
Well It's mostly...
December 12, 2014 at 10:13 am
I am still hoping to get some answers from somebody who has experienced and dealt with these kinds of issue before.....
October 31, 2014 at 11:47 am
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...
October 7, 2014 at 2:37 pm
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...
October 7, 2014 at 11:16 am
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...
October 7, 2014 at 11:08 am
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....
October 7, 2014 at 11:00 am
ScottPletcher (10/7/2014)
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...
October 7, 2014 at 10:50 am
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 index on Company...
October 7, 2014 at 10:36 am
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 table scan, locking...
October 6, 2014 at 4:22 pm
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
October 6, 2014 at 3:48 pm
Eirikur Eiriksson (9/25/2014)
Quick questions, have you any checks on long running transactions? Any changes or new implementations? Why is autogrowth set to 10%?😎
We usually have a job which runs twice...
September 25, 2014 at 4:16 pm
Steve Jones - SSC Editor (9/25/2014)Something created lots of log records, so you'd have to find a lot of data changes or inserts. (or maintenance).
Check for those things
How do I...
September 25, 2014 at 3:11 pm
ErrLog (9/22/2014)Do you use Remedy? - ARsystem - lol :).
Yes
September 22, 2014 at 10:20 am
Please see the attachment. Like I said, I didn't start any trace nor did I schedule any trace job.
September 22, 2014 at 10:08 am
Viewing 15 posts - 136 through 150 (of 309 total)