Having worked extensively with both databases, I know first-hand how much more capable MS SQL Server is than MySQL. Things we take for granted in SQL Server are just not...

Knut Boehnert (5/25/2012)

---

Congratulations to a very nice script - I have seen bits across the web and was working on a similiar version for our databases - your script just...

Yes, it looks like the website replaces spaces with some other character that is not ASCII 32. You don't even have to go via Notepad, just in SSMS highlight one...

I think it's great that Amazon is doing this. It may not be for everybody, it may not provide the level of control and security that financial or healthcare data...

Glad that almost everybody on this thread agrees that asking for Facebook passwords is a bad idea. I do FB, but I have a policy of not friending (on FB)...

Why do people like giving the example of Facebook as an application where consistency is not required? Maybe not by the company themselves, because they (anybody?) hasn't yet worked out...

If the data you are importing are in the form of flat text files, you could write your own ETL routine to import them. I have done this a few...

Imho, the example was way more complex than it needed to be, so much so that it took away from the point of the exercise.

I consider most people on this forum SQL Gods and SQL Gurus (don't ask me who's who!), but in this case I have to say the question was improperly worded...

Good reading and very informative. Thanks.

Running the following code will give you the names and the code of all stored procedures with a varchar declaration. It will not give you the line number, but if...

Thank you everybody for your time and your replies, appreciate it.

Hakim Ali