Question : How can I find in a column filled with numbers, the ones that are not used. Table_A: ‘id’ […]
Author: admin
Raising an Alert with THROW
Question : It seems to me that SQL THROW is missing a crucial feature that RAISERROR has, and that is […]
SSDT publish multiple referenced database projects to new instance
Question : I am going through the process of importing our existing SQL Server databases into SQL Server Data Tools […]
Performance hit with column alias
Question : I have a database in SQL Server 2008, with the final data table having about 2 million rows. […]
Does a view need its own foreign key constraints?
Question : Disclaimer: I’m a programmer, not a DBA, so bear with me… I have a view that I use […]
How to use an integer pivot in SQL Server?
Question : I want to get multiples rows using a pivot: FIXED | 0 1 2 3 4 —- —- […]
Combination Identifier
Question : I want to identify in one column those who are present in the data but there is limit […]
How to change data location on Ubuntu
Question : I already saw this question here: https://stackoverflow.com/questions/1795176/change-mysql-data-directory but it’s not very helpful. What I want: to move my […]
MySQL Front – Workbench
Question : We have MySQL Front installed in our server, I can connect to it with no problems, there is […]
SQL Server Long Running Transaction – WAITFOR(RECEIVE conversation….DatabaseMail)
Question : I have recently implemented an Agent Job which checks SQL Server every 10mins for any long running queries […]