Viewing 15 posts - 136 through 150 (of 1,496 total)
Using a function on a column generally stops it being SARGABLE. (ie It will not be able to use any indexes.)
You should use:
AND CDHDR_NEW.OBJECTID LIKE...
April 16, 2024 at 1:30 pm
Using a function on a column generally stops it being SARGABLE. (ie It will not be able to use any indexes.)
You should use:
AND CDHDR_NEW.OBJECTID LIKE MM_EKKO_STAGING.EBELN +...
April 16, 2024 at 9:50 am
If you are looking at Blob Storage you might also like to consider Object Drift and Corruption. We were looking at something similar last year but it got abandoned for...
April 15, 2024 at 8:45 pm
I have resorted to setting the DATEFIRST in the SQL Agent job, but I still want to know WHY SQL agent and Query window behave differently.
Probably because the Agent...
April 15, 2024 at 1:54 pm
Try a space, not a -, between dd and hh.
April 9, 2024 at 6:36 pm
Thoughts?
Run!
Code first is great for rapid prototyping but it gets to the point where some traditional OO analysis and database schema design needs to be done.
April 9, 2024 at 3:17 pm
Baselining is a large topic so you might want to look at third party tools. This may get you started:
https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
https://www.sqlservercentral.com/articles/perfmon-using-sql-server-performance-counters
April 6, 2024 at 4:23 pm
Thanks Ant. I'll see if they have any older backups but I suspect that they won't.
To get a log backup there must have been at least one full backup...
April 4, 2024 at 4:45 pm
I can "rewind" to last Saturday on Database A with the current transaction logs though.
I would be interested to see how you do that. I suspect it would require...
April 4, 2024 at 10:54 am
I'm having to figure out how to in effect rewind a copy of the database back from now to last weekend
This is not possible. You will need a bak...
April 4, 2024 at 10:35 am
Denies a permission to a principal. Prevents that principal from inheriting the permission through its group or role memberships. DENY takes precedence over all permissions, except that DENY does...
March 26, 2024 at 3:46 pm
Maybe:
WITH Lags
AS
(
SELECT P.Code, X.DataPassaggio, P.idServizio, P.up
,LAG(idServizio) OVER (PARTITION BY P.Code, X.DataPassaggio ORDER BY P.DataPassaggio) AS...
March 26, 2024 at 3:21 pm
DDL? Test Data? You have enough points to know this.
March 26, 2024 at 1:27 pm
I have never used float for table definitions. I am not sure why the INTO command I used ended up with that data type.
You did some calculations...
March 14, 2024 at 8:42 pm
The query does math calculations
You should explicitly cast the results to the type you want - presumably not float.
March 14, 2024 at 11:57 am
Viewing 15 posts - 136 through 150 (of 1,496 total)