Viewing 15 posts - 1,156 through 1,170 (of 26,490 total)
August 13, 2018 at 9:50 am
Why not post the DDL (CREATE TABLE statement) for the tables, some sample date (not production data) for the tables as INSERT INTO statements, and the code you are running...
August 13, 2018 at 7:56 am
August 13, 2018 at 7:03 am
August 10, 2018 at 11:31 am
When restoring using a full backup and a differential backup you only need the latest differential backup if you are restoring the latest database.
August 10, 2018 at 11:22 am
Yes, i can made the comparisons but the problem is to delete oldest...
August 10, 2018 at 10:49 am
August 10, 2018 at 9:29 am
I have created a workaround:
...
if month(getdate()) = '9'
delete FROM dbo.CounterData WHERE CounterDateTime like '%-07-%'
go
August 10, 2018 at 9:26 am
August 10, 2018 at 9:24 am
August 10, 2018 at 8:56 am
Viewing 15 posts - 1,156 through 1,170 (of 26,490 total)