Stack Exchange

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 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’m trying to balance read traffic between two SQL Server 2016 Enterprise Edition instances (Primary and Secondary) using availability groups and the read only routing. Here is my current setup: The servers are in AWS in two different AZ The servers are in a … [Read More]

Question I have a powershell script that I am trying to add in to a sql agent job, but the job step is failing with the following error A job step received an error at line 1 in a PowerShell script. The corresponding line is … [Read More]

Question I am using SQL Server Express edition, so there is no features for backup plan, I want to take databases backup using bat script, and create a scheduler to be run everyday. I have created .bat file but need to place a time stamp … [Read More]

Question Let’s imagine a stored procedure that retreives data and do some kind of pagination. This procedure has some inputs describing which set of data we want and how we sort it. Here is a very simple query, but let’s take it as an example. … [Read More]