Viewing 15 posts - 16 through 30 (of 252 total)
We have one SQL 2005 server left. We can't upgrade it yet because it is the last version with the compatibility required by an old application. The application is being...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 13, 2017 at 10:09 am
Please, not another null or non-null debate. SQL Server has a clear implementation of NULL. The flat-nullers should just get over it. Far more important are domain...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
August 23, 2016 at 12:28 pm
ebouras (8/23/2016)
N_Muller (8/23/2016)
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
August 23, 2016 at 10:49 am
If you don't like the warning, it's often easy to update the query to explicitly replace the default behavior. To be honest, I have used this setting when I...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
August 23, 2016 at 10:23 am
Thanks. I've been collecting performance counters on several servers. The easy calculations like average, extreme, and deviation tend to wash out performance details. I want to get...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
June 7, 2016 at 10:30 am
PS Microsoft announced some good news the day before April 1st: Xamarin will be free for users of Visual Studio. It was not a joke. Now back to...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
April 4, 2016 at 9:53 am
One day a year, the joke is on them. The rest of the year, it is on us. When I saw Schrödinger's equation, I thought that Microsoft was...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
April 1, 2016 at 10:23 am
We had a SQL Server failover cluster for many years because we "wanted" it to be available at all times. We have many servers and the cluster turned out...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 28, 2016 at 9:55 am
Thanks. I tried to use maintenance plans sometime around SQL 2005. I remember writing T-SQL to manually edit the XML for a plan so that it could be...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 24, 2016 at 10:52 am
Zidar (3/11/2016)
BTW, solving 1X = 2X has X = 0 as a solution. There is no contradiction as it's also a solution of the original degenerate equation which is 0=0...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 11, 2016 at 10:30 am
roger.plowman (3/11/2016)
rstone (3/10/2016)
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 11, 2016 at 10:17 am
ZZartin (3/10/2016)
kenambrose (3/10/2016)
that question implies that you would otherwise have ~10000 "nullable" columns in your design?which would be nonsense design under any stretch of the imagination, wouldn't it?
If a solution...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 10, 2016 at 6:00 pm
BTW, solving 1X = 2X has X = 0 as a solution. There is no contradiction as it's also a solution of the original degenerate equation which is 0=0...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 10, 2016 at 3:32 pm
kenambrose (3/10/2016)
[[If you deal with a report and want all columns via left joins, then there will be nulls. ]]
We don't know...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 10, 2016 at 3:01 pm
In the logical design, the business logic might require handling missing data and reasons for missing data. Using tokens -2, -1 , 0, etc. is one way of handling nLvl...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
March 10, 2016 at 12:26 pm
Viewing 15 posts - 16 through 30 (of 252 total)