This post is in response to Adam Machanic’s “T-SQL Tuesday #002: A Puzzling Situation”. One of the databases I manage has multiple very large tables. The biggest contains about 4.8 billion rows. We had to move this database to another server and while we did, we decided we needed to update the statistics. Note it [...]
|
||||||
|
I’m writing this in response to Adam Machanic’s – T-SQL Tuesday - #001: Date/Time Tricks. Here’s the a very useful script I still use all the time. I created it when I was working on a reporting project – it simply displays all the different date formats in SQL server. –If you are looking to display dates, [...] |
||||||
|
Copyright © 2012 Lohn Solutions - All Rights Reserved |
||||||