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,605 reads
This article proposes a system where extra data is stored in a simple row based table and retrieved using the 'store key'. It's not a new concept of course, but the author explains how and why he chose to implement. Feedback should be interesting!
2003-12-04
4,192 reads
This article shows how to do conditional multiple table inserts. While it is more script than we typically display, it's interesting and might get you thinking about other uses for the idea.
2003-11-18
14,290 reads
This articles proposes storing the source code for stored procedures on disk rather than in the database itself, the intent to give developers the ability to easily change them or potentially to allow third party encryption of source code. (Note from SSC: If you choose to implement a technique like this, please be sure you understand the implications of exec'ing strings)
2003-10-24
8,309 reads
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
2003-07-22
19,601 reads
One feature that I have been waiting for years! The new announcement around optimize...
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to...
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers