Why duplicates? It is surprisingly easy to inadvertently create duplicate records in a table. More often than not, it is because we either didn't check for an existing record or…
Find duplicate records in a table and remove them
SQL Number of records per table
Do you know? There are lots of reasons why you might want to know how many records there are in your database tables. One of the most common is because…
List IIS AppPool processes
The problem How do you view the app pool processes running in IIS? The Answer Run the following command from an Admin Console Window: - c:\windows\System32\inetsrv\appcmd.exe list wp It will…
Check for SQL Index Fragmentation
Your database is like a machine. Much like your car, your database needs maintenance to ensure it runs smoothly. The indexes slowly become fragmented as you insert, delete, and update…
SQL Disk Space Usage
How big? It isn't very often that you need to understand which tables take up most space within your database. Normally, knowing how much space the entire database consumes is…
Test SQL Connection without SSMS
Background You'll find yourself logged into a web or application server and need to test that you can access the SQL server at which you've unsuccessfully tried to point your…
Web Forms Page / Control Events and Sequence
What are Web Forms Web Forms was the first Dot Net ASP.Net Web Framework. The technology was the easiest way for existing Microsoft Platform developers to move to the web.…
SQL Joins
Background There are many ways to join tables and views in an SQL server. This diagram is a great quick reference.
SQL Suggested Indexes
How SQL access data Whenever SQL Server executes a query, it builds an execution plan to find the data and return it to the requesting process. I have another post…
Determine where SQL files are
SQL Files A typical SQL Server Database comprises two physical files on the disks: an 'mdf' file and a 'ldf' file. The 'mdf' file contains the database scheme, tables, stored…