Question : I have a Database (80GB) that is able to store attachments. These attachments are full text indexed. For […]
Author: admin
What throughput should I expect with MPIO?
Question : Dell PowerEdge 2950 with two 1 Gbps NIC’s going to two 1 Gbps ports on a switch which […]
Extract specific backupfiles from SQL Server 2008 backup
Question : I have a big .bak file containing a full backup and some transaction log backups. Is it possible […]
How to separate Stored Procedures (i.e. all the business logic) from Client Database so that it only contains client data?
Question : Scenario: Our Application Database (in SQL Server 2012) contains entire business logic in the Stored Procedures (SPs). Everytime […]
MySQL 5.6 row format changes when changing storage engine from MyISAM to InnoDB
Question : I am testing an upgrade of all existing MySQL 5.6 tables from MyISAM to InnoDB. I converted all […]
Why do I get The transaction log for database ‘X’ is full due to ‘ACTIVE_TRANSACTION’ w/ Simple Recovery and auto grow log?
Question : Why do I get The transaction log for database ‘X’ is full due to ‘ACTIVE_TRANSACTION’ on a database […]
Find numbers not used in a column
Question : How can I find in a column filled with numbers, the ones that are not used. Table_A: ‘id’ […]
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. […]