contact
blog
portfolio
services
MSSQL
Blog
Total blog posts
25
MSSQL - the first step into data analysis using SELECT statement
31th May 2021
null
[ read more ]
MSSQL - Implementing a discount formula in an ordering process
12th Jan 2021
null
[ read more ]
MSSQL - enable or disable the auto-close feature for all databases
28th Nov 2019
null
[ read more ]
MSSQL - Loop through all records in a temporary working table
18th Oct 2019
null
[ read more ]
MSSQL - Looking for the missing index
19th Sep 2019
null
[ read more ]
MSSQL - Fix the recovery database state manually
14th Sep 2019
null
[ read more ]
MSSQL - Running the same stored procedure sequentially using mutex
26th Oct 2018
null
[ read more ]
MSSQL - manually put the request into sleep for x minutes
22nd Dec 2016
null
[ read more ]
MSSQL - Write dynamic query to avoid unnecessary criteria
15th Oct 2013
null
[ read more ]
MSSQL - Concatenate all records into one line text
21st Feb 2013
null
[ read more ]
MSSQL - Create user reminder or notification and keep the record
8th Oct 2012
null
[ read more ]
MSSQL - Benefits of using stored procedure and function
1st Oct 2012
null
[ read more ]
MSSQL - Generate a series of records with CTE
27th Sep 2012
null
[ read more ]
MSSQL - Load the system settings by stored procedure or function
20th Sep 2012
null
[ read more ]
MSSQL - Ensure that the process is not running more than once
28th Aug 2012
null
[ read more ]
A universal way on designing a better reporting process
7th Aug 2012
null
[ read more ]
MSSQL - centralize the application log for troubleshooting
24th Jul 2012
null
[ read more ]
MSSQL - Design a custom mail process
17th Jul 2012
null
[ read more ]
A universal way to design a stoppable long running process
10th Jul 2012
null
[ read more ]
A universal way to track the progress of a long run process
3rd Jul 2012
null
[ read more ]
Our universal stored procedure development guideline
26th Jun 2012
null
[ read more ]
MSSQL - the choice on using uniqueidentifier for Primary key
20th Jun 2012
null
[ read more ]
MSSQL - Throw an error in stored procedure and catch by C#
5th Jun 2012
null
[ read more ]
MSSQL - Returning paginated records to reduce the network payload
22nd Dec 2011
null
[ read more ]
MSSQl - Rebuilding indexes to maintain the query performance
24th May 2010
null
[ read more ]
[ Back to main blog ]
[ Find more at App DEV blog ]
[ Find more at JavaScript blog ]
[ Find more at Node.js blog ]
[ Find more at Powershell blog ]
[ Find more at Ubuntu blog ]
[ Find more at System design blog ]
[ Our recent activity ]
Curious on what we have done?
[ View our portfolio ]
If you are looking for a customized software solution,
[ Get in touch with us ]