Browse the archive
Question We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something like this below in Project References. We need Project references, since Otherdatabase, can choose between two options at our …
Continue readingQuestion 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
Continue readingQuestion 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 full …
Continue readingQuestion 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 …
Continue readingQuestion In SQL Server, if the Database is in Read_only mode, can we drop/remove unused roles? Please let me know. Thanks in advance Asked2017-04-17byBharath Kuamr reddy Answer If a database is in READ_ONLY mode, it is completely read-only. The read-only-ness …
Continue readingQuestion 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 we shrink the data file.
Continue readingQuestion I am having trouble getting a trigger to work. What it needs to do is to prevent any customer with last name Glass from being inserted into the database. This is what I have: CREATE TRIGGER no_last_name_glass_trg ON customer AFTER INSERT,UPDATE AS …
Continue readingQuestion We have the ApplicationIntent=ReadOnly properly routing our users to the Secondary ReadOnly replica. Is there a way to make this the default behavior? Apparently the default behavior seems to be ReadWrite, and if you don't specify an …
Continue readingQuestion 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 join my require table, I need …
Continue readingQuestion 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 problem is that …
Continue reading
