Viewing 15 posts - 391 through 405 (of 8,754 total)
The dumb thing is not asking the question.
The second dumb thing (not applicable here!) is not listening to the answers given by seasoned pros, because you don't like what...
November 17, 2020 at 8:15 pm
on this forum, as far as I'm concerned, there is no such thing as a dumb question!
😎
The dumb thing is not asking the question.
For fun, here is a Haiku answer
You...
November 17, 2020 at 6:03 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...
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
Viewing 15 posts - 391 through 405 (of 8,754 total)