Hit-Highlighting in Full-Text Search
Hit-highlighting is a feature that many people wish Full-Text Search would support natively. See possible solutions.
Hit-highlighting is a feature that many people wish Full-Text Search would support natively. See possible solutions.
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...
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...
I talk about the default cursor options in SQL Server and why you may want to override them.
Tip : Revisit your use of the SQL Server REMOTE join hint
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...
Your data type choices can sometimes have more impact than you think.
Tip : Build a quota system for SQL Server user defined tables
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...
There was a little bug in the cumulative update installer in early CU builds of SQL Server 2012 RTM.
There are lots of ways to remove time from a date, but most of them are extremely inefficient.