Viewing 15 posts - 2,911 through 2,925 (of 7,609 total)
Would have to see the query plan to be sure, but it seems like SQL may be doing an implicit conversion on the date column, which would cause big performance...
March 7, 2019 at 10:33 am
Which is better?
[code...
March 7, 2019 at 8:29 am
It seems like maybe something is blocking the "slow" run, although I'm not sure what it would be.
March 6, 2019 at 12:33 pm
You don't need to do an explicit transaction. Once you put the level into effect, it will stay in effect until/unless you explicitly change/override it.
SET TRANSACTION ISOLATION LEVEL...
March 6, 2019 at 12:30 pm
Divide it by 1000, to add seconds, so it seems based on the value returned:
SELECT DATEADD(SECOND, (1551279347054/1000), '19700101')
If you need to keep the milliseconds, you can...
March 6, 2019 at 12:26 pm
Did you look at / compare the query plans?
March 5, 2019 at 12:56 pm
The estimated plan will be the actual plan. What's missing from the estimated plan is the actual row counts; in an estimated plan, naturally the query didn't actually run, so...
March 5, 2019 at 10:52 am
Certain SQL settings being different can cause a separate execution plan to be required. For example, QUOTED_IDENTIFIER ON vs QUOTED_IDENTIFIER OFF would definitely cause that. Try explicitly setting all of...
March 5, 2019 at 7:28 am
If you want to start over on the design, then start over on the logical design process. The existing table has no relevance to that process.
Lay out the...
March 4, 2019 at 10:17 am
March 4, 2019 at 9:32 am
INSERT INTO [dbo.Distinct_Login] (
[Today], [DatabaseName], [lOGIN_TIME], [HOSTNAME],
[CMD], [NT_USERNAME], [LOGINAME]
)
select
GETDATE() AS today, DB_NAME(dbid) AS DatabaseName, LOGIN_TIME, HOSTNAME,
March 1, 2019 at 11:16 am
Or have SSIS convert that value to a different date. Typically 1900-01-01 is used (date 0 in SQL) for that, unless you have actual data that goes back that far,...
March 1, 2019 at 10:32 am
That's an odd requirement. The same login could have several different processes active on SQL at the same time. How do you want to determine which single one to list? ...
March 1, 2019 at 10:30 am
Something like this instead:
delete from C
from ods_tmus4.dbo.lgtc_shipmentsclaims_cpy C
where exists (
select *
from [Admin].[dbo].[Remove Duplicates_Final] D
Where D.[Tracking_Number] =...
February 27, 2019 at 11:16 am
Viewing 15 posts - 2,911 through 2,925 (of 7,609 total)