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)
7,226 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,588 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,858 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 Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
hi i never used shared datasets before in ssrs. i created a dataset called...
Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers