Viewing 15 posts - 1,891 through 1,905 (of 39,720 total)
I'm not quite sure what you mean, but with your questions.
June 14, 2021 at 7:18 pm
https://stackoverflow.com/questions/18996157/what-does-lock-communication-buffer-resources-mean
These might help. A new one to me as well.
June 14, 2021 at 7:15 pm
If you are asking if the CAST can be part of an insert, it can.
June 14, 2021 at 7:14 pm
A few things noted above, but also query store can help here, and force a particular plan for a query.
June 14, 2021 at 7:13 pm
I've queried Microsoft, but it looks like encryption is set by protocol, not IP. So while you might be able to force encryption for IP connections from anywhere, which likely...
June 14, 2021 at 7:11 pm
You should have a deployment script (s) of some sort to do this. Something like FlywayDB would make this easy: https://flywaydb.org/
Disclosure: I work for Redgate Software.
June 14, 2021 at 7:06 pm
Xevents looking for this will also help. That is non-intrusive to your system.
June 14, 2021 at 7:05 pm
There are also community scripts you can look at: https://www.sqlservercentral.com/search/failed+job/section/scripts
June 14, 2021 at 7:04 pm
You can also use Substring() to return a part of the string only.
June 14, 2021 at 7:03 pm
Nice, Bill. Some great pictures in there of nature. I'm going to be following.
June 10, 2021 at 10:54 pm
I'll try to search those out, but not sure. The threading in here isn't really a place to run a project or post the code. The GH repo is much...
June 10, 2021 at 5:26 pm
I think this has been true most of the time, but I am starting to see some companies build parallel tracks to keep advancing tech people without them going into...
June 10, 2021 at 2:55 pm
I agree. While I was looking around, I was thinking about putting in another example there.
June 10, 2021 at 1:57 pm
I don't think that CONTAINSTABLE allows a "NOT NEAR" to be used. At least, the docs on NEAR don't seem to show this.
I think a subquery that finds rows...
June 9, 2021 at 4:41 pm
I don't believe the linked server can access the key. Architecturally, this works by the decryption happening in your driver, on your machine, not on the server. The linked server,...
June 9, 2021 at 4:15 pm
Viewing 15 posts - 1,891 through 1,905 (of 39,720 total)