Hit-Highlighting in Full-Text Search
Hit-highlighting is a feature that many people wish Full-Text Search would support natively. See possible solutions.
Monthly Archive: September 2012
Cumulative Update #7 for SQL Server 2008 Service Pack 3 is available
Today Microsoft has released a new cumulative update for SQL Server 2008. Cumulative Update #7 for SQL Server 2008 Service Pack 3 Knowledge Base Article: KB #2738350 At the time of writing, there are...
SQL Server 2012 Service Pack 1 CTP4 is available
This morning the SQL Server team announced the release of Service Pack 1 CTP4 for SQL Server 2012. Back in July I talked about CTP3 and how the release contained BI features only; no...
What impact can different cursor options have?
I talk about the default cursor options in SQL Server and why you may want to override them.
Revisit your use of the SQL Server REMOTE join hint
Tip : Revisit your use of the SQL Server REMOTE join hint
SQLSaturday #156 : Providence, RI
Well, East Greenwich, RI. Another successful event, this one put on by John Miner, Brandon Leach, Steve Simon, Scott Abrants and a host of other folks. Several #SQLFamily friends in attendance as well: Grant...
How much impact can a data type choice have?
Your data type choices can sometimes have more impact than you think.
Build a quota system for SQL Server user defined tables
Tip : Build a quota system for SQL Server user defined tables
SQLSaturday #162 : Cambridge, England
Yesterday I presented at SQLSaturday #162. My slide deck and samples are here: Slide Deck & Samples: Bertrand – T-SQL Bad Habits & Best Practices I also wanted to answer a question...
SqlLocalDb vs. Cumulative Updates
There was a little bug in the cumulative update installer in early CU builds of SQL Server 2012 RTM.
What is the most efficient way to trim time from datetime?
There are lots of ways to remove time from a date, but most of them are extremely inefficient.