Click here to Skip to main content
13,257,276 members (52,836 online)

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

Technical Blogs: 12, Tip/Tricks: 12

RSS Feed
No articles have been posted.

Average blogs rating: 3.25

ATL Server
General
Posted: 15 Sep 2012   Updated: 15 Sep 2012   Views: 11,650   Rating: 1.33/5    Votes: 2   Popularity: 0.60
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
It’s a common practice by database developers to use local variables in stored procedures and scripts to place filter on basis of these local variables. YES, these local variables can slowdown your queries. Let’s prove it. Create a new table and insert dummy rows.
Database
SQL
Posted: 12 Sep 2012   Updated: 12 Sep 2012   Views: 10,030   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
To find out whose birthday is coming in a given number of days is very simple.
SQL Server
Posted: 12 Sep 2012   Updated: 12 Sep 2012   Views: 17,920   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Why we should avoid the NOLOCK table Hint in DELETE/UPDATE queries.
Posted: 12 Sep 2012   Updated: 12 Sep 2012   Views: 20,520   Rating: 3.50/5    Votes: 2   Popularity: 0.90
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
A simple way to swap column values.
Posted: 15 Sep 2012   Updated: 15 Sep 2012   Views: 6,130   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
How to control SQL Server Log Information
Posted: 16 Sep 2012   Updated: 16 Sep 2012   Views: 28,700   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
How to apply filter on sp_MSforeachDB
Posted: 15 Sep 2012   Updated: 17 Sep 2012   Views: 19,640   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space
Posted: 17 Sep 2012   Updated: 17 Sep 2012   Views: 6,100   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Smarter Way of Query Load Testing at Testing Server
Posted: 18 Sep 2012   Updated: 18 Sep 2012   Views: 12,130   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
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.
Posted: 22 Oct 2012   Updated: 22 Oct 2012   Views: 6,480   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
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.
Posted: 30 Dec 2012   Updated: 30 Dec 2012   Views: 13,650   Rating: 4.67/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Three common DDL change log methods for SQL Server.
Posted: 7 Jan 2013   Updated: 9 Jan 2013   Views: 10,110   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

Average tips rating: 4.42

Posted: 18 Sep 2012   Updated: 18 Sep 2012   Views: 39,070   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Get all indexes list in detail, with their involved columns
Posted: 1 Oct 2012   Updated: 1 Oct 2012   Views: 10,280   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
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 ??
Posted: 2 Oct 2012   Updated: 2 Oct 2012   Views: 78,210   Rating: 4.43/5    Votes: 5   Popularity: 3.38
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
A simple query to get all databases size on a given instance.
Posted: 2 Oct 2012   Updated: 2 Oct 2012   Views: 12,420   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
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 ?
Posted: 20 Oct 2012   Updated: 20 Oct 2012   Views: 31,660   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
How to Refresh Intellisense Cache in SQL Server
Posted: 23 Oct 2012   Updated: 23 Oct 2012   Views: 7,060   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.
Posted: 24 Oct 2012   Updated: 24 Oct 2012   Views: 10,140   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
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.
Posted: 1 Nov 2012   Updated: 1 Nov 2012   Views: 22,030   Rating: 0.00/5    Votes:    Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
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
Posted: 1 Nov 2012   Updated: 1 Nov 2012   Views: 9,500   Rating: 4.40/5    Votes: 4   Popularity: 2.81
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
You have place indexes but still queries are slow... are you facing bookmark lookup problem ???
Posted: 19 Oct 2012   Updated: 19 Apr 2013   Views: 7,990   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Automatic query execution at every instance startup.
Posted: 17 Sep 2012   Updated: 19 Apr 2013   Views: 15,290   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Restore failure from Enterprise to Standard edition in SQL Server.
Posted: 21 Oct 2012   Updated: 19 Apr 2013   Views: 47,800   Rating: 4.38/5    Votes: 8   Popularity: 4.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
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.
No reference articles have been posted.

aasim abdullah
Team Leader CureMD
Pakistan 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.


Advertise | Privacy |
Web03 | 2.8.171114.1 | Last Updated 23 Nov 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid