Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
30 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 1
Page Size: 10 · 25 · 50

Author filtered by: aasim abdullah [x]
Tip/Trick 19 Apr 2013   license: CPOL
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.
SQL2005SQL-ServerSQL-ServerSQL2008SQL2012
Tip/Trick 19 Apr 2013   license: CPOL
Restore failure from Enterprise to Standard edition in SQL Server.
SQL2005SQL-ServerSQL-ServerSQL2008
Tip/Trick 19 Apr 2013   license: CPOL
Automatic query execution at every instance startup.
SQL2005SQL-ServerDBASQL-ServerSQL2008SQL2012
Technical Blog 9 Jan 2013   license: CPOL
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
SQL-ServerDBAIntermediateSQL-ServerSQL2008SQL2012
Technical Blog 30 Dec 2012   license: CPOL
Three common DDL change log methods for SQL Server.
SQL-Server
Tip/Trick 1 Nov 2012   license: CPOL
You have place indexes but still queries are slow... who so.. are you facing bookmark lookup problem ???
SQL2005SQL-ServerSQL-ServerSQL2008SQL2012
Tip/Trick 1 Nov 2012   license: CPOL
A stored procedure can be called from another stored procedure as nested stored procedure. How to get list of these stored procedures with their nested one
SQL2005SQL-ServerSQL-ServerSQL2008
Tip/Trick 24 Oct 2012   license: CPOL
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.
SQL2005SQL-ServerSQL-ServerSQL2008SQL2012
Tip/Trick 23 Oct 2012   license: CPOL
How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.
SQL2005SQL-ServerSQL-ServerSQL2008SQL2012
Re: Execution Plan by aasim abdullah
Forum Message 23 Oct 2012  
Why you don't like to start with SQL Query Optimiza
Technical Blog 22 Oct 2012   license: CPOL
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.
SQL2005SQL-Server
Tip/Trick 20 Oct 2012   license: CPOL
Intellisense in SQL Server 2008 is a time saving feature. But sometime writing queries it start underlining some objects names or some columns names which are already added in database and these are correct but intellisense mark them as a MISTAKE.
SQL-ServerSQL-ServerSQL2008
Re: My vote of 1 by aasim abdullah
Forum Message 2 Oct 2012  
Its a warning! that SQL Server will not generate an error at the begining of restore (like it do for other reasons). And it you have planned to restored a multi Giga/Tera Bytes database, then after h
Tip/Trick 2 Oct 2012   license: CPOL
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-ServerSQL-ServerSQL2008
Tip/Trick 2 Oct 2012   license: CPOL
A simple query to get all databases size on a given instance.
SQL2005SQLSQL-ServerSQL-ServerSQL2008
Tip/Trick 1 Oct 2012   license: CPOL
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 ??
SQL2005SQLDBADevIntermediateSQL-ServerSQL2008SQL2012
My vote of 4 by aasim abdullah
Forum Message 1 Oct 2012  
Yeah i was confused too ;)
Good One by aasim abdullah
Forum Message 1 Oct 2012  
Learned somthing, thanks Arunprasath
Forum Message 19 Sep 2012  
wow, its really kooool.
Technical Blog 17 Sep 2012   license: CPOL
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.
SQL2005SQL-ServerSQL-ServerSQL2008
Tip/Trick 17 Sep 2012   license: CPOL
Get all indexes list in detail, with their involved columns
SQL2005SQLSQL-ServerSQL-ServerSQL2008
Technical Blog 17 Sep 2012   license: CPOL
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
SQL2005SQL-ServerSQL-ServerSQL2008
Technical Blog 17 Sep 2012   license: CPOL
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
SQL2005SQL-ServerSQL-ServerSQL2008
Technical Blog 16 Sep 2012   license: CPOL
How to apply filter on sp_MSforeachDB
SQL2005SQL-ServerSQL-ServerSQL2008
Technical Blog 15 Sep 2012   license: CPOL
How to control SQL Server Log Information
SQL2005SQL-ServerSQL-ServerSQL2008SQL2012
Technical Blog 15 Sep 2012   license: CPOL
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
C++WindowsATL
Re: Not an article. by aasim abdullah
Technical Blog 12 Sep 2012   license: CPOL
A simple way to swap column values.
SQLWindowsSQL-ServerDevBeginner
Technical Blog 12 Sep 2012   license: CPOL
Why we should avoid the NOLOCK table Hint in DELETE/UPDATE queries.
SQLSQL-ServerATLDevIntermediate
Technical Blog 12 Sep 2012   license: CPOL
To find out whose birthday is coming in a given number of days is very simple.
SQLSQL-ServerATLDevIntermediate
Page 1 of 1
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web01 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid