Posts
832
Comments
691
Trackbacks
1
SQL
SQL Server: How to document and configure server instance settings

For my own future reference, from SimpleTalk.

posted @ Tuesday, January 31, 2012 2:07 PM | Feedback (0)
ProSQL Trump Cards

These are funny.  If you don’t understand why they are funny (which might not be for the obvious reasons one would think they are funny), don’t worry about it.

posted @ Wednesday, January 25, 2012 7:18 PM | Feedback (0)
Repost: MoreSQL

Here is a post that announces the MoreSQL movement. For true fun, read the comments.

posted @ Wednesday, January 25, 2012 12:36 PM | Feedback (0)
This is a semi-complex query?

Rob posted something about how to implement complex queries using Massive: “Here’s a semi-complex query that is all too common in the business case: var results - DynamicModel.Open(connectionString).Query(@" SELECT Orders.OrderNumber, Categories.Name FROM Products INNER JOIN Categories ON Categories.CategoryID = Products.CategoryID INNER JOIN OrderItems ON OrderItems.ProductID = Products.ID INNER JOIN Orders ON Orders.OrderID = OrderItems.OrderID WHERE Orders.OrderDate > @0 ", DateTime.Now.AddYears(-1)); ...

posted @ Tuesday, August 09, 2011 5:28 PM | Feedback (0)
SQL Query Troubleshooting Tip #1

If a query that has been running without a hitch suddenly crawls to a standstill for no apparent reason, try updating statistics. In SQL Server, run sp_updatestats. And if you are experienced with SQL Server, think of trying tip #1 first, not four hours later.

posted @ Wednesday, July 20, 2011 7:08 PM | Feedback (0)
SQL Server: When were my indexes and statistics updated?

From http://weblogs.sqlteam.com/joew/archive/2007/08/31/60316.aspx, use these queries to check when statistics for indexes were last updated. SELECT t.name AS Table_Name ,i.name AS Index_Name ,i.type_desc AS Index_Type ,STATS_DATE(i.object_id,i.index_id) AS Date_Updated FROM sys.indexes i JOIN sys.tables t ON t.object_id = i.object_id WHERE i.type > 0 ORDER BY t.name ASC ,i.type_desc ASC ,i.name ASC SELECT name AS stats_name ,STATS_DATE(object_id, stats_id) AS statistics_update_date, * FROM sys.stats order by STATS_DATE(object_id, stats_id)  

posted @ Thursday, November 04, 2010 9:13 AM | Feedback (0)
RethinkDB : Another challenge to NoSql Orthodoxy

Take a look at RethinkDB, a drop-in replacement for the MySql orthodoxy. A central theme of NoSql orthodoxy is that ACID can’t scale.  The fact that companies like Amazon and Google (you may have heard of them) have ‘abandoned’ ACID is, in my mind, enough proof anyone needs that the NoSql is a valid option that anyone who needs to consider data storage options (what an ugly sentence….but I digress). What I like about things like VoltDB and RethinkDB is that they are attempting to rise to the challenge.  Can you have your ACID cake and eat it...

posted @ Thursday, July 01, 2010 6:36 PM | Feedback (0)
NoSQL and the Six SQL Urban Myths

A very interesting article from the Hot Scalability site about VOLTDB, a next-generation RDBMS that is purported to scale beyond NoSQL implementations without giving up ACID.  It targets both the NoSQL style databases (listing the six SQL urban myths that its makers think NoSQL advocates fall prey to) as well as the ‘dinosaur’ traditional RDBMS’ like Oracle and SQL Server. The article is a very interesting read, giving a lot of pros and cons about VOLTDB, but if databases are your cup of tea, it’s definitely worth looking into. Check it out.

posted @ Monday, June 28, 2010 5:13 PM | Feedback (0)
RavenDB, and a brief design philosophy discussion with Ayende

Suppose you design a system that is chock full of interfaces, specifically things like some version of IRepository, where you have the ability to change out your backing store/database more easily. A common criticism of this sort of design is that it is unrealistic to think you actually will change your main backing store/database in a production system.  My own experience is that while it does happen (a current client project I am working on involves changing the backing database for a set of applications from SQL Server to Oracle, for instance), it doesn’t happen often, and you often...

posted @ Friday, May 21, 2010 7:44 PM | Feedback (1)
NoSQL in the Wild

Rob Conery has a post about how they run Tekpub using NoSQL that’s a great read. I’m not qualified to talk about Ruby code but that part is kind of irrelevant.  He hits all the right notes in talking about why they did the things they did (I could quibble about the cost ‘criticism’ of BizSpark, but that’s a business decision), especially in terms of separating reporting. It’s a good read, check it out.

posted @ Wednesday, May 19, 2010 8:20 PM | Feedback (0)
Full SQL Archive