Interesting request the other week.
I had copied data from one Sql Server database to another, because to do an in-place update of the fields kept falling over. 425 more words
Recently I gave an introductory webinar on how to build an auditing framework for SQL Server. The focus was for those tasked with auditing SQL Server on a regular basis and needing some ideas of how to get started. 56 more words
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best for different queries. In a system with a lot of queries that means we could need a lot of indexes. 1,925 more words