Articles by aasim abdullah (Technical Blogs: 12, Tip/Tricks: 12)

Technical Blogs: 12, Tip/Tricks: 12

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating: 3.17

Database Development
SQL Server	SQL Server: Simple way to swap column values [Technical Blog] 12 Sep 2012 Updated: 12 Sep 2012 Rating: 3.50/5 Votes: 2 Popularity: 1.05 Licence: CPOL Views: 41,233 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. A simple way to swap column values.
	SQL Server: How Local Variables Can Reduce Query Performance [Technical Blog] 15 Sep 2012 Updated: 15 Sep 2012 Rating: 1.20/5 Votes: 3 Popularity: 0.57 Licence: CPOL Views: 18,062 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. How local variables can reduce query performance in SQL Server
	SQL Server: Controlling SQL Server Log Information [Technical Blog] 15 Sep 2012 Updated: 15 Sep 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 8,840 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. How to control SQL Server Log Information
	SQL Server: Applying Filter on sp_MSforeachDB [Technical Blog] 16 Sep 2012 Updated: 16 Sep 2012 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: CPOL Views: 41,375 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. How to apply filter on sp_MSforeachDB
	SQL Server: Script to Generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space [Technical Blog] 15 Sep 2012 Updated: 17 Sep 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 27,252 Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space
	SQL Server: Smarter Way of Query Load Testing at Testing Server [Technical Blog] 17 Sep 2012 Updated: 17 Sep 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 8,791 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Smarter Way of Query Load Testing at Testing Server
	SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem [Technical Blog] 17 Sep 2012 Updated: 17 Sep 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 28,025 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.
	SQL Server: Placing Alert for Compatibility Level Change in SQL 2005 [Technical Blog] 22 Oct 2012 Updated: 22 Oct 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 10,220 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. In SQL Server 2005, there is no way to find out WHO AND WHEN someone changed the compatibility level of a database. Here is a trick for this functionality.
	SQL Server: Three Common DDL Change Log Methods [Technical Blog] 30 Dec 2012 Updated: 30 Dec 2012 Rating: 4.67/5 Votes: 3 Popularity: 2.23 Licence: CPOL Views: 18,660 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Three common DDL change log methods for SQL Server.
	SQL Server: A Query Slow in SSMS, Fast in Application, WHY? [Technical Blog] 7 Jan 2013 Updated: 9 Jan 2013 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 15,000 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. SQL Server: A Query Slow in SSMS, Fast in Application, WHY?
Desktop Programming
ATL	SQL Server: Query to find upcoming birthdays for the current week [Technical Blog] 12 Sep 2012 Updated: 12 Sep 2012 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 16,280 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. To find out whose birthday is coming in a given number of days is very simple.
	SQL Server: Why we should avoid the NOLOCK table hint in DELETE/UPDATE queries [Technical Blog] 12 Sep 2012 Updated: 12 Sep 2012 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 25,220 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Why we should avoid the NOLOCK table Hint in DELETE/UPDATE queries.

Average tips rating: 4.42

Database Development
SQL Server	SQL Server: How to Get All Indexes List With Involved Columns Name [Tip/Trick] 17 Sep 2012 Updated: 17 Sep 2012 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 46,471 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Get all indexes list in detail, with their involved columns
	SQL Server: Keeping Log/Alert for Job Disable/Enable Status [Tip/Trick] 1 Oct 2012 Updated: 1 Oct 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 15,200 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. How do you know, if someone disabled your job at production database server. Who is the calprit. How to send a mail alert for this change ??
	SQL Server: Get All Databases Size [Tip/Trick] 2 Oct 2012 Updated: 2 Oct 2012 Rating: 4.43/5 Votes: 5 Popularity: 3.10 Licence: CPOL Views: 103,767 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. A simple query to get all databases size on a given instance.
	SQL Server Management Studio: Basic Startup Options [Tip/Trick] 2 Oct 2012 Updated: 2 Oct 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 15,030 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Using SQL Server Management Studio, have you ever come a cross following questions: Why every time, a new query window is open with MASTER database.? On opening SQL Server Management Studio, I need a new query window automatically ?
	SQL Server: How to Refresh Intellisense Cache [Tip/Trick] 20 Oct 2012 Updated: 20 Oct 2012 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: CPOL Views: 45,752 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. How to Refresh Intellisense Cache in SQL Server
	SQL Server: Changed data capture without using Triggers [Tip/Trick] 23 Oct 2012 Updated: 23 Oct 2012 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 10,460 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.
	SQL Server : How to Keep Database Restore History [Tip/Trick] 24 Oct 2012 Updated: 24 Oct 2012 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 14,581 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Backup and then restore of a database is a normal job for developers and DBAs. This script will be helpfull to findout, from which path, and which backup file a database was restored.
	SQL Server Scripts: Get All Nested Stored Procedures List (Procedures with Dependent Procedures) [Tip/Trick] 1 Nov 2012 Updated: 1 Nov 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 34,950 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. A stored procedure can be called from another stored procedure as nested stored procedure. How to get a list of these stored procedures with their nested one
	SQL Server: Bookmark Lookups, a Query Performance Killer [Tip/Trick] 1 Nov 2012 Updated: 1 Nov 2012 Rating: 4.40/5 Votes: 4 Popularity: 2.65 Licence: CPOL Views: 12,651 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. You have place indexes but still queries are slow... are you facing bookmark lookup problem ???
	SQL Server: Automatic Query Execution at Every Instance Startup [Tip/Trick] 19 Oct 2012 Updated: 19 Apr 2013 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 10,860 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Automatic query execution at every instance startup.
	SQL Server: Restore Failure from Enterprise to Standard Edition [Tip/Trick] 17 Sep 2012 Updated: 19 Apr 2013 Rating: 1.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 22,301 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Restore failure from Enterprise to Standard edition in SQL Server.
	SQL Server: TOP…WITH TIES - A Beauty of TSQL [Tip/Trick] 21 Oct 2012 Updated: 19 Apr 2013 Rating: 4.38/5 Votes: 8 Popularity: 3.95 Licence: CPOL Views: 87,325 Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. The TOP clause is commonly used to get the top required rows from a result set. The beauty of this clause is that it can be used with the WITH TIES clause to retrieve all similar rows to a base result set.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

aasim abdullah

Team Leader CureMD

Pakistan

Aasim Abdullah is working as SQL Server DBA with CureMD (www.curemd.com) based in NY, USA. He has been working with SQL Server since 2007 (Version 2005) and has used it in many projects as a developer, administrator, database designer. Aasim's primary interest is SQL Server performance tuning. If he finds the time, he like to sketch faces with graphite pencils.