Just show last date with Report Builder 3.0 custom report
Is there anyway to just show the last date something was added within the report builder as in reports I am getting multiple results when I just want the date of the last one added.
Backup and Restore Database - Affect on Full Text Indexes
We are planning to move a database from SQL Server 2008 R2 to a SQL Server 2016 instance. This database has a few Full Text Catalogs, with all the indexes part of the PRIMARY file group. When we perform a Full backup and restore on this database, will…
![](https://techprofile.blob.core.windows.net/images/MLueEQ0UnUaLCvvLlMs40A.png?8D849B)
Create SQL functions with parameters
Hello, I have a lot of sql scripts which use functions like "string_agg" and "concat_ws". those funcations are available from sql 2017. now I would like to create some backward compatibility for MSSQL 2016 and earlier. I tried if I…
SQL CLR Types does not show up in Registry Editor
The administrator has installed and uninstalled the SQL CLR Types on a coworker's machine multiple times and when we search for it in the Registry Editor it isn't there. We keep wasting IT's time, and I figure I should ask the forum before asking again.…
![](https://techprofile.blob.core.windows.net/images/f5m7qESyDk63s64hMoxBlQ.png?8D8385)
SQL Server 2008 R2 Support extension
Hello, Our organization is using SQL Server 2008 R2. We do not wish to upgrade it to latest version due to cost implications and dependency on the associated application version. I read that extended support ended for SQL Server 2008 R2 ended in July…
![](https://techprofile.blob.core.windows.net/images/f5m7qESyDk63s64hMoxBlQ.png?8D8385)
Table in sql server 2017 takes alot of time to update/insert few rows
Hello I have a table in sql server 2017 that has around half million records and it is constantly used via website. Select statement are very fast over it or over its views,but update/insert of 1 or 2 rows takes a lot of time sometimes 1 row needs 15…
Getting an Intermitent issue with Linked Server between 2 On-premise SQL Servers
Hi All, Every now and then I am getting this issue and not sure where to look into it..? _Master_ODS:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source:…
![](https://techprofile.blob.core.windows.net/images/aWg0XX9YrEetLk45eHFzSg.png?8D8199)
![](https://techprofile.blob.core.windows.net/images/f5m7qESyDk63s64hMoxBlQ.png?8D8385)
Error during the registration of a CLR assembly in SQL Server 2017 which references other assembly
I got the following error when I try to deploy my DLL which references other ThirdPartyDLL. Msg 10300, Level 16, State 2, Line 4 Assembly 'MYDLL' references assembly 'ThirdPartyDLL, version=300.1.0.1, culture=neutral,…
![](https://techprofile.blob.core.windows.net/images/f5m7qESyDk63s64hMoxBlQ.png?8D8385)
File System Error - Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the cube-user database cryptography key.
SSAS DB Synchronization job is scheduled to synch using a XMLA script via SSIS. This synch the SSAS DB 'ESSJMT' from process server ( Source ) to Query Server(Destination). When it failed , server logged below error. And when I tried to run profiler…
Extended Events to trace Foreign Keys becoming untrusted
I am trying to find out what is continually setting the Foreign Keys and Constraints to untrusted. I've setup an Extended Events session to trap Alter Table events but it's not catching it. How can I trap this using Extended Events? WHERE…
AlwaysOn reads on readonly replica and latency
Hi all, On an sqlserver2016 alwayson replica in asynchronous mode with readonly activated, If I have a long query (several minutes) selecting datas, are the logs still applied or is it waiting the end of the query to apply the new logs and keep data…
Can't see table relationship while create ER diagram for SQL database
Hi There, I'm trying to generate ER diagram for one the SQL database. When selecting tables, I can see only tables but can't see table relationship. Please help me. Regards, Ken
Find what I am looking for
This was my query page url: https://learn.microsoft.com/en-us/search/?terms=sp_enumerrorlogs I got: "8,300 results for 'sp_enumerrorlogs'" I searched 5 or 6 pages without encountering "sp_enumerrorlogs" in the article…
![](https://techprofile.blob.core.windows.net/images/ctcyKX4BnU-r4fRclNq-Ww.png?8D9AB2)
VB.NET ReportingService2005 QueryDefinition.CommandText
I would like to know if there is a good example of ReportingService2005 QueryDefinition.CommandText using vb.net. My goal is to retrieve / get the SQL within the rdl report. I found this Link but no examples how to use it. any suggestions is…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
define query parameters for my dataset in SSRS
Why am I being prompted to define query parameters for my dataset in SSRS when I select "Refresh Fields" when it is simply calling a stored procedure? There is an SSRS report parameter for each stored procedure parameter.
![](https://techprofile.blob.core.windows.net/images/EqrQxhN70Uib8KRAQTM31A.png?8D9A5B)
dimension security on a combination of dimensions
0 I have 2 dimension tables scenario and compensation. scenario already has dimension security applied. Now we need to implement dimension security for compensation. Compensation is dependent on scenario. For example we have a separate table which has…
compatibility_level and LEGACY_CARDINALITY_ESTIMATION
Hi everyone, we migrated from sql 2012 to sql 2016 and since then we have been facing some performance issue. We decided to change the compatibility level to 110 (sql 2012) and set the LEGACY_CARDINALITY_ESTIMATION= ON. It helped but then we were still…
Get the transaction amount inside the trigger database - SQL Server
Group Knowing that inside the trigger that controls the creation of a table, inside it is a transaction process. How could I identify, within a database trigger that when a certain table was created, the person was using a transaction…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Parallel Processing in SSIS
Dears I have the following scenario in SSIS. There are two packages, Outer.dtsx and Inner.dtsx. the Inner package is called inside the Outer package in the workflow. To increase the performance, as the workload is heavy, I added a sequence container,…
Upgrade SQL 2008 Cluster to SQL 2012 Cluster
We are currently attempting to upgrade SQL 2008 Cluster to SQL 2012 Cluster. 3 node cluster. We were able to upgrade the A and B nodes but unable to upgrade the passive C node. The passive node doesn't have a database. In order to upgrade the A and B…