DBA Stack Exchange Archives - Page 13 of 15 - Andy M Mallon

Is it possible to change the family_guid in MSSQL?

August 24, 2016 Andy 0

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]

SQL Server 2014 slow insert

August 24, 2016 Andy 0

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]

Why is this explicit cast causing problems only with a Linked Server?

August 17, 2016 Andy 0

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]

Does it ever make sense to have a clustered and non clustered index for the same column

August 16, 2016 Andy 0

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]

Why is sql_text “select @@trancount” in open but sleeping transaction?

August 12, 2016 Andy 0

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]

What is the benefit of having multiple databases in the same Availability Group vs single AG per database

August 8, 2016 Andy 0

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]

Will a SELECT . . . INTO use short-circuit evaluation for a COALESCE?

August 2, 2016 Andy 0

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]

Microsoft sql server management studio (SSMS) shortcut for changing size of sql/result panes

May 16, 2016 Andy 0

Question In the good old days there was a shortcut ctrl-B for changing the size of the Query & Result panes in the Query Analyzer sql editor. In Query Analyzer, just press ctrl-B and the screen splitter handle was in focus. Then repeatedly press up/down … [Read More]

Users in SQL Server cluster

April 12, 2016 Andy 0

Question I have created a 2012 WFC and SQL Server 2014 is clustered on it. The cluster works as expected but have a question on Users: I added a windows domain group to the cluster as sysadmin. When the user tries to log into SQL … [Read More]

ReportServerTempDB in AlwaysOn Availability group

April 11, 2016 Andy 0

Question ReportserverTempdb logfile is 6TB in size and growing and I need help. I am supporting a huge reporting server farm and the client wants reporting services to be in AlawysON Availability group(AAG) and we configured reportserver and reportserverTempDB on in three node Primary replica, … [Read More]