How to Rotate Advertisements using JQuery and ASP NET AdRotator Control

The ASP.NET AdRotator control is a useful control to randomly display advertisements on a webpage. However the ads in the adrotator control are rotated only when the user refreshes the page. In this article, we will use a single line of jQuery code to rotate ads using the adrotator control, at regular…

Read More

How to Count total number of objects in SQL Server instance

Below query will help you find the list of object counts in the database: SELECT type, total_count = COUNT(*), last_crdate = MAX(crdate), last_refdate = MAX(refdate) FROM ( SELECT type = CASE WHEN xtype = ‘U’ THEN ‘table’ WHEN xtype = ‘V’ THEN ‘view’ WHEN xtype = ‘P’ THEN ‘proc’ WHEN…

Read More