Viewing 15 posts - 1 through 15 (of 208 total)
In firefox too. Well, at least the main point is readable: the example script.
September 29, 2023 at 6:36 am
yours isn't the first post where On-prem performance blew the doors off of cloud performance in similar tests
Not even a slightest idea why would it produce execution stats like...
September 24, 2023 at 10:19 am
Thank you for your reply. The list of indexes is the same, they're supposed to be the same, but I can't check it directly. Indexes and statistics were rebuilt and...
September 23, 2023 at 12:39 am
context_info is session global variable, so any object could have its own use, can modify it, etc. Besides that, you have to set it at the beginning and reset it...
August 31, 2023 at 11:41 am
Agreed. Criticism is for you and readers to learn something, don't let it discourage you from publishing more great articles. Comments mean that readers got interested, better than no feedback...
March 29, 2023 at 12:34 pm
You might be mixing apple and oranges. Presented case is not "passing parameters", but using a configurable global variable.
A good use case for a view, but very bad for a...
March 27, 2023 at 2:57 pm
Even the best protocol can be poised with poor practices.
March 2, 2022 at 12:14 pm
The problem with this solution is that the UDF assumes the same order of rows as the substrings in the input string, while the documentation for string_split says the order...
March 2, 2020 at 8:18 am
The deployment worked, but there wasn't data in the column that had been dropped, and added back. Why not, asked the developer?
IMHO, that kind of person can't...
August 30, 2017 at 12:01 pm
This works with sql server 2008 too.
create table #dates
(
RecordId int primary key clustered
,RecordDate datetime
);
insert #dates
...
April 24, 2015 at 4:18 am
Paul Hernández (4/22/2015)
Please forget my first post, I copied and pasted the query that SSAS issues, therefore contains this weird aliasing.
Here is a better...
April 24, 2015 at 3:10 am
Good article. It highlights the most common mistake made in triggers by developers coming to sql server from other databases which usually have row level triggers.
However, the example is strange....
March 18, 2015 at 4:09 am
Toreador (3/6/2015)
chgn01 (3/5/2015)
March 6, 2015 at 5:29 am
What's wrong with output to a file/device/pipe?
It was a common practice in the age of dos.
It's still a common practice on unix systems.
Most modern windows users have the black-textmode-window-fobia....
November 14, 2014 at 5:26 am
Should be in humor category. 🙂 It says "select 5", 6th is so amusing that the correct answer is obvious even if you know nothing about the answers.
September 25, 2014 at 8:37 am
Viewing 15 posts - 1 through 15 (of 208 total)