16,012,508 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Artificial Intelligence
Artificial Intelligence
Neural Networks
Machine Learning
Deep Learning
ML.Net
Big Data
Data Science
Tensorflow
ChatGPT
Internet of Things
Internet of Things
Arduino
Edge Device
Raspberry-Pi
Wearables
IoT Edge
Industrial IoT
DevOps
DevOps
Agile
Automation
Continuous Build
Continuous Delivery
Continuous Deployment
Continuous Integration
Deployment
Git
Installation
Integration Testing
Load Testing
Quality Assurance
TFS
Unit Testing
Testing
Containers
Containers
Docker
Kubernetes
Virtual Machine
High Performance Computing
High Performance Computing
GPU
Parallel Processing
Parallelization
Vectorization
Hosted Services
Hosted Services
AWS
Cordova
ExtJS
Google Cloud
Microservices
PhoneGap
Serverless
Storage
Web Hosting
WordPress
Azure
Security
Security
Blockchain
Cryptography
Encryption
Identity
Identity Server
Web Development
Web Development
Blazor
CSS3
Flask
HTML5
Kestrel
LESS
Nginx
Node.js
React
SCSS
Spring
Vue.js
ASP.NET
CSS
Apache
HTML
IIS
XHTML
Mobile Apps
Mobile Apps
Flutter
Ionic
iOS
Nativescript
React Native
Xamarin
Windows Mobile
Android
Desktop Programming
Desktop Programming
Cocoa
Electron
QT
Universal Windows Platform
X11
Windows Forms
ATL
MFC
Swing
Win32
WTL
WPF
XAML
System
Database Development
Database Development
Data Visualization
Elasticsearch
Lucene
MariaDB
MongoDB
NoSQL
PostgreSQL
Redis
MySQL
SQL Server
Productivity Apps and Services
Productivity Apps and Services
LibreOffice
OpenOffice
Sharepoint
Team Communication Tools
Biztalk
Microsoft Office
SAP
Game Development
Game Development
Doom
Kinect
Playstation 4
Playstation 5
Unity
Unreal
XBox
Multimedia
Multimedia
Audio
Image Processing
Video
Audio Video
DirectX
GDI
GDI+
OpenGL
General Programming
General Programming
Algorithms
Compression
Computational Geometry
Emulation
Exceptions
File
Internet
Localization
Memory Management
Optimization
Parser
Performance
Regular Expressions
Sorting
State Machines
Architecture
Design / Graphics
Printing
String
Threads
Usability
Programming Languages
Programming Languages
ASM
Bash
Basic
COBOL
Dart
Go
Haskell
Kotlin
Lua
Pascal
R
Razor
Rust
Scala
Swift
Typescript
Objective C
Visual Basic
VBScript
C++
C#
F#
FORTRAN
Java
Javascript
Perl
Python
Ruby
SQL
PHP
PowerShell
XML
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: 42,174
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,552
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,970
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: 42,205
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,692
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,921
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,565
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,350
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,980
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,351
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,830
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,460
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,781
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,460
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: 104,187
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,170
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: 46,223
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,780
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: 15,032
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: 35,460
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,831
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: 11,002
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,781
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: 88,206
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.