| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| reads for DMVs - Hi All, I have created a test table with rowsize ~8K. I have inserted 2 rows and when I read data from the table, then it essentially has to show me 2 logical reads but it showing 6. why is it so? Am I missing anything? Second question is why sp_whoisactive is showing this spid […] |
| predictive query plan - Dear Friends, Please advise if there is a way to get a query plan for a query without running the query.Thank you in advance. Thanks and best regards |
| Significance of Historical waits report in SQL server Performance dashboard - I have the following historical wait report for my SQL server. I have noticed that Wait Category Tran Log IO is consuming 27.09% of percentage time followed by Query Store which takes 24.34%. I want to know if this distribution is normal or should I take any adequate steps to improve the performance of my […] |
| slow processing - Hi Experts, Yesterday, we ran a program and it has processed 1500 records in 2 min. Today, it is running for past 90 minutes and processed only 350 records so far. What should be checked apart from blocking? Cheers, Bob |
| SQL Server 2017 - Development |
| Weird problem with substring function over 'text' column - In the query below, I get the Invalid length parameter passed to the LEFT or SUBSTRING function error, but can't figure out why. Query: select table1.Id, substring( table2.source_data, charindex('',table2.source_data) + 7, charindex('',table2.source_data) - charindex('',table2.source_data) - 7 ) as X from table1 inner join table2 on (table2.Id = table1.Id) where (table1.in_timestamp >= @dateFromIncluded and table1.in_timestamp < […] |
| SQL Server 2016 - Administration |
| multiple PAGELATCH_UP waits on data file - Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to tell me? what is PFS ? why INSERTS are blocking each other? As per knowledge, insert shouldn’t block each other? Since they are getting blocked , waiting for LCK and so went to suspended state. Does this indicate a highly transactional […] |
| SQL Server 2016 - Development and T-SQL |
| Excel style Contains filter - Hi, I am trying to do Excel style "contains" in SQL, but doesn't work. There are two forename fields in my two tables. I would like to know if first forename is "contained" in second forename field or vice-versa. The name can be anywhere in the other column. Basically identifying individuals who put in their […] |
| Remove the Dynamic code from my SQL sproc - I have a stored procedure that was created to run dynamically. Other than me manually removing all the dynamic parts of the scripts, is there a script or a way to remove all the dynamic parts of it so I can step thru it and test parts of the script? |
| dynamic update to SP - Looking for suggestions\examples of how to update a SP that the table used changes each month at midnight. The app creates a new detail table it logs information to. example: sqlt_data_1_2023_03 when 04/01 hits a new table is created called sqlt_data_1_2023_04, and how could I use an automated method to update any SP to the […] |
| Administration - SQL Server 2014 |
| Import DataBase from Access to SQL server 2014 - Hi I want to import database form access to SQL server 2014 When adding a database (structure and data), the process does not complete and I get an error (0xc0202009) When adding a database (just structure) without data, the operation is successful, but I do not find the database in the list |
| SQL Server 2019 - Administration |
| I need to import v7r3 ibm i (as400) info to a sql 2019 database - I need to import as400 data into sql 2019 database. In Sql i can run a linked server to access the as400 data fine. When i look for the same data source to copy all the data to a database, i don't see the one i need, any help would be fantastic. |
| SQL Server 2019 - Development |
| Inserting data into Physical Table on Azure Taking Longer Than Expected - We have an issue on Azure with inserting data into a physical table . We have done some benchmark testing and we are finding that inserting to a physical table on Azure, is taking 4 times longer compared to using a User Defined Table Type or Temp Table I wanted to know why this might […] |
| Monitoring third party database to detect updates without modifying the database - Hello folks, Even writing the title, it sounds oxymoronic but bear with me. We have a third party vendor application with it's own front end the business uses. Specific tables from the vendors database are replicated into our SQL server via a vendor managed process. (AWS Data Sync) Historically we have made use of the […] |
| Amazon AWS and other cloud vendors |
| Amazon Redshift Data warehouse setup and bring data from Apps to Data warehouse - We are setting up new data warehouse with Amazon Redshift and building integrations to bring data from enterprise apps' specific databases to data warehouse. Would like to hear from experts are there any best practices to do these integrations consistent, reliable and long term easy maintainable. Appreciated for your thoughts. |
| SQL Server 2022 - Development |
| Is TemporalTable SysStartTime available before performing an insert/Update? - I want to align a Date column (datetime2(7)) with the same full resolution date of SysStartTime column populated by SQL in temporal tables. I know this is the "Transaction Start" datetime, and has full resolution (e.g., 2023-03-31 17:08:08.5344576) I've attempted to use the following: SELECT dt.transaction_begin_time AT TIME ZONE 'UTC' FROM sys.dm_tran_active_transactions dt WHERE dt.transaction_id […] |
