sorry duplicate post due to time out

• This reply was modified 3 months, 3 weeks ago by andrew_dale.

your code for exact age fails for people born on leap days and you are getting the age in non leap years

to get the correct answer, use my FLOOR calculation

isnt' that 11 hours????

would be really interested in an article about promoting content from DEV to TEST to LIVE, as it is now more difficult (in my opinion) in DF2 than it was...

The answer was the title!
However it wasn't obvious what language this was for. Only spotted that the Category was R language in the question list at the bottom, but nothing...

Given that there is no table definition, we have no way of knowing that the fields are integers.

Typo! 24 or 42?

Eirikur Eiriksson (12/7/2016)

---

Question, will you be running other services on the server, i.e. SSIS,SSRS,SSAS etc.?

😎

With 160Gb memory on the server, I would suggest to set the SQL Server Max Memory...

wordracr (5/22/2015)

---

I hate to point it out because the OP has done a lot of nice SP work for this and has a GREAT documentation header, albeit some very minor...

sneaky question. I tried to use by brain and check the valid data ranges (https://msdn.microsoft.com/en-us/library/ms187745(v=sql.105).aspx) in my head so choose the option that both fail, but missed the implicit conversion...

Practically the whole of this article was included in the daily email newsletter (http://www.sqlservercentral.com/NewsletterArchive/2016/10/13/15230172). The only bit missing from the email newsletter was the code after the section "Concluding Thoughts...

free book on SQL Server Backup and Restore to read when you have time

http://www.sqlservercentral.com/articles/books/89519/

regards

Andrew

didn't notice it said select 2 answers!

only selected the 65 answer and got it wrong

nice question I had no idea so googled it and came up with this article

https://www.mssqltips.com/sqlservertip/2343/how-to-monitor-backup-and-restore-progress-in-sql-server-2005-and-2008/