Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.
2019-08-13 (first published: 2019-08-04)
8,277 reads
Developing an enterprise architecture can be viewed as connect-the-dots for adults. However, in doing so, all you get is a pretty picture and not a management tool that can help an organization understand and manage itself.
2007-10-04
2,786 reads
We are always searching for new ways to improve the performance of our database systems. Raghavendra Narayana brings us a new article that examines an idea for rebuilding partitions and indexes based on data access: in real time!
2007-09-26
5,634 reads
Optimize the performance of a database which includes history or status tables.
2007-09-13
2,625 reads
There is an urgent need to acknowledge the limitations of data models and find a way to bridge the logical-physical divide between models and actual databases so that database designs can be fully understood.
2007-09-13
3,221 reads
Part 7 of our "Developing a Complete SQL Server OLTP Database Project" discusses performance issues resulting from using EncryptByCert and DecryptByCert. Read the article and download the code to run the test yourself.
2007-08-28
1,980 reads
SQL Server 2005 includes support for encrypting and decrypting data for storage using EncryptByCert. Let’s look at how to implement this in the SqlCredit database.
2007-08-24
2,450 reads
Alex Kuznetsov starts off a series of three articles on 'Unit Testing' your database development work. He begins by describing five simple rules that make all the difference.
2007-08-20
3,248 reads
Many new DBAs think that User-defined types are a very cool feature in SQL Server when they first encounter them. However many experienced DBAs soon realize that UDTs can be a pain to work with and longtime SQL Server guru David Poole discusses his experiences
2007-07-23
8,023 reads
In this article, we will examine some rarely explored areas that concern foreign keys; in particular, we will look at disabled and un-trusted foreign keys.
2007-06-29
3,287 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers