Luis Cazares (6/23/2016)

---

Why would you allow the user to provide an invalid value in the first place?

We have data types for a reason, using strings to handle values is lazy...

So...

http://www.w3schools.com/sql/sql_dates.asp

http://www.w3schools.com/sql/func_convert.asp

https://msdn.microsoft.com/en-us/library/ms187347.aspx ( ISDATE() Function)

https://technet.microsoft.com/en-us/library/ms179465(v=sql.105).aspx ( Handling Database Engine Errors )

http://sqlmag.com/t-sql/t-sql-best-practices-part-2 (See datetime best practices section)

But...

dhaveedh (6/23/2016)

---

In your last post you said SELECT CONVERT(Datetime, '29-Feb-2') returns an error because SQL Server does not accept single digit years?

Why does SELECT CONVERT(Datetime, '28-Feb-2') return 2002-02-28 00.00.00.000 without...

Jeff Moden (6/23/2016)

---

No need for the sarcasm. You made an incorrect statement that newbies would misinterpret and I made sure they weren't mislead.

Shifting gears to the subject at hand,...

dhaveedh (6/21/2016)

I do not think that the article ever implied or attributed any bug to SQL Server. It was merely highlighting how SQL Server was dealing with the bad data...

Jeff Moden (6/20/2016)

---

That's not true at all. SQL Server will take a couple dozen date/time formats in...

It's not so much a critique of the original code which I would expect you would understand needs refactoring. However, one should expect strange outcomes when data is passed to...

I wouldn't call it a SQL Server issue. SQL Server expects the date to be passed in as "2016-06-20 00:00:00" which is the standard SQL Server datetime format. So if...

agtcovert (7/24/2015)

---

I'm sorry, but this article is dreadful and despite the claims of research, the author still doesn't have a good understanding of a SAN (or NAS) environment.

First, talk to...

While I don't disagree that a basic NAS versus a basic SAN is slower at a general level, in reality there is a lot more to it than that, and...

Scott D. Jacobson (4/26/2012)

---

I'm really surprised no one mentioned [url= http://www.openfiler.com/%5DOpenFiler%5B/url%5D. Some of us don't have the luxury of shelling out hundreds of thousands or millions of...

Phil Parkin (7/10/2015)

OK, I roundly disagree with your absolute statement:

Here is a part of a setup script I wrote recently. I developed it on...

Phil Parkin (7/10/2015)

I agree with you for production code. The general thrust of the thread, however, is around the creation of utility or setup scripts which are run and debugged...

As a point of clarity in code purpose, re-usability, script length, and the "what the heck was this guy thinking" factor, I find commented out code to be a poor...