Viewing 15 posts - 676 through 690 (of 7,191 total)
Are you saying that after you attempt to start SQL Server Agent, no new SQLAGENT.OUT file is created? How are you changing the service account (through Services or in SSCM?)...
August 17, 2018 at 7:27 am
Yes, it's reasonable to expect a query to take longer to run when it runs against larger tables. Please see this article on how to post performance problems. ...
August 17, 2018 at 3:04 am
August 16, 2018 at 8:13 am
It is a little scary that a court, with no expertise in some...
August 16, 2018 at 8:08 am
wak_no1 - Thursday, August 16, 2018 4:58 AMYou mean in the IF statement?
Yes. At the moment, it will evaluate to true...
August 16, 2018 at 5:05 am
The problem appears to be that you're not using the @inserted table. (By the way, you don't need to insert that into a table, just use Inserted directly.)
But,...
August 16, 2018 at 4:50 am
Santosh
How many rows are being updated? Please post the actual (not estimated) execution plan.
John
August 16, 2018 at 4:29 am
What is your question?
Actually, I have a question. Why not just create a unique index on ACCOUNTID and COUPONID, filtered on PREVBALANCE = 4 AND BALANCE = -2...
August 16, 2018 at 4:25 am
I have created a workaround:
...
if month(getdate()) = '9'
delete FROM dbo.CounterData WHERE CounterDateTime like '%-07-%'
go
August 10, 2018 at 9:31 am
August 10, 2018 at 2:21 am
Jose
Yes, the more often you back up your log, the smaller the log file needs to be and the smaller your log backups will be. But there comes...
August 10, 2018 at 2:05 am
Have the first step of the second job test sysjobhistory, and if the first job failed, raise an error. Set the second job to fail if the first step fails.
August 9, 2018 at 9:47 am
Daniel
Well, if you deleted it all, then you're going to struggle to keep today's data! Seriously, though - if you deleted all data then it must mean that...
August 9, 2018 at 9:24 am
SELECT counterdatetime
FROM CounterData
WHERE TRY_CONVERT(datetime,counterdatetime) IS NULL
John
August 9, 2018 at 9:00 am
August 9, 2018 at 8:18 am
Viewing 15 posts - 676 through 690 (of 7,191 total)