Click here to Skip to main content

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.22

ATL Server
General
Posted: 15 Sep 2012   Updated: 15 Sep 2012   Views: 8,510   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. USEAdventureWorksGO CREATE TA
Site & Server Management
General
Posted: 7 Jan 2013   Updated: 9 Jan 2013   Views: 5,380   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Today, a colleague asked me, why his simple selectquery is taking around 3000ms (3 Seconds) to execute while, same query is quite fast when executed from application. Answer is simple: SQL Server Management Studio use RBAR-Row By Agonizing Rowmethod to fetch rows and inform row by row to SQL Server
Database
SQL
Posted: 12 Sep 2012   Updated: 12 Sep 2012   Views: 5,980   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: 10,000   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: 11,050   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: 4,450   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: 17,250   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
How to apply filter on sp_MSforeachDB
Posted: 15 Sep 2012   Updated: 17 Sep 2012   Views: 12,590   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. How quickly databases on these instances are growing and does target instance has required space on hard d
Posted: 17 Sep 2012   Updated: 17 Sep 2012   Views: 3,870   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 solution is
Posted: 18 Sep 2012   Updated: 18 Sep 2012   Views: 6,400   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: 3,570   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: 7,560   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Three common DDL change log methods for SQL Server.

Average tips rating: 4.50

Posted: 18 Sep 2012   Updated: 18 Sep 2012   Views: 23,450   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: 6,080   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: 41,820   Rating: 4.83/5    Votes: 4   Popularity: 3.01
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: 9,270   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: 14,540   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: 3,860   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: 5,760   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: 10,860   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: 6,240   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: 5,860   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: 8,320   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: 22,680   Rating: 4.75/5    Votes: 4   Popularity: 2.81
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   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.
Follow on   Twitter   Google+


Advertise | Privacy | Mobile
Web04 | 2.8.150414.1 | Last Updated 18 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid