Viewing 15 posts - 1 through 15 (of 202 total)
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
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
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
From info you posted it appears you have a denormalized entity with property names and activity => no activity means no record in table, so right join to a calendar...
September 23, 2014 at 9:50 am
Writing tests (and documentation) is also a "simplicity test". If a feature can't be tested in a simple way, it's probably a good moment to rethink and redesign the...
August 25, 2014 at 3:43 am
September 4, 2013 at 4:04 am
There is no resultset. Procedure returns just an integer. There is a huge difference between no resultset and empty resultset. Since there was no such answer, all answers are wrong....
August 19, 2013 at 5:43 pm
Well, nice one.
To all those complaining about losing points... If you answer correctly, you just get the confirmation about your knowledge and are awarded with a point, if you fail,...
May 7, 2013 at 6:54 am
L' Eomot Inversé (4/30/2013)
May 7, 2013 at 5:23 am