Viewing 7 posts - 1 through 7 (of 7 total)
August 2, 2018 at 9:47 am
I like your article, but I would recommend changing how you filter your dates. Using the MONTH and YEAR functions can cause SQL to ignore any indexes...
August 2, 2018 at 5:57 am
I have no idea (maybe someone else here does) but your last 400 million rows would put your DID into negative numbers - assuming it is not an unsigned int....
May 22, 2013 at 1:49 pm
This is a little off topic, but we now include a simple quiz with all of our job posts. Something like: "Here's a list of people, a list of...
April 18, 2013 at 7:17 am
I Love the SIGN function...
CASE WHEN fsq.SalesAmountQuota > frs.SalesAmount
THEN 1 ELSE CASE WHEN fsq.SalesAmountQuota = frs.SalesAmount
THEN 0 ELSE -1 END
END as Trend
Can be replaced with:
SIGN(fsq.SalesAmountQuota - frs.SalesAmount)...
March 25, 2013 at 3:54 pm
Check out http://msdn.microsoft.com/en-us/library/windows/desktop/ms710963(v=vs.85).aspx
In your code:
retcode = SQLBindParameter(hStmtHandle,
I think the 2nd parameter should be 2 and not output_blobs_.cur_pos, because...
March 6, 2013 at 7:16 am
Looking at Thomas' select statement made me think of one of my favorite functions, that (IMHO) doesn't get enough use: SIGN
Now, this only works here because there are no...
March 5, 2013 at 8:57 am