" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi
Home
Database Tips and Tricks
How to reuse query execution plan?
User friendly DATETIME Functions in SQL Server 2008
Get Record Count of a table in SQL Server without doing a Table Scan
Avoiding the use of Triggers in SQL Server
SQL Server Update Statistics
How to use the Transact-SQL functions CONTAINSTABLE and CONTAINS to do a search on a full-text enabled table
How to use double quotes in dynamic SQL statements
How to insert more than one record using a single insert statement
Using Inner Cursor in MySQL
Some Useful Date Time conversion Tips in SQL
How to INSERT, UPDATE or DELETE record in one statement
Advantage of sp_executesql over Exec
Transact-SQL :- ROW_NUMBER()
New Line character and Forming a comma Separated String in SQL Server
Capture identity values while inserting multiple rows in Sql Server 2005
Bulk Copy with Oracle using Array Binding
MySQL: Ordering values according to a predefined pattern
How to use a comma seperated list as paramater to a stored procedure
How to display tabular data in CLR proc
Set the Recovery model of the database to Simple/Full
Consuming No space for storing NULL value in table
Which one to use in a SQL query:-“Not Exists”/ Left Join / Not In”?
How to relocate database from C#.NET (SQL Server 2000)
How to create temporary table in MySQL
Use of cross apply to show ‘,’ separated values(SQL Server)
Importance of Max Degree of Parallelism in SQL Server
SqlServer Query Optimization Tips
MYSQL:Ordering A TextField Numerically
How to add dynamic data in to the SQL Report header and footer
MySQL: Filter or Search Records Using Regular Expression
Making Inserts into from one table to another table excluding duplicates – without using cursor / temp table/ loop
SQL Server : Multiple record insert
Get database connection string using UDL files
How To Set Page Break in a report Conditionally
MySQL: How to get the Particular Data Range
MySQL : Exporting The Resultset of a Table into CSV File
SQL Server: Restrict the duplicate insertion of records to the database using Store Procedure
Run the existing SQL Script programmatically with SMO
Deleting Duplicate records in SQL Server
Forming Comma Separated String in SQL Server
Using Having clause with Count function in SQL
T- SQL: Query with case-sensitve functionality
How to create folders in SQLReport server dynamically ?
MSSQL-Insert records for columns where IDENTITY is set
How to backup and restore MySQL database.
Top with ties option in SQL Server
T-SQL: Finding Top and Bottom records
How to select Random rows in SQL Server using TABLESAMPLE
Store data temporarily on your page and finally insert it into database
Avoid Causing havoc with Live Site/DB
Selecting records from more than One Database Using Single Query
How to use UPDATE with JOIN in SQL queries
MySQL: Implementing case-sensitive functionality in query
Display summary report using a simple query in MYSQL
SQLSERVER Transaction rollback
MySQL: Using “ON DUPLICATE KEY UPDATE” while inserting record
Using Regular Expressions with MySQL queries to Search
TRY- CATCH in SQL SERVER 2005/2008
How to get the Deleted Identity Numbers in SQL Server 2005
Backup SQL Database Through Code In VB.NET
Replace function in MySQL
Get list of existing TRIGGERs in MYSQL
Renaming Database Objects
How to Escape Wildcard Characters While Searching in SQL Server
How to swap data between columns in SQL Server
Using SQL JOIN to get data from different tables conditionally
Why not to use TEXT data type in SQL Server 2000
SET and SELECT in SQL Server
Retrieving List of DB created by user from SQL Express 2005
Executing SSIS package from local machine using C# code
Dealing with NULL values in SQL Server
DATALENGTH() AND LEN()
Using “WITH TIES” SQL Clause
How to copy data to an identical table in another database
Using CASE expression in SQL queries
Make Your “Order By” Clause Dynamic
Fixing Reporting System UI issue in IE8
DateTime Mystery In SQL Server
How to return Modified data in SQL Server
Think Before Using ‘Distinct’ Command Arbitarily
How to find DB size and table info in MYSQL
Sort data according to value of two columns
MYSQL Binary Logs And Purge
Using BINARY function in MySQL for case sensitive search
INSERT, UPADTE or DELETE a row and return column/columns value with single query
INSERT data from one table into another
SQL Server Index – IV (Composite and Covering Index)
SQLServer Index – III (Non-Clustered Index)
SQL Server Index – II (Clustered Index)
SQL Server Index – I (Basics)
How to update field values partially in MySQL UPDATE statement?
SQL Server Index – V (Index Fragmentation)
Search datetime data in SQL Server (using ‘where’ clause?)
Difference between @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT() in SQL SERVER
Count affected rows after SQL Query Statement
XML DataType in SQL Server 2005
Using Pivot Operator in SQL- Server
Access data from remote database server using FEDERATED Storage Engine in MySQL 5.0 and up
Difference between utf8_general_ci and utf8_unicode_ci
Find Stored Procedure (s)/Function(s) related to a Table(s) in Database
EXPLAIN your query in MySQL
How to use Transaction in Entity FrameWork?
Table variables in SQL Server
Using FIELD function in ORDER BY clause in MySQL
Fetch Nth Column of a Table
Common Table Expression in SQL Server
Stored Procedure execution using MySQL Extension
Creating and inserting data to a table using the SELECT statement
How to add row number in a query result set.
How to find the engines of MySQL tables
Deleting Duplicate Data In MySQL
Temporary Tables or Table Variables: Choose One!
Printing the query executed last by codeigniter framework using active record class
Calculate Geographical Area using SQL Server
Limiting the retrieval of data in SQL Server 2008
Use Stored Procedure’s result set in Inline Query or in another stored procedure
How to find those tables which do not have any auto-incremental column in SQL Server
Physical Mysql – what are these? (.FRM, .MYI, .MYD). Need this?
How to delete duplicate rows in a table using CTE
How to configure C3P0 connection pooling in Hibernate
How to drop primary key constraint in SQL Server
How to preserve SQLite db in AIR application uninstallation/reinstallation
Remove Multiple Spaces from a string using SQL Server
Sending Email in Oracle/plSql
Dynamic Where Clause
Configuring MSSQL Server to talk to PHP in Ubuntu
How To Encrypt All Store Procedure In SQL Server Database
How to take backup of SQL Server database schedule wise
Secure Way Of Executing The Update Statement In Sql Server
Display Dates In A Range
Extended Properties for Documenting the SqlServer Database
How To Make A Case Sensitive SQL Query Search
Execute sql stored procedure or sql query from Access.
Reset the identity column next inserting identity value.
Self join and its usage
SQL Query Optimization
GO (Transact-SQL)
Swap table name in MySQL, SQL Server
Some Useful SQL Queries
Empty or Shrink the database
Screen all incoming query-strings to prevent SQL injection
Use of SET NOCOUNT in stored procedures
Some Interesting features of ENUM data type in MySQL
Using =null instead of isnull
Automatic Database(MySQL) backup
Right Join Using Left Join Clause
UpsizingWizard to migrate an AccessDB to SQL
Getting List Of tables With Number Of Records Of Each In SQL Server
