Browse the archive
Question I have like 20 Listners on 2014 with approx 500 DBS, what is the best way to migrate these with least downtime, effort My idea is: Stop access Backup dbs Start restore dbs While restore is running: Drop AOG on 2014 Create it on 2016 Done
Continue readingHave 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, …
Continue readingQuestion 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 problem is that …
Continue readingQuestion 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 …
Continue readingQuestion 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 suitable …
Continue readingQuestion 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 same column (1 column and …
Continue readingQuestion 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. mdate datetime, mordate varchar(10),fteam varchar(20) sdate …
Continue readingQuestion Using SQL Server Management Studio, open a query window and execute BEGIN TRAN In another window execute select [text], from sys.sysprocesses cross apply sys.dm_exec_sql_text(sql_handle) where status = 'sleeping' and open_tran = 1 I see select …
Continue readingQuestion 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 …
Continue readingQuestion 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 it is NULL, then …
Continue reading
