Viewing 15 posts - 46 through 60 (of 851 total)
BJ,
Did you ever find anything along this lines? I too am looking at seeing what I can leverage, and the MDDE project isn't suitable (since it hasn't been updated...
January 15, 2012 at 2:48 pm
PaulB-TheOneAndOnly (11/22/2011)
T_VR (10/11/2011)
Do you create the fact first via ETL and then generate a...
November 22, 2011 at 11:29 pm
SQL Kiwi (11/14/2011)
I'm referring to the in-line variety of ordinary functions.
Oh, well sure, those I use. However, proliferating the schema with lots of little table-valued functions isn't always the...
November 14, 2011 at 11:21 pm
SQL Kiwi (11/14/2011)
Hey Bruce!
Hey Paul! 😀
I know I use them extensively, purely as a way of breaking my SQL code into more modular chunks, many of which are re-useable...
November 14, 2011 at 10:13 am
I'm not a huge fan of recursive scenarios, largely (I suspect) because I work with data warehousing and we tend to like flattening hierarchies. 😀
I do find it a...
November 14, 2011 at 2:48 am
I can heartily recommend The Microsoft Data Warehouse Toolkit by Joy Mundy for new starts (the second edition includes SQL Server 2008 R2.) And I agree that the RDBMS...
October 12, 2011 at 1:30 pm
Is there some reason you need to do comparisons as strings of characters? Serious question. SQL Server will quite happily compare binary values. If you convert to...
August 24, 2011 at 2:30 pm
Gail's indexing articles are really good, by the way. I've been using indexes for, er, decades (am I that old? Eeep!) and I still got something out of...
August 22, 2011 at 3:34 pm
You could also try recoding the coalesce() within the where. So if you have
WHERE A = coalesce(X, Y, Z)
You can recode this as:
WHERE
X is not...
August 22, 2011 at 3:31 pm
My suggestion would be to use varbinary(16). Convert the formatted strings (either in IP4 or IP6 format) into varbinary and go from there. IP6 addresses are 128 bits...
August 22, 2011 at 3:26 pm
Is there some reason it needs to be a procedure? Because this looks more like a function to me.
August 22, 2011 at 3:20 pm
I have a bachelor degree in computer science (some 20 years back) and various courses since then. What I have discovered is that most of my learning I have...
August 22, 2011 at 3:16 pm
MadTester (8/19/2011)
I have a feeling that Is_Identity is a subset of PK, so removing those joins may yield the same results.
It usually is, as we usually use an identity to...
August 19, 2011 at 2:08 pm
If you know there's a fixed depth to the recursion (and you can certainly place that in a prototype), then you can break the recursive bill of materials table into...
August 17, 2011 at 3:31 pm
GilaMonster (8/11/2011)
Hire someone.
I can't argue with that one. That doesn't mean you can't learn from or alongside the person you hire (we all have to start somewhere).
August 12, 2011 at 3:40 pm
Viewing 15 posts - 46 through 60 (of 851 total)