Viewing 15 posts - 316 through 330 (of 506 total)
Make the max memory setting low enough to allow other required system operations. I'd recommend at least 4GB reserved depending on what services are running other that SQL Server.
December 27, 2017 at 12:01 pm
This is more of a Windows Server question. You'll get better results posting to a Windows Server Forum. Maybe these links will help.
Configure certificate auto-enrollment
December 27, 2017 at 11:58 am
@Drew,
It depends on the server and clients.
@vsamantha35
Try creating this index:
CREATE INDEX IXLubeAnalyst__Sample__DateDrawn_EquipmentLife_LubricantLife_DateRegistered_SampleID
ON...
December 21, 2017 at 2:36 pm
December 21, 2017 at 2:09 pm
It sounds like you're credentials aren't being forwarded correctly. Often tis can be resolved by creating an SPN for the server for the account SQL Server is running...
December 20, 2017 at 6:25 pm
WITH
emp
(
EID,
Stat,
StartDate,
EndDate
)
AS
(SELECT 12345, 'A', '20111215', '20120101' UNION ALL
SELECT 12345,...
December 20, 2017 at 1:21 pm
Look at ORDER BY with OFFSET FETCH
December 20, 2017 at 11:42 am
Can't you compare the file to the exception file to find the rows. In my experience truncation errors may be thrown when the flat file connection manager has the column...
December 19, 2017 at 4:59 pm
The best way to facilitate that would be to store the segments in separate columns.
December 19, 2017 at 3:58 pm
The issue with all at once large data loads is log file growth. the best way to deal with that is to chunk out the load into small sets with...
December 19, 2017 at 2:51 pm
December 19, 2017 at 9:32 am
Please post a create table script, inserts with sample data, what you've tried, any errors and expected output based on sample data provided.
December 14, 2017 at 1:23 pm
Viewing 15 posts - 316 through 330 (of 506 total)