Viewing 15 posts - 361 through 375 (of 49,571 total)
Yup, I'll chip in with advice:
Ask the client to hunt and see if he has any backups from before he got hit with a ransomware attack, because that...
February 9, 2018 at 5:27 am
You want to filter for is_user_process = 1, as all the system processes appear as 'sa'
And querying sys.dm_exec_sessions isn't sufficient for auditing. Create an extended events session or...
February 7, 2018 at 6:15 am
No. They're completely unrelated features.
February 7, 2018 at 5:36 am
February 7, 2018 at 2:59 am
I strongly recommend that you use one procedure for one thing. No dynamic code. Or use an ORM for those drop downs
Yes, it's some up-front work, but it makes...
February 6, 2018 at 3:19 am
February 6, 2018 at 1:00 am
That's a discussion that needs to be had with the business users. It's business rules around what's valid and invalid data,
February 5, 2018 at 2:00 am
February 5, 2018 at 1:52 am
Either that object does not exist in the user's default schema or dbo, or the user does not have permission on that table. Please check which it is.
As...
February 5, 2018 at 12:11 am
The error's a 'file not found', so the obvious question is, is the file there?
Double-check that path please, because it doesn't look correct
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Galactic.mdf
February 5, 2018 at 12:03 am
patelmaulesh007 - Saturday, February 3, 2018 4:54 AMSELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'TreatmentFADT')
AND OBJECT_ID=OBJECT_ID('CommercialTeams')
Won't work on SQL 2000.
8...
February 3, 2018 at 5:24 am
Indexes don't slow down query performance though. And what exactly do you define as an 'incorrect' index?
Technically all indexes will slow down data changes (inserts), but that's usually...
February 2, 2018 at 6:09 am
February 2, 2018 at 12:49 am
Viewing 15 posts - 361 through 375 (of 49,571 total)