Click here to Skip to main content
12,621,302 members (29,982 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: 10,730   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: 8,301   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: 15,283   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 16,771   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: 5,360   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 25,322   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: 17,371   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
Working with multiple databases on multiple instances is a tough job. You need to monitor all these instances for everything. Best way to keep eye on every instance activity is SQL Server Jobs.
Posted: 17 Sep 2012   Updated: 17 Sep 2012   Views: 5,030   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Most import decision by Database Administrator is that a query on development server, where only hundred or thousand of rows exists, can also perform flawless according to given benchmarks when we will deploy same query on production server, where number of rows could be in millions.One solutio
Posted: 18 Sep 2012   Updated: 18 Sep 2012   Views: 9,973   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 5,230   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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 change compatibility level of a database. Here is a trick for this functionality.
Posted: 30 Dec 2012   Updated: 30 Dec 2012   Views: 11,956   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: 8,462   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.47

Posted: 18 Sep 2012   Updated: 18 Sep 2012   Views: 34,458   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: 8,690   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: 68,294   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: 11,310   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 26,557   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: 5,931   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   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: 8,532   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: 18,381   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 8,680   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,161   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: 12,280   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: 40,474   Rating: 4.86/5    Votes: 7   Popularity: 3.94
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 | Mobile
Web02 | 2.8.161128.1 | Last Updated 2 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid