Viewing 15 posts - 1,261 through 1,275 (of 49,562 total)
June 15, 2017 at 4:00 am
June 15, 2017 at 3:33 am
June 15, 2017 at 3:05 am
Is it getting blocked by other queries on production?
June 15, 2017 at 2:54 am
While I know there are mistakes in my documentation that I don't know about, I've...
June 14, 2017 at 2:11 pm
None really.
You have to restart the instance for the ALTER DATABASE to take effect and actually move the files, so whether you do that as a failover and...
June 14, 2017 at 2:06 pm
Use TRY ... CATCH blocks, not the old SQL 2000-style error handling.
If that's the only code that you have and you only ever run it once, there will...
June 14, 2017 at 1:42 pm
That's not a deadlock at all. That's an uncommitted transaction and SSMS warning you that you should have committed the transaction before closing the window.
To get that, the COMMIT...
June 14, 2017 at 12:03 pm
Are you using filestream?
Are you seeing lots of page splits?
Are you seeing these when inserting or updating LOB data types?
June 14, 2017 at 6:47 am
I wouldn't worry about the latter, it's considered a benign wait.
Are you seeing the MEMORY ALLOCATION EXT wait frequently on user sessions? Sessions that are actually running queries...
June 14, 2017 at 6:35 am
Are you getting it significantly? All the time, or just occasionally
June 14, 2017 at 6:11 am
June 14, 2017 at 6:04 am
Grant Fritchey - Wednesday, June 14, 2017 5:43 AMIt's an 8gb server .
My laptop has twice the memory as that production server....
June 14, 2017 at 5:50 am
Backup?
Are you using a VM on Azure, or Azure SQLDB (the PaaS offering)?
The DMVs are not included in backups, they're dynamic views, views into the server's...
June 14, 2017 at 5:38 am
Viewing 15 posts - 1,261 through 1,275 (of 49,562 total)