Viewing 15 posts - 1 through 15 (of 24 total)
Azure Synapse has a 1TB minimum. If you are greenfield, then it will be much cheaper to go with an Azure Database in the meantime.
June 7, 2022 at 3:51 pm
The jobs I have held that I considered "dream" jobs were not about the work, but the atmosphere. I had to fill out one of those HR questionnaires evaluating the...
October 19, 2018 at 8:50 am
My favorite part of today's strip about compression is the "TILT!" on the screen. I wonder if the under 30 crowd gets it as a pinball reference. I...
April 15, 2015 at 5:55 am
I love open offices and low cubes. I love the comradeship of a team that can just turn around or stand up in order to brainstorm. But I...
April 12, 2013 at 6:45 am
Because there is a general revulsion for row by agonizing row,
a person could use a tally table and a values table rather than a while loop to accomplish the...
March 13, 2013 at 12:10 pm
pmcpherson (7/17/2012)
SQLBill (7/17/2012)
Tao Klerks (7/17/2012)
By using GetDate(), which returns a local time without timezone information, you're already doomed to fail at accurately converting between time zones:
The comment above (a snippet...
July 17, 2012 at 2:52 pm
SQLBill (7/17/2012)
Tao Klerks (7/17/2012)
By using GetDate(), which returns a local time without timezone information, you're already doomed to fail at accurately converting between time zones:
The comment above (a snippet of...
July 17, 2012 at 2:45 pm
Nobody has mentioned that to install SQL we had to install the .Net Framework and since 2005 we have had CLRs. We have several CLR/SQL functions here that make...
July 17, 2012 at 11:44 am
CELKO - your code does not compile. Looks like some logic is missing in the case statement.
I don't get " SELECT fact FROM Factrorials WHERE @f =...
October 19, 2011 at 3:16 pm
Don't you also need to make sure that @n <> @r so you don't divide by 0? And @r <> 0 either.
October 19, 2011 at 3:10 pm
Thank you Chad. I just got pulled in another direction while reading your reply. It might be a while before I can answer all those questions.
July 12, 2010 at 2:37 pm
I was wondering if you had control over the schema and could change it to have all the data broken out into different tables?
Doesn't every DBA/D want control over...
July 12, 2010 at 12:58 pm
Your solution is similar to mine with more joins than I believe to be efficient, but still effective.
I am also hoping someone else can provide a cleaner, simpler,...
July 12, 2010 at 11:12 am
Gianluca,
Your solution, while helpful, does not return the desired result set.
I think I see the confusion in my explanation of the problem.
The problem is to come up with all of...
July 9, 2010 at 1:43 pm
I'm not sure I understand all your requirements.
Why ID = 101 has 3 combinations? There are 4 fruits there...
I am not sure I understand your question. ID 101 should...
July 9, 2010 at 1:13 pm
Viewing 15 posts - 1 through 15 (of 24 total)