Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Looking for guidance on perf issue - Hi All, Need some guidance here. We have multiple integrations with our centralized data warehouse database. Recently, a new application got integrated and management has defined an SLA of 2secs for every query coming from that application. Its kind of an API call. Now, that particular team is complaining that sometimes the api calls are […] |
misleading blocking - Hi All, I came across a blocking scenario where everyone thinks its SELECT is blocking the UPDATE operation but it's not true. The DMVs are showing up only current batch or current sql text which was executed. My question: How to prove its not the SELECT but its the DML update which took the 'X' […] |
logon failed for user sa - Hello Immediately before running the daily backup created in SQL Server Configuration Manager, login errors appear in the SA account, but the system informs that the backups ended successfully. The sql agent service account, is a domain administration account, which is sysadmin. Must I configure this account owner of the databases? This situation is related […] |
Move database amd log to another disk - Sql 2017 Std installed on a windows 2012 R2 server which is a domain controller. I do not use replicas. The databases aren't participating in an Availability Group. Goodnight First of all, please be patient with me. I'm new to this subject of sql I need to move 5 databases from one disk to a […] |
SQL Server 2017 - Development |
begin tran vs WITH(ROWLOCK) - Hi , when begin transaction and update holds lock on row and no other can update if unless committed, why and what is the purpose of "WITH(ROWLOCK) " ?as per internet both looks same UPDATE transak WITH(ROWLOCK) SET Col1 = 1 ,col2=2 where col3=1; BEGIN TRANSACTION UPDATE transak SET Col1 = 1 ,col2=2 where […] |
Administration - SQL Server 2014 |
DBCC CHECKDB and Backup Database - Hello. Are there any references to running DBCC CHECKDB and/or Backup Database concurrently against different databses in the same SQL Instance? My searches are turning up discussions against concurrent activities against the same DB. DBCC CHECKDB is resource intensive (in terms of Memory) but Backup Database seemingly is not - other than IOPS. It does […] |
Development - SQL Server 2014 |
Need to do a mass update - taking days - Hi I need to anonymize some of our members for an outward facing demo web site. Long ugly story, but basically it has to be a mass update of our existing (restored copy) data. Problem is I don't have much disk space so I am trying to batch them in. If I do an update […] |
SQL Server 2019 - Administration |
Find all server level permissions assigned to user defined SERVER roles - Please help me with a T-SQL for finding all server level permissions assigned to user defined SERVER roles such as VIEW ANY DATABASE, VIEW SERVER STATE, SHUTDOWN, ETC. For example, in the screenshot attached, for the test role, it has VIEW ANY DATABASE. what's the T-SQL to find the permissions for test server role. Thanks |
SQL Server 2019 - Development |
options for querying external data sources from SQL Server - is there a good introductory article somewhere that covers the various options for querying data outside of SQL Server, like OPENROWSET(), BULK IMPORT, etc and when to use each one? (Ideally a tutorial, but I'll take what I can get!). I did search, but it's harder to find stuff if you don't know exactly what […] |
Trying to get results back from 12 month ago thru 18 months ago from todays date - So today's date is 2/11/2022 so my results should be from 2/11/2022 and 8/11/2021. SELECT oi.Name as ItemAssignedBranch, col.Name as CollectionName, cir.MaterialTypeID, cir.Barcode as ItemBarcode, ird.CallNumber, br.BrowseAuthor, br.BrowseTitle, cir.FirstAvailableDate, cir.LifetimeCircCount as ItemLifetimeCircCount FROM Polaris.CircItemRecords cir inner join Polaris.ItemRecordDetails ird on (cir.ItemRecordID = ird.ItemRecordID) left join Polaris.Collections col on (cir.AssignedCollectionID = col.CollectionID) inner join Polaris.BibliographicRecords br […] |
Operating System Error on Bulk Insert - Hello everyone, it's my first post here, and I'm no expert on SQL, so I hope you're able to help, and will forgive my ignorance, I'm keen to learn! I'm trying to import around 100 txt files into a SQL table, for processing ahead of bringing into PowerBI. I've built a query, and a layout […] |
SQL Server 2008 - General |
Is there a way to have SQL Server be aware of a new file? - Every weekday we receive a file which under normal circumstances gets processed by a SQL Job that runs on a schedule at 7 AM. It's worked this way for years. This file is produced by a partner, who uploads it to a secure FTP site. However, for the last several weeks the file has either […] |
Amazon AWS and other cloud vendors |
How can I access EC2 instances in a private subnet without using SSM? - Hi, I would like to access my EC2 instances over SSH, which are currently in a private subnet. I was considering a NAT GW, but then I would have to create an IGW too, and that would defeat the purpose of my efforts (to keep the instances private and locked down). Is there any other […] |
General Cloud Computing Questions |
Request for suggestion on data transfer from on-premises to cloud - I've been working for quite some time with AWS but only on limited services there (up to 10-15 services). Currently, I've got a request from a friend of mine who owns a small clinic (around 90 employees) that wants to move the patient data from on-premises to the cloud. I have some knowledge of AWS […] |
SQLServerCentral.com Website Issues |
Warning prompt when writing a reply - When I wrote this reply https://www.sqlservercentral.com/forums/topic/sql-server-database-redunduncy#post-4148195 and pressed submit I got an error "Are you sure you want to do that?" I could be missing the obvious but I'm not sure why the website queried my post? Possibly it's looking at language and it thought my post had a negative tone to it? Unless I'm […] |