Stack Exchange Archives - Page 7 of 9 - Andy M Mallon

Releasing free space in mdf file to OS

April 10, 2017 Andy 0

Question We have a 120GB database. There was table with 60GB of data which is useless and we have truncated it. Now database size is 120GB with free space 60GB. The database will not grow up to 60GB in at least 3 months. So can … [Read More]

Why do I have to backup a transaction log twice for it to shrink?

April 7, 2017 Andy 0

Question This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink the log file – that is not the question. If you feel like answering that one should not do it- that has been confirmed many times … [Read More]

Transaction log is growing very fast

April 5, 2017 Andy 0

Question One of our SQL Server 2014 database transaction logs is growing very fast and I cannot find the root cause for this. Database in Simple recovery mode. During full backup the log file grows to its limits (800GB) and backup fails. I checked the … [Read More]

Risks of manual failover in Always On Availability Groups

February 9, 2017 Andy 0

Question In my environment, I have SQL 2014 with Always On Availability Group for databases in asynchronous with manual fail over. We have 1 primary and 2 secondary replicas–secondary1 and sec2. I have to do failover from primary to secondary1. I know some data loss … [Read More]

SQL Agent Job Logs – Can’t get the Error Log

January 25, 2017 Andy 0

Question I’ve some logs that I want to extract to a report in order to get the SQL_Agent_Jobs status that runs during the night. If the Job fails then I want to receive the Error Log in a table. I am trying to get that … [Read More]

Nonclustered index storage on clustered columnstore

January 6, 2017 Andy 0

Question In SQL Server, a non-unique nonclustered index on a rowstore table incorporates the base object’s bookmark (RID or clustering key) at all levels of the nonclustered index structure. The bookmark is stored as part of the nonclustered index key at all index levels. On … [Read More]

Does the ‘reads’ column in SQL Profiler mean the same as IOPS?

December 21, 2016 Andy 0

Question I just executed a query that went pretty fast and the SQL Profiler said it used 30.000 reads. Now I’m looking at this page: https://cloud.google.com/compute/docs/disks/performance and see that a standard persistent disk has 3000 reads IOPS. Does that mean that my query would take … [Read More]

How to add 1100 columns in SQL Server

December 4, 2016 Andy 0

Question I need 1100 columns in a single table.I already have 928 columns in same table, now I need to add new 150 columns. I know SQL Server allow maximum 1024 columns. Now I will not create new table. If I create new table and … [Read More]

Is it possible to change the family_guid in MSSQL?

August 24, 2016 Andy 0

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 … [Read More]

Why is this explicit cast causing problems only with a Linked Server?

August 17, 2016 Andy 0

Question 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 … [Read More]