Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Narayana Raghavendra

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Dynamic Partitioning and Dynamic Indexing

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!   Read more...
By Narayana Raghavendra 2007/09/26 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 4,172 reads

Store Key - Storing Misc Data

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!   Read more...
By Narayana Raghavendra 2003/12/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,979 reads

Multiple Table Insert

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.   Read more...
By Narayana Raghavendra 2003/11/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,020 reads

Code Stored in Files Instead of Stored Procedures

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)   Read more...
By Narayana Raghavendra 2003/10/24 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,070 reads

The SQL Delete Statement

New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.   Read more...
By Narayana Raghavendra 2003/07/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,426 reads
   Items 1 to 5 of 5