New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.
2019-03-18
3,669 reads
An ITVF function that rounds a number to the nearest Power of 10
2017-05-15 (first published: 2017-05-05)
289 reads
OK. Makes perfect sense. Thanks for the 411. I'll take this under advisement and look into scripting more of my tasks whenever possible. LanMan
2005-05-24
Does anyone know what the CHECKSUM() functions collision rate is?Microsoft's own example in 2005/2000 BOL gives an example that includes collision work-around. Does this imply that it has a high collision rate? Does anyone use this function extensively?
2005-01-20
14 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers