Viewing 15 posts - 196 through 210 (of 1,418 total)
how can a DBA can make other teams understand that query reading more data takes more time and a query reading less data will take less time to execute....
February 14, 2023 at 9:41 am
Polling is probably the best solution but you might also be able to Powershell (.Net) to start a SQL process with event tracing:
https://mcpmag.com/articles/2019/05/01/monitor-windows-folder-for-new-files.aspx
February 13, 2023 at 10:22 am
nor have I had a case of turning a table into a view. Not sure how that would come about.
We have a few old third party systems that use...
February 8, 2023 at 3:27 pm
tblNameOfTable
While not really a problem, it does look at bit odd when tblNameOfTable turns out to be a view.
February 8, 2023 at 2:12 pm
This was removed by the editor as SPAM
January 8, 2023 at 3:22 pm
to text file notepad
Start by looking at the output in a better editor like notepad++ or VS Code.
January 4, 2023 at 9:35 pm
In this case I cannot see anyway to predict when missing dates are needed (2017-11-16) or not needed (2017-11-19 & 2017-11-18).
This is a delayed message as I was...
December 29, 2022 at 10:58 pm
I do not think this type of problem is solvable with windowed functions as the result is dependent on previous values in the series. In this case I cannot see...
December 26, 2022 at 9:56 pm
running a vendor supplied application which couldn't run on a newer version. Still waiting on the vendor for 18 of those servers to supply the fix they promised in...
December 15, 2022 at 10:30 pm
The simplest approach would be to make the user the owner of the job and add them to the SQLAgentUserRole. Of course this will allow them to create, modify and...
December 15, 2022 at 10:56 am
The following suggests it is just another change in the default value:
You need to make sure you do not rely on the defaults for your connection. ie Explicitly set...
December 14, 2022 at 4:35 pm
As mentioned it is only a different default for the latest version of ADS. As I presume you do not use CA certificates on your servers it is easy enough...
December 13, 2022 at 5:26 pm
Noel Kennedy wrote:Do you really need a trigger here or can everything be done in the SP?
That I want to know.
Only you can say what else is likely to interact with...
December 13, 2022 at 10:46 am
Viewing 15 posts - 196 through 210 (of 1,418 total)