Question : I know that this is a strange requirement but I need to find out database user name(not the […]
Tag: scripting
sync 2 tables in a single database in mysql with no duplicacy [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
How to find out if an index is aligned
Question : I’m struggling to find any confirmation within sql server or sql management studio that my index is in […]
How to schedule PostgreSQL replication?
Question : I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has […]
Easy way to check connectivity to SQL Server from client
Question : For troubleshooting purposes, I would like to be able to check if a client can connect to a […]
how to add data compression to a primary key of a table?
Question : We work with tables with over 300GB of size, a small percentage of them tables use sparse columns […]
Is it possible to allow write-through computed columns for legacy code that expects a column to be read/write?
Question : I have this existing table for IP storage: CREATE TABLE [dbo].[IPAddresses]( [ID] [int] IDENTITY(1,1) NOT NULL, [IPv4Address] [varchar](15) […]
Regularly import tab-seperated log file to MySQL
Question : I’m looking to keep arpwatch entries in a MySQL database to crossreference with other information I’m storing based […]
SQL Server – Must be first statement in query batch – what and why?
Question : I cannot find a list of type of objects that while being created the command must be the […]
View the role assigned to each user (Report Server)
Question : Is there anyway I could list down the roles assigned to each user on the different folders on […]