Stack Exchange

Question I have system where my database gets restored every night, and off late the restore is taking a lot longer from past few days. Here is server config: ES 2637 XEON @ 3.5 Ghz Windows virtual server 2012 R2 hosted in a Hyper V … [Read More]

Question At what size should we consider applying Columnstore Index on a table? Is there a SQL Server storage or design guidance? Our Data Warehouse is 5TB total. Additionally, we have tables which are 100GB to 1TB which compose the database. Just curious if SQL … [Read More]

Question I’m stuck in a way that how to do sum on a column let’s say first column of a table (result from another query) without knowing the column name with something like column position id. it’s something like this Or if it’s in single … [Read More]

Question I’m noticing this wait stat on my Azure SQL database, and I’ve never seen it before. I’ve tried Googling this wait stat but haven’t been able to come up with any good information on what this is, although I saw a couple mentions of … [Read More]

Question I have a SQL database that is hosted on Azure. The problem is that the size is getting out of control, I can see up to 99% fragmentation in the Primary Key clustered indexes. I’m able to rebuild all other indexes with online=on option … [Read More]

Question My problem: I have a set of views from which I want to query dynamically. I want to load the view names by SELECT * from sys.all_views into a cursor (let’s call it view_cursor) and then do something like this in a procedure: I … [Read More]

Question This is in relation to a rollback scenario from a 2012 -> 2016 upgrade. The scenario is that the SQL Server 2012 database is restored onto 2016 and log files applied until it is up to date. Then production systems are cut over to … [Read More]

Question Is there a simple way to reconnect a query window that is “not connected” to the original connection that was used by that query without manually picking the server name needed? If I click the Connect button on the SQL Editor toolbar or right … [Read More]

Question I have a two node sql server 2008 r2 cluster that we just did an OS upgrade from windows 2008 r2 to windows 2012 r2, the OS upgrade was done in place so the SQL Server Installation stayed in tack. The cluster role won’t … [Read More]