Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
Index question - We have some indexes we have changed over the last few years to address performance problems. Currently the system is in MySql. But we are planning to do the migration to SQL Server. Not any issues in MySQL. I am thinking of making the changes in SQL Server. Let me know what you think? |
Process to failback after an AG failover using asynchronous mode - I'm testing the failover process in my AG that is using Asynchronous availability mode. In the scenario where I manually failover from Server A (primary) to B, what is the process to fail back to A? It seems like the only way is to rebuild the entire synchronization from B to A, failover to A, […] |
SQL Server 2017 - Development |
Stored Proc with OPENJSON: How to determine insert or update? - This is my 1st attempt at openjson & I'm trying to setup a stored proc that passes in multiple records and either inserts or updates the record in the table. I can setup the basic insert or update query using my openjson, however I don't know how to determine if the current record needs to […] |
Question about Data Warehouse - Hello. I just rejoined SQL Server Central. I'm here because I'm a solo reports developer for a small business. I use SSRS, Tableau and QlikSense to develop reports and dashboards. I also write complex stored procedures to produce the datasets that I need. These Forums are the only places where I can ask questions or […] |
SQL Server 2016 - Administration |
Looking for good beginner Data Base Administration book for advanced developer - Hello SSC, I have been a SQL developer for close to 20 years. I know some DBA tasks like, backup restore, installation, granting access to users, etc. I have been trying to find a beginners book that can slowly walk me through all of the common administration tasks. I think like a developer, so topics […] |
Login to SQL Server cross domain AD Group user - Our MS SQL Server is on another trusted domain (Trusted Domain T). We created a Universal Group within Domain A with users from different forest domains and added the AD group onto the SQL Server. When the user from Child Domain B tries to connect, they get the error: "Login failed for user". If I […] |
SQL Server 2016 - Development and T-SQL |
table variable - deleted code resolved issue |
product version result - SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I need to find the most recent hotfixes applied on a server. Is 4001 the most recent hotfix applied 13 signifies sql 2016 First '0' is it sp1 ?? And what the last '0' signify ? SELECT substring(SERVERPROPERTY ('ProductVersion'),6,4)..this results in an error . […] |
Help Writing a Udf that get Number of "Years in a row" - Hello. I have a table (say orderlines) with orderrows, There is a column that holds the "Year" of the orderline. I like to write a userdefine function that calculate how many years in a row that item has been sold from today and back. For examle : If I in the table have: […] |
Administration - SQL Server 2014 |
SQL changing what index it uses - Hi, I have a database that has many inserts and was using a specific index and was humming along quite nicely. Then all of a sudden it stopped using that index and everything grinded to a holt. No changes were made on the database and it just suddenly happened at 4:21am. How or why would […] |
Cannot remove growth restriction from log files - I have an instance where I have sysadmins. There a number of databases created by users and also msdb where I am unable to set log file growth to unlimited. It seems that when I change the setting all is OK but on checking back it has reverted to limited. I have altered the setting […] |
Development - SQL Server 2014 |
Comparing consecutive datetime rows for schedules - @Grant Fletcher and @Michael L John. As suggested I looked up the backupset tables and I think we can still come up with schedules and timings for all databases and their respective kind of backups if we can use most recent sample data (last 30 days) assuming there is only one process(sql or 3rd party) […] |
SQL Server 2019 - Development |
Getting the top unique value by group - Alright, so I've been banging my head against the wall for a bit on this one, trying to avoid my developers going RBAR. We have two tables, and are trying to populate a third table by selecting the first available processing number for each ID. The two tables are joined like this: TABLE1.ID Table2.Processingnumber 1234 […] |
Azure Data Factory |
Using ADF Data Flow Derived Column transform against nested Delta structures - I'm trying (without success) to use a derived column transform within an ADF Data Flow where I've ingested a Delta table with nested structures. I'm struggling with the syntax needed to flatten out these structures and no column info is displayed despite me being able to preview the data. I thought I'd be able to […] |
Analysis Services |
Import a PBIX file into Azure Analysis Services - I want to import a Power BI PBIX file into Azure Analysis Services. I don't see any recent information on how to do that. Is it possible? If so, how? |