contact
blog
portfolio
services
MSSQL
Blog
Total blog posts
25
MSSQL - the first step into data analysis using SELECT statement
May 31, 2021
null
MSSQL - implementing a discount formula in an ordering process
Jan 12, 2021
null
MSSQL - enable or disable the auto-close feature for all databases
Nov 28, 2019
null
MSSQL - loop through all records in a temporary working table
Oct 18, 2019
null
MSSQL - looking for the missing index
Sep 19, 2019
null
MSSQL - fix the recovery database state manually
Sep 14, 2019
null
MSSQL - running the same stored procedure sequentially using mutex
Oct 26, 2018
null
MSSQL - manually put the request into sleep for x minutes
Dec 22, 2016
null
MSSQL - write dynamic query to avoid unnecessary criteria
Oct 15, 2013
null
MSSQL - concatenate all records into one line text
Feb 21, 2013
null
MSSQL - create user reminder or notification and keep the record
Oct 8, 2012
null
MSSQL - benefits of using stored procedure and function
Oct 1, 2012
null
MSSQL - generate a series of records with CTE
Sep 27, 2012
null
MSSQL - load the system settings by stored procedure or function
Sep 20, 2012
null
MSSQL - ensure that the process is not running more than once
Aug 28, 2012
null
A universal way on designing a better reporting process
Aug 7, 2012
null
MSSQL - centralize the application log for troubleshooting
Jul 24, 2012
null
MSSQL - design a custom mail process
Jul 17, 2012
null
A universal way to design a stoppable long running process
Jul 10, 2012
null
A universal way to track the progress of a long run process
Jul 3, 2012
null
Our universal stored procedure development guideline
Jun 26, 2012
null
MSSQL - the choice on using uniqueidentifier for Primary key
Jun 20, 2012
null
MSSQL - throw an error in stored procedure and catch by C#
Jun 5, 2012
null
MSSQL - Returning paginated records to reduce the network payload
Dec 22, 2011
null
MSSQl - rebuilding indexes to maintain the query performance
May 24 2010
null
[ 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 ]