by Rahul Singla | Mar 13, 2024 | Programming Techniques, Sql Server, Sql Server 2005, Sql Server 2008
I was recently tasked with improving the performance of one of our Sql Server Stored Procedures which found and returned next available Profile Number for new Profiles to be created in the application. Although the actual circumstances were considerably more complex,...
by Rahul Singla | Mar 16, 2012 | Blog, Sql Server, Sql Server 2005, Sql Server 2008
In one of our Enterprise web application, we rely on Sql Server’s Service Broker backed Query Notification feature a lot. Basically the database of that application is exposed to many other client-specific apps, and our app needs to respond to changes being made...
by Rahul Singla | Jan 20, 2012 | Blog, Sql Server
I am in the process of revamping server setups for my office as a part of which I am establishing different Windows servers for Sql Server Developer 2008, Sql Server Express and Svn Server. Considering that I often work late nights from my home as well as when I am...
by Rahul Singla | Jul 31, 2011 | Blog, Sql Server
This week 2-3 days back, I got a really strange Sql Server error when browsing to one of my ASP.NET applications in the brower on my development server. As soon as I opened the app, the following error greeted me: M8ZWJBN5J8RV The log for database...
by Rahul Singla | Dec 19, 2010 | Blog, Sql Server
Performing database side paging has always been a headache in Sql Server (as opposed to MySql which provides a built-in LIMIT clause for easy paging). However, I recently found an easy, fast and intuitive way of paging the data on the database side in Sql Server...
by Rahul Singla | Nov 30, 2010 | Blog, Sql Server
You would find some useful links on web, if you search with the title of this blog post. Basically you cannot pass parameters to a Trigger because Triggers get fired automatically by the database engine, and you do not interact with them directly as they...
Recent Comments