Posted inBaseline-SQL-Server Errors SQL Alerts
Find TempDb Space Consumers in SQL Server
Troubleshoot SQL Server tempdb database space issue and find out what sessions are consuming tempdb space.
Posted inLinux
SQL Server on Linux Mint
Why Linux? To start with, I think everyone agrees that Linux is core skills, and no doubt every IT professional should be familiar with it. Almost all enterprise software solutions…
Posted inTSQL
Get Decimal Scale Based on Variable Value
In recent past, while designing a report mailer I faced a requirement where I had to convert a float column into DECIMAL with dynamic precision value coming from outside of…
Posted inPerformance Tuning TSQL
Relationship data in Easy Way
Recently I worked on one optimisation job. It was procedure that processed multi-relationship data provided by clients in excel format, and created relationship tables. For example data like :- 1)…