Stack Exchange

Question I am a new DBA at a company that has never had a DBA before me. SQL Servers are never upgraded unless it is part of a Windows Update on the server. Service Packs (or CUs) are never installed. We have a mix of … [Read More]

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]

Question What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology or is there anything similar in MySQL that can act as AE? asked 2016-12-20 by dwkd Answer The Always Encrypted feature provides end-to-end encryption, which encrypts data both in-flight, and at rest. … [Read More]

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]

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]

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

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]