Viewing 15 posts - 451 through 465 (of 2,356 total)
WHERE datecolumn >= dateadd(month,-1,convert(date,getdate())) and datecolumn < convert(date,getdate())
Which would get you the data for this date range, assuming you ran this on 2022-03-01.
2022-02-01 00:00:00.000 to 2022-02-28 23:59:59.997
This code will...
March 7, 2022 at 4:39 pm
I think the following error line from those that you provided is the key hint as to what is wrong...
Error 0xc02020c5: Data Flow Task 1: Data conversion failed...
March 7, 2022 at 4:31 pm
If you search for that error, you can see that one of the things said in the documentation is that it can safely be ignored. All it means is that...
March 7, 2022 at 4:25 pm
Help me understand this scenario... I'm trying to TEST a fix for Implicit conversion on a single update... sample 1 would be doing a int to nvarchar(255) sample 2...
March 4, 2022 at 7:09 pm
Today, our DBAs approached me about moving only SSRS to the clustered servers, for network performance reasons. They understand that with SQL Standard it is not cluster aware, and...
March 4, 2022 at 4:37 pm
I appreciate the feedback.
One reason I've used index rebuilds in the past is because some of the third-party apps we rely on can sometimes end up with a query...
March 3, 2022 at 7:52 pm
If you have SSRS running, I have created SSRS reports that execute procs for the help desk.
March 3, 2022 at 6:15 pm
Because there are parts and pieces from all of those versions packaged with SQL 2016. Regardless if the install clicked "next, next, next", these folders and files would still be...
March 3, 2022 at 6:12 pm
Don't cluster MSDTC. Configure MSDTC separately on each server.
March 3, 2022 at 4:46 pm
When you run this query
select mails from dbo.mails where job = 'X'
Is the value of "mails" the proper list of recipients? Does it contain the corpse email? If so, modify...
March 3, 2022 at 2:57 pm
It looks like the login did have the permissions it needed, and that the issue was related to the T-SQL I was trying to use to rebuild the indexes.
Michael,...
March 2, 2022 at 9:10 pm
You do not create a login, you create a user in the database.
CREATE USER [YourUser] FROM EXTERNAL PROVIDER;
And, even as an admin, there are only 3 folders with an Azure...
March 2, 2022 at 6:14 pm
I would probably not bother to rebuild indexes, I would suggest updating statistics.
I've set up a Runbook and execute stored procedures that are in place in all of the databases...
March 2, 2022 at 6:08 pm
Index and stats are current...
How do you know this? Can you describe your process for maintenance?
MAXDOP, cost threshold -- Default
There are a lot of articles and advice related...
March 2, 2022 at 6:01 pm
They did throw is at me... what Indexes could be applied to help..
They did throw hardware at it.. which is the wrong approach.. and it only slightly improved overall...
March 2, 2022 at 4:45 pm
Viewing 15 posts - 451 through 465 (of 2,356 total)