Viewing 15 posts - 391 through 405 (of 8,760 total)
It's not worth that risk for such a tiny gain.
In a single execution, the gain may be small, bring it up to 100K/Sec and that difference...
November 17, 2020 at 5:33 pm
It's not worth that risk for such a tiny gain.
In a single execution, the gain may be small, bring it up to 100K/Sec and that difference can kill any...
November 17, 2020 at 4:35 pm
Just a quick thought: Any IF statement will add an evaluation step to the execution Any AND will do the same Conditionals (IFs) introduce branching, even if there...
November 17, 2020 at 4:28 pm
Just a quick thought:
Any IF statement will add an evaluation step to the execution
Any AND will do the same
Conditionals (IFs) introduce branching, even if there is only one path.
😎
Suggest you...
November 17, 2020 at 3:12 pm
I realized the SSMS settings affecting the results as soon as I posted, got a fresh install on this laptop ("Vanilla") SQL Server Management Studio 15.0.18338.0
😎
The SQL Server...
November 4, 2020 at 9:22 am
He he, just changed the settings to 1000000 and still getting 65,536 characters returned
😎
November 3, 2020 at 7:56 pm
On SQL 2019, the results are 8000 and 65536 characters respectfully, starting to sound like some presidential election....
What patch level are you using? I am testing your code...
November 3, 2020 at 7:51 pm
Just adding a little twist to the "shaky at the best" UTF-8 bodged support
😎
USE TEEST;
GO
SET NOCOUNT ON;
GO
CREATE TABLE dbo.Test (S varchar(10) COLLATE Latin1_General_100_CI_AI_SC_UTF8);
INSERT INTO dbo.Test (S)
VALUES(N'?');
SELECT LEN(REPLICATE(CONVERT(VARCHAR(MAX),S,0),100000))...
November 3, 2020 at 7:00 pm
Scrape the connection logs, will at least give an idea what linked services are connecting within the log retention period.
😎
November 3, 2020 at 5:36 pm
He he, look what the cat dragged in!
😎
More than two years on and it's still interesting? Feels like eating last week's take out pizza.
October 17, 2020 at 4:04 pm
Grant ,
I can see now where Cursor is not needed rather use a simple select statement with insert records into the table variable.
Grant, thank you. I will rewrite the...
October 9, 2020 at 12:03 pm
Yes, the free Log space is within the allocation of the log file(s).
😎
Obviously, you should monitor the free space within the files and turn off any autogrowth for the files.
October 9, 2020 at 11:52 am
Excel does have a row limit of 1048576 per tab, of course one can either use multiple tabs or even better, the tabular power query, which does not have any...
October 8, 2020 at 3:13 pm
Typical WYPIWYG, what you pay is what you get.
😎
The number of rows limitation just tells us that someone is using an old version of Excel,...
October 7, 2020 at 6:54 pm
Even if the format is NOT fixed, you can use the Tally Table-based string splitter function from this very site (authored by Jeff Moden in an Article with a...
October 7, 2020 at 6:39 pm
Viewing 15 posts - 391 through 405 (of 8,760 total)