Browse the archive
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 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 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 readingQuestion 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 …
Continue readingQuestion 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 on the active server the …
Continue readingQuestion 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 …
Continue reading
