Reputation
4,857
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 18 43
Impact
~479k people reached

2d
revised Routing data from one SQL Server to another
Added a description of how I used this in the real world
Sep
1
answered Routing data from one SQL Server to another
Aug
28
comment How to create Date table
What are the dates that are missing?
Aug
28
awarded  Nice Question
Aug
27
comment Is adding the join columns to a table a good practice to improve performance?
@veverke, please show an example of the tables with sample data. It will be more clear what you are asking. It is easier to manage with data when tables have single column primary keys, but it is not necessary.
Aug
27
comment Scramble the data output of a stored procedure
I order inside SQL when I need to, I am not against it. I do this when the "end app" is a report, or a batch process that I created. I worry though that applications taking the data will re-sort the data anyway.
Aug
27
comment Scramble the data output of a stored procedure
Shouldn't ordering of the data be handled at the application layer?
Aug
27
comment Join with comma separated values in SQL Server
Your predecessor saved some time with an idea that seemed good at the time, but now you are dealing the consequences. It is never too late to fix a problem, you just have to convince your bosses that is really is worth the effort.
Aug
27
comment Determining the specific command type in a DDL trigger
Can you elaborate what you mean by "the trigger will simply have one of the above 4 options as input?". Triggers fire based on activity in the database. You cannot pass input to them.
Aug
21
answered Alternative to WHERE clause
Aug
14
comment Normalization for postal addresses in US (address, county, city, state, zipcode)?
It is frustrating that a crown corporation (governement owned corporation mandated to deliver service and remain profitable) would treat publicly funded data (tax payers!) as their own. They are indeed suing those that distribute the data, as well those that use the words "postal code" o.canada.com/business/… Big companies licence the data. I have seen commercial packages go as high as $5000 + fees for monthly updates.
Aug
14
comment Normalization for postal addresses in US (address, county, city, state, zipcode)?
Acquiring and maintaining a list of official Zipcodes is expensive. The data is owned by the postal service (at least in Canada), and they aggressively pursue vendors who try to open source the data.
Aug
14
comment Normalization for postal addresses in US (address, county, city, state, zipcode)?
I would not restrict state, if dealing with more than 5 countries. I tried that, but when we moved past US, Mexico, Canada, NZ, Australia we found the list of states to be problematic. The main bulk of the addresses were imported from another system. Many places do not record state in their addresses.
Aug
13
answered Normalization for postal addresses in US (address, county, city, state, zipcode)?
Aug
13
comment Normalization for postal addresses in US (address, county, city, state, zipcode)?
Are you only planning on storing addresses for the US? There is no single standard for addresses. Some countries have provinces, some have states. Some have other structures entirely. Zipcode / Postalcode, etc.
Aug
11
comment Best approch to replicate data from one db to other db on same server
Instead of an anonymous downvote I think it would be more constructive to post why you disagree with my answer.
Aug
7
reviewed Approve Oracle - restore a single table
Aug
7
comment How to compare dates in SQL?
Are you able to change the date attribute to datetime? Storing dates as varchar is problematic. You will run into situations where data is stored that is not a valid date. You will also be continuously converting to and from datetime.
Aug
7
answered How to prevent redundant data that is hard to detect, e.g. John Smith
Aug
7
comment Best approch to replicate data from one db to other db on same server
Then you better be prepared to seriously fine tune your code, and beef up the hardware. To keep the database updated in near-real-time while reports are running transactions are being processed is no easy task.