A better way to index text data
Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for. However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server. This post shows a couple of techniques which can be used to increase index performance which decreasing the storage requirement.
Book: The Windows Manager’s Guide to iSCSI SANs
That’s right I said a book. Well it’s actually an eBook but good enough right? The best part is that it’s available for free. It’s a three chapter eBook called “The Windows Manager’s Guide to iSCSI SANs”. Each chapter was posted separately so you have to click through to each one. Registration is required to […]
Book: The Windows Manager’s Guide to iSCSI SANs
That’s right I said a book. Well it’s actually an eBook but good enough right? The best part is that it’s available for free. It’s a three chapter eBook called “The Windows Manager’s Guide to iSCSI SANs”. Each chapter was posted separately so you have to click through to each one. Registration is required to […]
Using batching to do large operations without filling the transaction log
Deleting large amounts of data from a table is usually an important task, but if you don’t have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database. Not to mention you will cause a very large amount of data into […]