1,295 reputation
318
bio website connectsql.com
location
age
visits member for 2 years, 6 months
seen 2 days ago

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.


2d
revised Sql server sqllogship.exe…full docs?
must have correct tag
2d
suggested approved edit on Sql server sqllogship.exe…full docs?
2d
reviewed No Action Needed SQL Pivot by data
Jan
27
awarded  Popular Question
Jan
15
comment How to optimize: having COUNT(*)>1
Proper indexing will help optimizer to fetch data using indexing seak and then Hash Aggregate can be converted to Stream Aggregate, resulting better performance.
Jan
14
reviewed No Action Needed ola hallengren Index Maintenance script - GUID Index
Jan
14
reviewed No Action Needed SQL server export wizard gets stuck
Jan
14
reviewed No Action Needed Looking for a set-based solution for a rolling 30-day period
Jan
13
reviewed No Action Needed How to restore a database then upgrade it in a single SQL script?
Jan
7
reviewed Reviewed Creating separate small table from big based on access frequency for “select” performance
Jan
7
comment Creating separate small table from big based on access frequency for “select” performance
Data partitioning will partition your indexes also and it can be helpful to pull data efficiently from hot data part.
Jan
7
reviewed No Action Needed MySql pivot table for scatter chart
Jan
7
reviewed No Action Needed How do you find where a stored procedure is used (in other stored procedures)
Jan
5
reviewed No Action Needed Error when trying to deploy SSIS package
Jan
5
answered MS Access Query to update
Jan
2
revised Connection error except with SQLYog
error formatting
Jan
2
reviewed Reviewed Connection error except with SQLYog
Jan
2
suggested approved edit on Connection error except with SQLYog
Dec
22
revised Unable to connect to Oracle from SQL Developer
error statement formating
Dec
22
reviewed Reviewed Unable to connect to Oracle from SQL Developer