Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
SQL Script Help - I am looking for a script that can return the following values for each of the databases in my instance: Object ID, Object Type, Database Name, Table Name, Schema Name, Index Name, Table Create Date, Table Modified Date, Row Count, Total Pages, Used Pages, Data Pages, Total KB, Total MB, Total GB, Used KB, Used […] |
SQL Server 2016 - Administration |
multiplied columns from Oracle linked server - Wasn't sure exactly where to put this one... We populate an Oracle data warehouse each night, and we connect to it via Linked Server connection. It works perfectly well for the most part. One weird thing though... when I want to look at the structure of a table on the Oracle side, I go […] |
Delete only one record takes 20 seconds and have to delete 11000 - Hi, i need some help. Server 2016, 96gb of ram, 24 cpus, and so. One table with about 20 columns, no special columns at all. 36 millions records and a clustered index. Deleting one record by id in the clustered index takes 20 seconds, 2 records take 40 seconds and so. The plan shows 98% […] |
SQL Server 2016 - Development and T-SQL |
Sum function in CTE is not calculating the right balance - I have table with all charges and payment the charges are 'c' and payments r, f, d. The charges have positive a negative amount and the payments positive a negative amount as well. When I query the table for just one student and add the amount I have the right balance, something is wrong with […] |
Improving MSOLEDBSQL Connections - When using the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) in the Import Wizard, I've noticed it takes much longer to import data compared to using the Native Client. Are there any properties you can change to help speed this up? |
Administration - SQL Server 2014 |
Change dbowner - Can we change the dbowner to system databses ? if yes how can we proceed? |
Development - SQL Server 2014 |
Send me an email if this job run longer than 30 minutes - Hi I have a job that I need to be notified/emailed if it runs longer than 30 minutes. What is the best way to do that? |
SQL Server 2019 - Administration |
2019 Transaction log size increase during index maintenance - Hi I have recently migrated our 2018 databases from 2016 servers (VMWare onsite) to 2019 servers (VMWare AWS) and added TDE Encryption to the mix. During the nightly index maintenance the log files expand as expected, however onsite (1016) the log files rarely go over 9gb however they now expand to 35gb (2019) Does TDE […] |
Job that runs slow how to use more CPU - We have a web application job that runs from web calling to update database on a SQL server 2017 box. it is an over night job. The job runs slower after this weekend. it runs 5 hours, now goes to 9 hours. But we see the RAM and CPU utilizes only avarage 5% on the […] |
SQL server SSRS 2019 - Does SQL server 2017 reporting SSRS work with reports that has SQL server 2019 data sources? Thanks |
SQL Server 2019 - Development |
Getting columns for sys. tables - I have a data dictionary project. I can easily get the data tables and their columns, as well as Views. For Views I can get the table and column if its a user table. However some Views are based on system tables. i.e.: sys.columns, sys.objects which do not come out in the table query, and […] |
Azure Data Factory |
COPY Activity Failing - Hi All I am copying from DLS to SQLMI and my COPY activity is failing. It just says as failed and i have no other information. Can someone please guide me as where to look for more info? Thanks |
Reporting Services |
2017 change report button text - Hi Is there a way that I can change the "View Report" button text in SSRS 2017? At present it reads "view report" and I would like to change it to "Apply" Thanks, Derek |
SSRS conditional reporting - Hi, I have a SSRS report and I am using Email delivery type as option for subscription. I want to send the report to different recipients based on parameter values which comes from a SQL query. I set up report parameters in the subscription page. Resource name Enter value (null ) as shown in Capture1 […] |
Integration Services |
SSIS Oracle destination using VS 2017 - Trying to connect oracle destination but no luck. Has anyone connecting Oracle in SSIS using VS 2017? Please advise? |