Viewing 15 posts - 8,236 through 8,250 (of 59,078 total)
Regardless of which method you plan on, if you intend to audit every data change even in "just" user databases, you should immediately at least double the disk space and...
December 2, 2019 at 3:05 pm
I'd create a morning report for all jobs. It's not difficult to do and will teach you a lot about the tables in MSDB. I render the report in T-SQL...
December 2, 2019 at 3:00 pm
Now, all those in the room that have actually used this function in production, please raise your hand! 😀
December 2, 2019 at 2:58 pm
BEFORE YOU DELETE ANYTHING, MAKE SURE THAT YOUR BACKUPS ARE WORKING CORRECTLY AND THAT YOU CAN RESTORE TO A POINT IN TIME!!!!!
December 2, 2019 at 2:53 pm
Whether running in a VM on Azure, AWS, or locally, a VM is just a VM. You're responsible for your database backups the same way across all of them....
December 2, 2019 at 2:03 pm
I'd also get out of the habit of having discrete logins even if they're Active Directory logins. Use Active Directory Groups instead. Of course, the exception (there's almost...
December 2, 2019 at 1:58 pm
Many thanks Jeff. This has become a repeated problem. App team says there is nothing wrong from the application. Blame games gets started for 1 day and eventually they...
December 2, 2019 at 6:10 am
So there won't be true consistent last login then? I will need to be able to identify haven't logged in for over 120 days however, our servers are rebooted...
December 2, 2019 at 1:05 am
Hi Experts,
Seeking for inputs on High cpu scenario.
App team has started running workload at that time and they back saying DB is slow. Seeing 100% CPU on one of...
December 1, 2019 at 4:05 pm
It didn't work
Thx
sam
First of all, that's an Oracle error. Oracle and SQL Server haven a whole lot of differences. PL/SQL <> T-SQL. Let's hope that whoever...
December 1, 2019 at 3:02 pm
PLEASE don't duplicate posts. All does is split up the answers others make.
Please, no more answers on this thread folks. Instead, post them on the following thread.
https://www.sqlservercentral.com/forums/topic/master-and-detail-table
December 1, 2019 at 2:52 pm
i have an application that creates sql tables that ends pat xxxxx_bulk and i must automated the synchronization process
Synchronization process? Why wouldn't "replication" work for you?
I've also found the...
December 1, 2019 at 2:48 pm
>> IDENTITY() is a piece of automation that solves a set of tricky problems for you. <<
Actually, IDENTITY creates problems rather than solve them. Essentially, you've decided to throw...
November 30, 2019 at 9:11 pm
While I agree that there have been some pretty cool successful attempts at making things "better" which, as you say, means "go faster", in this case, all is not without...
November 30, 2019 at 8:55 pm
Viewing 15 posts - 8,236 through 8,250 (of 59,078 total)