An Orders of Magnitude Problem (T-SQL Tuning)
When a query suddenly starts taking much longer, what do you do? This story from Jerry
2013-03-13
7,079 reads
Query Hint
RE: A Grain of Salt
There are four (mis)quotes that spring to mind when someone bangs on about statistics.He uses statistics as a drunken man uses lamp posts -- for support rather than illumination (Andrew Lang)Lies, damn lies and statistics (Benjamin Disraelli).The devil takes equal delight in quoting scripture and statistics. (HG Wells).If your experiment needs statistics, you ought to […]
2004-01-27
2 reads
Report
I have a table like thisDATE COLUMN-A COLUMN-B COLUMN-C 01/12/2004 23 25 76 01/13/2004 12.12 34.234 56 01/14/2004 12 24 46 01/15/2004 26 255 12.3My requirment is, need to generate a report with SQL statement as follow's 01/12/2004 01/13/2004 01/14/2004 01/15/2004 COLUMN-A 23 12.12 12 26 COLUMN-B 25 34.234 24 255 COLUMN-C 76 56 46 12.3 […]
2004-01-21
2 reads
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers