Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Help on Ola hallengren script to take a stripped backup only secondary node - Hi All, Need some help on OLA Hallengren's backup stored procedure. We have an 2-node ALWAYS ON setup (node1- primary , node2 - secondary) The credential is setup with name "ProdBackupCredential" which has access key for storage account We have 2 databases which are around 3.5TB in size and want to take a stripped backups […] |
SQL Server 2017 - Development |
query help - Hi All, I have 2 tables. both tables hold db file sizes. I want the difference of sizes using tsql. As of now, I am using excel for this. During prod refresh activity to non-prod environments , we are falling short of drive spaces. So, Checking for script to find size differences using tsql. Providing […] |
SQL Server 2016 - Administration |
Same query returns different number of rows when run by a different login - Hello experts, Does anyone know how the same view query could return a different number of rows depending on which user is running it? I'm facing that issue now. I tried making sure the user in question has SELECT access to the tables in the view. Still different totals. What is strange is a lack […] |
Update Statistics - In AG, mirroring, Log Shipping and Transactional replication if I Update statistics on primary will it run on secondary also? |
SQL Server 2016 - Development and T-SQL |
Help with joining tables - I would like to know whether it is possible to join 2 tables with different sorting. Ex: Table 1 has, id, date, description Table 2 has, id_det, id_mast, amt, price, dt_mev These tables are joined with table1.id = table2.id_mast I need to join the second table sorted by dt_mev descending order, so that the first […] |
No PK on any tables - Need that to enable Change Tracking on SQL Server - We have a vendor application that is now out of our support. We need to extract the data from this source and move it to Snowflake via Fivetran (ETL Tool). Fivetran needs Change Tracking enabled on the source so that it can pick up only the changes since the last cycle. The issue we are […] |
hex conversion - I am trying to convert some numbers pulled from a char field. I would like to pull the 1 and 46 from the 000.001.070.000.0 to return as 1.46 . I tried a couple of things but not quite hitting the mark. create table Models ( Modelid integer, Modelnameid char(17) ); insert into Models values […] |
SQL Server 2019 - Administration |
Using SQL Audit to monitor index create / drop / alter events ? - I'm wanting to use SQL Audit to monitor index create / drop / alter events. I can successfully do this for tables, stored procedures, users, and other objects using DATABASE_OBJECT_CHANGE_GROUP. However, it's not including DDL operations on indexes. Anyone know if this is possible? NOTE: It is possible to use DDL triggers, but I'd rather […] |
SQL server service account to choose - Hi All, We are running on small online web based application and server is workgroup cannot create domain account. Which is best account to the SQL server -- Default it is running under "NT Service\MSSQLSERVER", can I change this is to local service account. Since our server is getting log on failure and hack as […] |
Apply restore to a database with full and differential at different time. - I am trying to test to restore database from prod server to test server. It is a small database. On production server we have full backup at weekend, and then differential at weekday nights, I am using UNC drive to connect to the backup location on production. I can add files of a full backup […] |
SQL Server 2019 - Development |
Issues with creating a foreign key - Hello, my name is Di, and its the second time I wrote a topic for this forum, I am having some issues for writing a query where I need to create a foreign key, I already search on some places at internet, but none of then helped me, can you guys help me? |
Uploading CSV into PosgreSQL - CREATE TABLE movie_data ( id SERIAL Movie_Title VARCHAR (100), Release_date VARCHAR (100), Wikipedia_URL VARCHAR (100), Genre VARCHAR (50), Director_1 VARCHAR (50), Director_2 VARCHAR (50), Cast_1 VARCHAR (100), Cast_2 VARCHAR (100), Cast_3 VARCHAR (100), Cast_4 VARCHAR (100), Cat_5 VARCHAR (100), Budget MONEY (50), Revenue MONEY (50), Primary Key (id) ) |
Amazon AWS and other cloud vendors |
Lambda authorizer and Parameter Store dilemma - I've been using an authorizer in front of all my lambdas. The authorizer simply tries to decode the bearer token received, and if it's decoded correctly, authorizes the integration lambda to execute (and passes the user id to the event). My issue is that I realized I'm spending a lot of money in Parameter Store […] |
General |
SQL 2022 RTM Install - Hi there, I have previously installed SQL 2022 RC1 on a dev server and now i'm looking to upgrade this to the recently released RTM version. I've not yet run through the install yet, however from what i can see this may require a new SQL install or is there an in place upgrade option […] |
Disaster Recovery |
log shipping what if I need transaction logs backup on my primary database. - I am trying to understand log shipping. Try to see if it can be used for our disaster recovery purpose on another location. we will only use the second location when main location has a disaster. I understand we have to stop our regular maintenance plan for transaction log backups otherwise it will be conflict. […] |