Have you ever wondered what the best option is for making your data available in your environment? I was asked by Carlos L Chacon (blog|twitter) to be part of a panel on his podcast for an episode discussing some of the options–availability groups, mirroring, log shipping, and replication. We … [Read More]
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 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]
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]
Copyright © 2024 | Andy Mallon | am2.co