Why not simply query the Netezza system tables for the existence of said table? Set the integer to 1 if it is there and 0 if not.

Very good article.

In practice, have you checked the accuracy against other geocoding techniques? I'm curious with users who do not posess static IP addresses whether IP resolves to the...

Let's do the math...

Boss says "All Hands On-Deck"

plus

"I'm too drunk"

equals

UNEMPLOYED

...sad but that is how the implied employment contract works in today's economy.

That's It!!! Lock 'Em Down and...

I'm curious after reading this thread...why would you assign a random number via RAND() to a varchar instead of simply using one of the numeric data types available? If...

I like the concept of using a guid as a pseudo random number. Very novel approach!!!

I've always used auxillary tables in tempdb combined with forward-only cursors to assign unique,...

This is one of the best nuts and bolts articles I've come across in SSAS.

Question for the Group:

Is there a "test" dataset available for creating an SSAS Dimensional Database? ...

Guess I'm just not a good programmer.

Sorry Steve I don't measure up.:crying:

Point of Order: Those who created the credit default swap catastrophe using these types of methods were experts. Having an expert consultant is no substitute to understanding at least the...

SSAS is completely capable of handling forecasting tasks utilizing a variety of different econometric algorithms.

I would STRONGLY urge readers to consult with a professional statistician or economist before undertaking this...

I am aware that SSAS has full blown Econometrics built into the SSAS package capable of performing more than just neural nets...we're talking a full slate of linear regression/non-linear regression/discrete...

Words of wisdom Steve.

A couple thoughts I had on why things are done in certain ways.

1. Often people are asked to do tasks that they may not have a...

You won't get much Nigerian Bank messages on LinkedIn.

The groups you can join often have nuggets of good information and they provide the means for contacting people in companies you...

There are several reasons to network.

1) You never know when your current employer is going to flake on you. The current economic climate has turned corporate America upside...

I apply this technique to run very sophisticated database update processes on the systems I manage. In my case, we run a combination of SQLCMD and BCP to execute...