| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| Solutions for real-time replication of data from one SQL instance to another - Hi, I'm hoping for some opinions on the best options for how to replicate, in real time, data from a production SQL Server database onto another SQL instance. This second instance would be for vendors who need to access some of the tables from the production database, but we would prefer that they not directly […] |
| Faster Integrity check - We are upgrading from SQL 2014 to SQL 2017. Noticed that integrity checks are running 6 times faster than SQL 2014. Is that a big enhancement in SQL 2017? Do you agree with me? |
| SQL Server 2017 - Development |
| Insert missing records for each month/year with the previous month's value - I have a sample data, see below. Sample data The base rules are If the same CustomerID and Account# for the month that don't exist based on the previous month, then insert it; If the same CustomerID and Account# for the month that do exist based on the previous month, then keep it. For example, […] |
| SQL Server 2016 - Administration |
| Import Extended Events XEL File ? - I have a 300 Meg .XEL file from an Entended Event session that I used recently. I stopped the session, and want to query the data. What's the best way to get the file into a SQL table ? In general, what's the best way to read the data, and look for stored procedure calls […] |
| Insert all columns except for Identity ID - Two tables A and B have the same structure and the same number of columns. First column in both tables is IDENTITY ID. The script below cause an error because ID. INSERT INTO B SELECT * FROM A How to use "Except" to not select column "ID" from table A? |
| SQL Server 2016 - Development and T-SQL |
| Retrieve a row with non-unique cluster keys - I noticed that for those tables with non-unique cluster key columns, SQL adds an internal unique identifier. Is there a way to retrieve a single row using this internal unique identifier which seems to be an Int32 number. |
| SQL Server 2012 - T-SQL |
| Entered by mistake - Entered by mistake |
| File import - Hi, I first have to say that I am not that knowledgeable on file imports, but this is really beyond me. My manager has a file that has adnominal spaces in it, I think some are tabbed and some just space, but my manager wants me to import the file into a table and keep […] |
| SQL Server 2019 - Administration |
| Application SP Response time differs on user login - I have multiple parameterized SP for our Application. When I Executes those SP individual it will returns output within 1 Sec. But when we are running Test Load with multiple user around 100 or 200 users same time , Same SP Response Time is Over 3-4 Sec. If i Execute same SP with same Parameter […] |
| SQL Server 2019 - Development |
| How to Identify Slow Code - In a specific Query, how can you easily identify how long each piece of code is taking? My query is taking over 20 minutes so I can't just comment out each line and see what improves it, so I need a better method. |
| For XML Clause is slow - Hello everyone, I am finding issue while running this query . WITH XMLNAMESPACES (DEFAULT 'http://example.Schema.Example.data') Select(Select * from [dbo].[udfReturnexampleRecords] () for xml path('Test'),root('example') ) as XMLTEXT Here udfReturnexampleRecords is a table valued function and while running complete query , it runs very slow for 20 lakh records. Any advice please . Thank you |
| Reporting Services |
| Moving sub-columns in a tablix - I have a report which looks like this: These are all grouped by manager, with each of the center cells displaying the value for the particular manager and then the picture at the top and at the bottom right the sales and profit for each year. This repeats for each manager. I want to move […] |
| Integration Services |
| Ignore failure works in Visual Studio but not in Integration Catalog - Hi I have a control package which calls a number of packges as part of an ETL process. In the RAW layer (from source to DB) I have a file which has failed due to a metadata change. This caused the whole ETL to blow up. I modified the control package by updating the […] |
| .dtsx packages disappearing!!! - SQL Server Data Tools 15.1.62002.01090 Microsoft Visual Studio Community 2017 Version 15.9.21 I am loosing dtsx packages! It happens sometimes when i am closing a solution and sometimes when i build the project. The packages are actually deleted from file and are no longer avaialble. They are just deleted. What is happening? Has anyone else […] |
| General |
| Joining 2 Tables (Sales with current stock on hand) displayed - Dear all, I am trying to join 2 tables (Dailysale table and Storerng table) Dailysale contains daily sales transaction while Storerng contains the stock on hand I am using the below query select DS.DTMTRADEDATE as [DATE], DS.INTSALEID as RECEIPT, IT.STRXREFCODE as ARTICLE, (sum(case when strsaletype='I' then convert (decimal(5,0),ds.DBLQTYSOLD) else null end)) as [QTY SOLD], (sum(case […] |
