Stack Exchange Archives - Page 15 of 17 - Andy M Mallon

PowerShell can’t see network locations after SQLPS module is loaded

August 15, 2016 Andy 0

vstrien is using the (legacy) SQLPS Powershell module, and running into a bug where importing the module changes your current directory.

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]

Exclude All Matching Rows

April 8, 2016 Andy 0

Question I have a table that has a unique ID, name, email, and some other fields. I want to match this table against another table on email, but sometimes emails are shared. The unique ID is not shared among tables, but I will input the … [Read More]

Convert row into concatenated string with column names included

April 6, 2016 Andy 0

Question I have a table that is several hundred columns wide. Is there a way to convert each row into a single concatenated string with the column title included without having to list each single column in the query? I’m doing this because the columns … [Read More]

SQL Server: How to export database with linked servers

April 4, 2016 Andy 0

Question I’m a web developer and I want to export a database to work on it in my local machine. I’m using generate script with data. the script is generated but without the linked servers used by some Views. Is their a way to generate … [Read More]