Question So I have a bit of a problem with some databases I’m trying to migrate to amazon RDS We have about 20 Databases that are all derivatives of others that all share the same family_guid because they are based on backups of others. The … [Read More]
Question I have a very strange slow insert issue, here I am providing the table structure, and the insert statement used. The database is clean, contains no other tables, no indices, no constraints, no triggers. I tested this on two different machines, with high speed … [Read More]
Question I am querying data from a linked server through a view on the origin server. The view has to include a couple of standardized columns, such as Created, Modified and Deleted, but in this case the table on the source server doesn’t have any … [Read More]
Question Does it ever make sense to have a clustered and non clustered index for the same column I inherited a database and a web service that goes with it. Looking at the indexes for duplicates I see an two indexes that point at the … [Read More]
Question I have 4 tables with dates to which I want to join to a date dimension table but it is returning many duplicates with left joins. Tables are basically a date field which I want to count. These are actually one table with the … [Read More]
vstrien is using the (legacy) SQLPS Powershell module, and running into a bug where importing the module changes your current directory.
Question Using SQL Server Management Studio, open a query window and execute In another window execute I see select @@trancount What’s up with this? Who’s counting transactions? Is this a Management Studio thing? asked 2016-08-12 by Michael J Swart Answer I don’t think it’s a … [Read More]
Question We are planning a migration from current mirroring architecture to Availability Groups for several databases. For every Database we have defined the primary/secondary replica configuration. The question that I’m unsure is: do we need to group the databases with the same primary/secondary configuration into … [Read More]
Question I’m building a stored proc that can take in two separate values that each can be used to identify a single record. One of these values may be null. My logic is as follows: if IN_ORDER_ID is not NULL, save it to V_ORDER_ID. If … [Read More]
Like most people, I’ve changed jobs a few times in my life. My path from teenage grocery store cashier to Database Architect was a complicated and multi-step journey. During that journey, I’ve made some good decisions, and some bad decisions. If you’re like most tech … [Read More]
Copyright © 2025 | Andy Mallon | am2.co