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)
2,812 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
4,845 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
7,220 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
When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...
By Will Assaf
On July 27, Christine and I will present our joint presentation on Ethics in...
By todd-32417
With the WordPress 5.8 release, we're starting to introduce features that overall improve your...
Hi, I'am currently working on a custom SSIS transform component. I allways create an...
Hello Good Morning Guru's Can you please help me to give some ideas or...
I used SQL Profiler to trace SQL scripts and got one sql statement with...
Ask SSC