Viewing 15 posts - 1,981 through 1,995 (of 2,645 total)
We have a database about 500 GB , we thought of splitting the data...
November 18, 2018 at 7:28 am
November 18, 2018 at 3:46 am
November 17, 2018 at 10:43 am
CREATE PROCEDURE [dbo].[sp_calc_MedRec] AS
BEGIN
SET NOCOUNT ON;
INSERT INTO tblMeasureCount
SELECT 135, -- measureId
'Medication Reconciliation...
November 17, 2018 at 8:12 am
November 16, 2018 at 10:33 am
November 16, 2018 at 6:34 am
November 16, 2018 at 6:14 am
November 16, 2018 at 5:47 am
If you are deleting from a table based on a query joining several tables then some if the indexes will help performance. So you shouldn't be disabling all non-clustered indexes.
November 16, 2018 at 4:31 am
November 15, 2018 at 6:14 pm
Something like this might work:USE [DW_test]
GO
/****** Object: Trigger [dbo].[AuditTrigger] Script Date: 11/15/2018 11:56:07 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER...
November 15, 2018 at 3:43 pm
November 15, 2018 at 12:39 pm
I know what are the isolation levels, and the differences between them. I was...
November 15, 2018 at 10:01 am
Viewing 15 posts - 1,981 through 1,995 (of 2,645 total)