Question : i followed this guide to update my mysql form 5.1 to 5.5. After lots and lots of command […]
Author: admin
sp_BlitzIndex — ‘High value” vs ‘High Impact’
Question : Sorry, I may be missing something super-obvious here, but I’ve googled this and asked some colleagues and am […]
Optimize IN clause in where query with order by – MySQL
Question : I am trying to optimize a query that using IN clause in WHERE to avoid file sorting. To […]
Where is SQLCMD.EXE in SQL Server 2014 LocalDB or how to install it?
Question : On a machine with SQL Server LocalDB 2014 installed I am looking for SQLCMD.EXE file but cannot find […]
FIFO queue table for multiple workers in SQL Server
Question : I was attempting to answer the following stackoverflow question: What SQL Server 2005/2008 locking approach should I use […]
Most efficient way to structure segmented data
Question : I am faced with a set of data which I am currently unsure on how to store efficiently. […]
should I shrink the filegroup? how? SQL Server
Question : I just have a question. We recently purged 1,5 millions of record from a table. The Current allocated […]
How to find an entry from filtering with two associated tables
Question : This questions has spinned off of another question I probably did not ask correctly from the get go. […]
sql indexing and performance
Question : I am using mysql5.1, i have table which has about 15 lakh (1.5 million) records.This table has records […]
Always Encrypted column validation
Question : How can I validate a SSN column that is encrypted in a table using AE without passing one […]