|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The A in ACID | |
What does the A in ACID stand for when related to relational databases? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Azure Serverless Compute Cost If my Azure Serverless database is paused from no activity, do I incur a compute cost? Answer: No Explanation: There is no compute cost when the database is paused. Ref: Azure SQL Database serverless - https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Query XML for Dummies - I am trying to learn Extended Events & XML. I created and E.E. that captured my running SP_WHO2. But how do I query the E.E. file to find it ? I ran this, just to find my record, but what's the "Correct" way to query my file to search for Stored Procedure calls, or table […] |
SQL Server 2016 - Administration |
error while installing ssrs2016 - I'm trying to install ssrs2016. while instantiating i get the error RPC service not available . I can see that the RPC services are running. on some sites it mentions that this more of firewall or network error No changes can be made to them Has anyone faced such an error Regards Atulyan Padmanabhan […] |
How to sync Always on AG in primary site with Always on AG in DR ? - The primary site has 2 database servers connected to a SAN. both nodes running on SQL server 2016. Both the servers are configured to function as an always on availability group as opposed to a Fail over Cluster. The DR has an identical setup; 2 nodes, a SAN. both nodes configured as an always on […] |
SQL Server 2016 - Development and T-SQL |
Temporal Table Reporting - Hi All, I have inherited a database which has a number of system versioned (temporal tables). One of the things I have been tasked with is to create a report which basically shows what has changed across the entire database (i.e. Audit), not just a single table. Is there an efficient way to generate a […] |
SQL bulk insert unique rows from a parent table to multiple child tables - I have a table Locations whose schema is below. I want to select all unique rows from the Home table and **bulk** insert into locations and individual table **Home Table** - Id (identity) - LocationGroupId (can be null) - IndividualGroupId (can be null) - Address - City - State - Zip - FirstName - LastName […] |
Get current and previous week sales - Hi, I have a FactBooking (BookingDateKey, Amount, Qnt) and a dimension DimDate(DateKey,Year,Month,WeekNumberOfYear) tables. Can you please let me know the sql to get the current and next week bookings? Thanks Subbu |
Performance Impact of Multiple or many triggers on a Table - Hi All, I have one table in that 10 triggers are there, due to this, it takes more time while insert and updates record in the table. 1. For Insert triggers - 4 2. For update triggers -6 (On different columns). Can anyone know how to sort this issue? Can I merge triggers in one […] |
Slow running proc on SQL 2016 with execution plan - The stored proc is running very slow on 2016 as compared to 2019. Its doing some common validation from a temp table and inserting data in primary tables and mapping tables. The mapping tables have clustered indexes on primary keys {Table1Id, Table2Id, Table3Id}. The proc needs to process around 4mill records. It finishes execution in […] |
SQL Server 2012 - T-SQL |
Better way to write this without the nested joins? - A BA recently ran this query and it got flagged by a capturing event for having > 130,000,000 logical reads. Is there a better way to handle query can join back onto themselves? What would make something like this more efficient? SELECT 'Term Reversals' AS 'TERM REVERSAL', ev.employee_id, ev.ssn, e2.import_run_id, e2.string_value, e2.effective_date, e.import_run_id, e.string_value, […] |
SQL Server 2019 - Administration |
unable to connect to SSRS reporting dashboard from remote pc - Hi , i have an SqlServer 2019 server instance on which i have installed Ssrs services. I'm unable to connect via a remote pc and so i cannot see reports dashboard on my browser,obiovusly i can reach that locally. I have read a tons of forums in which i have found several possible solutions but […] |
SQL Server 2019 - Development |
Reliable practice tests and exam dumps for exam 70-761 (T-SQL Queries) - I have seen quite a few sites with exam dumps and practice exams. Some websites even claim that the problems have been on actual exams. When I read the "discussions" about the answers, apparently many of these are not providing the correct answer. I don't want to end up accidentally learning something that is not […] |
SQL Date filter/expression - Hi I have a report that uses a stored procedure but it wasn't built by me. It basically lists completed cases from our customer management system but I want to tweak the report to only show open/live cases. I have two fields: 'CaseOpen' and 'Case Completed' and I somehow need to use an expression/ filter […] |
Recommend tools to trigger Stored Procedures - Hi, I have three stored procedures, as below SP_Extract_Data SP_Load_Data_Into_Temp SP_Load_Data_Into_Real_Table I know there is available tools can use to call the stored procedures:- It can be applications such as C# Net It can be SQL Server Itself SSIS Or it can be create agent job to call But beside of […] |
Amazon AWS and other cloud vendors |
Error creating AWS RDS Linked Server to Oracle - Hi, I am trying to create a linked server in AWS RDS to an Oracle Database. I created using the t-sql scripts as I could not find the list of Providers under the Linked Server in SSMS. And when I try to access it, I get EXECUTE permission was denied on the object sys.xp_prop_oledb_provider error. […] |
Integration Services |
Better Performance Using Stored Proc with OLE DB Source vs SQL Command Query? - I have numerous SSIS pkgs that I’ve written that run every 15 min to compare records in SQL Server tables with records in equivalently named tables in Oracle to keep both tables 100% identical in content. I have currently been using just standard “Select...” statements as the sources in the SQL Server and Oracle OLE […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |