|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Terraform Targets | |
Someone asks me to use Terraform to define the types of infrastructure our organization needs in the cloud. With which cloud providers can I use Terraform scripts? | |
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) |
Robust Plans What does the ROBUST PLAN query hint do? Answer: Tells the optimizer to plan for the max potential row size Explanation: This query hint tells the optimizer to plan for the max potential row size, to avoid potential errors when processing wider rows with certain operators. Ref: Query Hints - https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-ver16 |
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 |
Publish AWS RDS SQL Server Database - I am in the process of migrating an on-premises application to AWS. The on-premises app publishes a SQL Server db, subscribed to by a couple of other servers in our environment. I am struggling to find a way to replicate that functionality in AWS RDS SQL Server. Lots of guides on replicating into RDS, but […] |
Get Read and Writes per a duration - Hello, I want to be able to view the number of read and writes for a database or (tables in the database) in a day or week or month. Currently, I am using the following query: SELECT name AS 'Database Name' ,SUM(num_of_reads) AS 'Number of Read' ,SUM(num_of_writes) AS 'Number of Writes' FROM sys.dm_io_virtual_file_stats(NULL, NULL) I […] |
SQL Server 2017 - Development |
Update Column query - Hi All. Need help in implementing this logic. I have a table in below format. Currently, a new Config ID is generated for every item number- Revision combination. I want to take the config ID of minimum(Revision) for every item number and update it per item number. Expected Config ID is desired output. It is […] |
SQL Server 2016 - Administration |
Patching AlwaysOn AG - Hello Everyone, I have Availability Group, one primary replica and one secondary replica. SQL Server version is 2012. It is configured for automatic failover and is in synchronous mode. I already googled but found different answers, so I want to know the correct procedure. How to do patching step by step. |
SQL Server 2016 - Development and T-SQL |
Create table having a StartDate and EndDate for each week - I want to create a table that has a StartDate, EndDate, WeekNum for the year 2021 starting with the First Wednesday of January to the end of December ( I know the last week may land in 2022, that's fine). So in 2021, the first wednesday is January 6. So the table would start with […] |
SQL server help - I need to show the total count for a particular field with my select statement. But this should be shown only once for each VID. I wrote the following to get the count, but it displays it for every record. Is there away to display it only in one row for a specific VID? I […] |
SQL 8144. Error: Procedure \'InitiateLoad\' has too many arguments specified. - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is: CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […] |
SQL 8144. Error: Procedure 'InitiateLoad' has too many arguments specified. - Hi Community, When I attempt to execute the following Procedure called InitiateLoad, I get the error: Sql error number: 8144. Error Message: Procedure or function InitiateLoad has too many arguments specified. Can someone take a look at the SQL Code and let me know where the problem is: CREATE PROCEDURE Process.InitiateLoad (@Area VARCHAR(150), @Domain […] |
Capturing what calls a trigger - I have a DML trigger and I need to know where the action is being called from, whether it be a simple T-SQL command or a stored procedure. For example, if I have an insert trigger on Table A and that trigger runs, I want to know what code was executed that caused the trigger […] |
SQL Server 2019 - Development |
How do I JOIN to a Linked Server in a VIEW without using a CTE - I need to create a VIEW that joins a table in the current database (SSMS2019 environment), to a table in a database on a different server (SSMS 2014 environment). The VIEW will be created in the 2019 environment server. To start, I created a Linked Server in my 2019 server called [REMOTE_SERVER_2014_ENV] which successfully connects […] |
SQL Azure - Development |
What can we do about SSRS and SSIS in an Azure VM? - We have a third-party product which uses SQL Server 2016. It also uses both SSRS and SSIS. The network group wants to migrate the test version of this database into an Azure VM - basically a lift and shift approach. We asked the vendor of the application for their input as to the viability of […] |
SSRS 2016 |
Drill down Action: one main report with two subreports - Hallo, i have to implement one main report with two sub reports. In the main report and the subreports the columns are closed. By a drill down action, the selected column in each of the three reports should open. How can I implement this drill down behaviour in all three reports? Thanks, duloran |
General |
When using Microsoft 365 tools, how do you backup your data? - Is there any easy way to automatically backup my data using the microsoft 365 tools, and it is possible to set schedules? and is there any option to retrieve my loss file?. Thanks by the way. |
Integration Services |
How to keep For Loop Container continue on error? - Hi all, So I found a solution of a problem I was having with For Each Loop Container in my SSIS package. If error was received on any of the task inside container the package was failing instead of going to next iteration. The solution found here: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/ is to create event handler on error and […] |
SQLServerCentral.com Website Issues |
E-mail Notifications - I've noticed that I've received no alerts today. Are others experiencing this? |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |