Question I have created a table with 650 Numeric(19,4) columns. When I switch on Page Compression, by running I get Msg 1975, Level 16, State 1Index ‘PK_Mytable’ row length exceeds the maximum permissible length of ‘8060’ bytes. but 650 times 9 bytes is only 5850 … [Read More]
Question I have a vendor solution that uses a sql server (2008r2) database. We are allowed to do anything we want in our own schema, but cannot modify dbo objects without vendor permission. Any customization we make is in our own schema (cust). We have … [Read More]
Question I am just trying to look up more verbose information for a maintenance plan task that failed. I open up the log file viewer and check the box to view the logs for my maintenance plan. There are no active filters besides that in … [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 In our AlwayOn environment I have two SQL servers 2014 Ent.edition (SERVER A, and SERVER B). I setup a transaction replication for [database A ], pointing to listener which shouldn’t cause any issue if a failover happened. Tested, worked just fine after a failover, … [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 In SQL Server, if the Database is in Read_only mode, can we drop/remove unused roles? Please let me know. Thanks in advance asked 2017-04-17 by Bharath Kuamr reddy Answer If a database is in READ_ONLY mode, it is completely read-only. The read-only-ness is not … [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]
Question I just got a Sql Server 2016 Availability Group setup (A Primary, a Syncronous Secondary and a Async Secondary). I have five databases on the servers. I setup an application to run queries against the server (using Entity Framework with a “failover partner” connection … [Read More]
Copyright © 2024 | Andy Mallon | am2.co