SelecTViews With Stephen Wynkoop Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] How to Remove Index Fragmentation Index fragmentation occurs when the contents of an index are not contiguous as it is stored […]
Author: Ben Taylor
Index Defragmentation
New SelecTViews Show Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] Also: Watch last week’s show here Index Defragmentation Indexes are one of the key components impacting the performance of a relational database. […]
Index Defragmentation
New SelecTViews Show Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] Also: Watch last week’s show here Index Defragmentation Indexes are one of the key components impacting the performance of a relational database. […]
Index Maintenance
Index Maintenance Yesterday I talked about SQL Server Indexes and how important it is to keep them from becoming fragmented in your database. Defragmenting clustered indexes cause all the data to be grouped contiguously on the disk. Defragmenting non-clustered indexes cause those indexes to also be located contiguously on the disk. So, in order to defragment both the data and […]
Index Maintenance
Index Maintenance Yesterday I talked about SQL Server Indexes and how important it is to keep them from becoming fragmented in your database. Defragmenting clustered indexes cause all the data to be grouped contiguously on the disk. Defragmenting non-clustered indexes cause those indexes to also be located contiguously on the disk. So, in order to defragment both the data and […]
Filtered Indexes
Filtered Indexes As you may or may not know there are two basic types of indexes available in SQL Server. Clustered and Non-Clustered. A table (or view) having a clustered index stores the data within the clustered index leaf nodes. A Non-Clustered index stores pointers to the location of the data within the clustered index, if one exists, or the […]
Filtered Indexes
Filtered Indexes As you may or may not know there are two basic types of indexes available in SQL Server. Clustered and Non-Clustered. A table (or view) having a clustered index stores the data within the clustered index leaf nodes. A Non-Clustered index stores pointers to the location of the data within the clustered index, if one exists, or the […]
Lightswitch wrap up
SelecTViews With Stephen Wynkoop Find out the latest news involving Red Gate, IBM’s Watson supercomputer, Office 365 and more. Stephen Wynkoop discusses the benefits of "big data". An interview with MaximumASP’s Sarah Barela delves into database forensics and best practices for tracking users. [Watch the Show] Lightswitch wrap up I received some interesting Email regarding Lightswitch. I think I can […]
Lightswitch wrap up
SelecTViews With Stephen Wynkoop Find out the latest news involving Red Gate, IBM’s Watson supercomputer, Office 365 and more. Stephen Wynkoop discusses the benefits of "big data". An interview with MaximumASP’s Sarah Barela delves into database forensics and best practices for tracking users. [Watch the Show] Lightswitch wrap up I received some interesting Email regarding Lightswitch. I think I can […]
Lightswitch Where Does It Belong
Lightswitch – Where Does It Belong Some like it…some like it not. David C says: I have been using Lightswitch for over a month now and it is a great RAD tool. We are using it for an in-house admin tool to allow the BAs to edit metadata for our own code generation tool. It works great until you have […]