Viewing 15 posts - 511 through 525 (of 2,905 total)
I would take Jeff's advice here. Plus, the question about if logical or physical reads are more important to performance tuning can be found by doing a google for "performance...
September 20, 2023 at 2:12 pm
Apart from the advice above, I'd check all of the disks and any place that the backup file sat for any period of time to make sure that you aren't...
September 19, 2023 at 10:07 pm
I think the easiest way to do it would be to script out all of the stored procedures that do cross-database communication, drop them, generate the bacpacs, import the bacpacs,...
September 18, 2023 at 4:28 pm
That is a bit scary and odd... have you reported this to MS? If they are aware of it and it is a limitation of the function, they should document...
September 18, 2023 at 3:59 pm
Did it work better when run outside of Visual Studio?
September 14, 2023 at 8:09 pm
I think this depends on the P2V tools and VM host. But this is more of a server question than a SQL question. My advice would have been to not...
September 14, 2023 at 7:01 pm
First step is to review the error message. Without seeing the EXACT error message (and any associated errors) it is hard to say what the problem is. If I had...
September 14, 2023 at 6:55 pm
To add to what Jeff said, DBA in the cloud is a VERY similar skill set to DBA on premise. On the back end, it is all the same thing...
September 12, 2023 at 9:08 pm
Step 1 - check the docs:
things to note:
ODBC data sources are not supported for multidimensional solutions
AND if you want to connect to other databases, you need an "An OLE DB...
September 12, 2023 at 5:41 pm
I'm still thinking this is either:
A - expected behavior <-- that is there is an error message being sent in the email notification
B - bug in Visual Studio or SSDT...
September 12, 2023 at 5:29 pm
The ONLY reason I see to use powershell for a backup process would be if you needed to move the file to a location that the SQL agent service didn't...
September 11, 2023 at 8:14 pm
According to the MS docs, that shouldn't be happening. As a really random thought - is it possible that an error did occur, just not the way you were thinking?...
September 11, 2023 at 8:11 pm
As a random guess, does the SQL Agent Service account have access to the file you are trying to rename? If I had to guess I would say It is...
September 11, 2023 at 3:12 pm
My opinion, I would ask them to do basic troubleshooting to validate that the disk is good. Just because other systems are running fine now, doesn't mean they will continue...
September 11, 2023 at 3:07 pm
If I had to guess, I'd say that the transaction is not committing.
But my first steps when troubleshooting things like this are to check things like profiler or extended events...
September 8, 2023 at 7:36 pm
Viewing 15 posts - 511 through 525 (of 2,905 total)