(Sanjit Anand) If you are working in big user environment, user always complain there request get stuck or takes time to start processing. Majority of time Support team cann’t do anything, unless waiting or asking DBA to check the server performance.
Other News
Troubleshooting SQL Server error ‘The operating system returned error 1453’
(Chris Skorlinski) I worked on an interesting SQL startup problem today. I don’t see this error very often, but since there wasn’t much on the web, I thought I would write it up and post it on my blog.
Generating a list of missing numbers
A reader recently asked a question about generating a list of missing numbers from a column. They were using an auto-incremental number column and due to deletes done on the table by different transactions, they had gaps in the values in this column. They were not interested in re-using those valu
Preprocessed Razor Templates
(K. Scott Allen) Preprocessed T4 templates generate all the code you need to execute a template at runtime.
Dynamic Web Applications with ASP.NET Mono using MySQL and VB.NET
This tutorial will provide an example of an actual, dynamic web application project in ASP.NET Mono using MySQL and VB.NET. A “dynamic web application,” as described in this tutorial, refers to a web application that depends on the use of a database.
Using Helper Methods with ASP.NET Web Matrix Beta 3
(Malcolm Sheridan) One of the great features of ASP.NET Web Pages is the ability to create reusable code through Helpers. Helpers are written in either Razor syntax, or even by creating class libraries in C# or VB.NET. Helpers always return IHtmlString, which is HTML encoded string. Helpers can be c
IBM Cognos Proven Practices: IBM Cognos BI – Restrict Tree Prompt Selection with JavaScript
(Robert Hendriks) A technique for report developers that wish to utilize a Tree Prompt but require that the value submitted be restricted to a designated level within a hierarchy.
Limiting the Number of Rows in MySQL Result Sets
(Rob Gravelle) In the Web 2.0 world where smart phone and Web applications are competing to access terabytes of data, there is a new imperative for speeding up retrieval times as much as the technology permits.
SQL SERVER – Plan Cache and Data Cache in Memory
(Pinalkumar Dave) I get following question almost all the time when I go for consultations or training. I often end up providing the scripts to my clients and attendees. Instead of writing new blog post, today in this single blog post, I am going to cover both the script and going to link to origina
Policy Based Management and BCP
New SelecTViews Show Available! More, smaller databases? Manage your checklists, our featured blog of the week for business intelligence…Also, the hotmail outage and SQL Server, 3rd party tools and more. [Watch The Show Here] Featured Article(s) Improving .NET Application Performance and Reliability with Managed Database Connectivity (Part 1 of 3) Whether your .NET applications are built using C# or VB.NET, […]