Viewing 15 posts - 616 through 630 (of 8,760 total)
Can you please elaborate further on this? What are you trying to do? What is the source type of the .db file etc.
😎
SSMS does not host any databases or database...
April 21, 2019 at 9:31 am
Can you please post the execution plans for both queries?
😎
April 21, 2019 at 6:51 am
Good point Erland, fn_varbintohexstr is to be avoided!
😎
April 18, 2019 at 10:37 am
Quick update, this is the most efficient code I've come up with so far, beats the bashes out of anything I've seen so far
😎
DECLARE @STRING01 ...
April 17, 2019 at 3:27 pm
It doesn't but there are a few TSQL equivalents around. I've written a Levenshtein workalike which is quite fast, but I'm having some trouble finding it! Edit -...
April 11, 2019 at 1:58 pm
Quick thought, the best way would be to inline the function's code in the query. This would enable the server to use a parallel execution plan and also remove the...
April 11, 2019 at 7:53 am
Steve Jones - SSC Editor wrote:Well, with the new leaderboard (https://www.sqlservercentral.com/contributors), we have our first millionaire.
Yay. Um, so what are those points redeemable for again? 🙂
Not on the list so...
April 8, 2019 at 4:13 pm
Authorization on the schema will still bring it into view
😎
Currently there are 14 different versions of the sproc, here is the one inherited from sybase
ALTER procedure [sys].[sp_columns]
(
...
April 8, 2019 at 4:05 pm
The correct answer is not one of the options!
😎
Hint: Multiple tables with the same name, each in a different schema
April 6, 2019 at 10:38 am
Another example of an SSC link not working appears in today’s articles (https://www.sqlservercentral.com/articles/reaping-the-benefits-of-the-window-functions-in-t-sql-2). The link at the bottom of that article for DelimitedSplit8K...
April 2, 2019 at 3:08 pm
Another example of an SSC link not working appears in today’s articles (https://www.sqlservercentral.com/articles/reaping-the-benefits-of-the-window-functions-in-t-sql-2). The link at the bottom of that article for DelimitedSplit8K results in the “Oops”...
April 2, 2019 at 3:06 pm
April 1, 2019 at 4:46 pm
@happygeek QotD should be behaving itself now, there was some over-eager caching in place.
Hi Dave, have you looked into the links I posted earlier? Still not working!
😎
April 1, 2019 at 4:44 pm
Viewing 15 posts - 616 through 630 (of 8,760 total)