robault.com

Well, after reviewing my earlier posts on building a reindex script, I think I’ll break it a part a bit. On one hand getting the best disk performance from SQL requires it’s files to be defragmented, on the other the placement of the pages inside the database file need to be “defragmented”. The ch... [More]

In my last post about the BackgroundWorker object, I showed how to create threads using the toolbox control. I had mentioned an easier way using less code existed and…it involves using a System.Timers.Timer object (and a small but potentially disastrous hack). This is easy to do and ... [More]

Image via Wikipedia What a SQL re-indexing process should be doing: 1. Re-indexing indexes or tables over 30% fragmentation (BOL). Some estimates are 15-20% or more. 2. Reorganizing indexes or tables less than 30% fragmented (BOL). Some estimates are 2%-10%. 3. It ap... [More]

Image via Wikipedia You probably don’t have a DBA on site but you need some DB maintenance. A DBA is a resource developers hope would be there when their product ships, but most companies don’t realize the importance of having someone actively managing their SQL servers. SQL is good e... [More]

Hey there. I’ve been pretty wrapped up in SQL lately but I wanted to get some posts that are mini-tutorials to illustrate some concepts difficult to grasp for beginners. I’ve found plenty of resources on the internet but not all of them are easy, or cut and dry. Let’s see if I can make adding thread... [More]