EXEC sp_updatestats.
Hi everyone! Why is the date not updated after executing the command 'EXEC sp_updatestats;' on the database? All help is welcome!
How to get data from a Web Service that has HTTPS, SOAP and WSDL with an SSIS Project
I need to get data from a Web Service that has HTTPS, SOAP and WSDL configuration. Tried following this tutorial https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/ , but stopped on the…
Can't schedule an exam (link goes into a loop) 70-764
Hey , As soon as I want to schedule an exam (https://learn.microsoft.com/de-de/learn/certifications/exams/70-764), the following page got into a loop (reloaded every time, nothing happens.) I only see a white window. I am logged in with my MS account!…
What's wrong with my AlwaysOn?
Hi, I'm setting up an Always On following the whole procedure I found in other laboratories and I notice that mine happens differently. The database goes online only after I run it (Join to Availability Group ...) What can be wrong? I…
![](https://techprofile.blob.core.windows.net/images/4ScXrrpk-E2uuoOuZIV4UQ.png?8D80E5)
![](https://techprofile.blob.core.windows.net/images/bE-Pq7f2lUSVB8C4wMY6Tw.png?8D8475)
Page flag and Page flag description for sys.dm_db_page_info
anyone know the details about the following column ?
![](https://techprofile.blob.core.windows.net/images/ctcyKX4BnU-r4fRclNq-Ww.png?8D9AB2)
Advice to select the best employee business key
Hi, I'd like to get your opinion/advices to select the best employee business key in our system. I work on a multi-country, multi-company data warehouse project. You may find different HR systems all around the world, so I have to choose the appropriate…
After session kill, T-log's size are increasing.
I have huge DB and Table. T-log used percent was high because of delete table.. so I killed the session. But killed session is remained 'killed/rollback' status. I checked below query for check log use cause.. SELECT tst.[session_id], …
SSRS - Report Model - convert XML to SQL?
Hi. I have a series of SSRS reports written against a report model. In report builder the dataset shows the XML which has been generated. Question is, can i convert the XML to SQL? Reason for asking is that I want to delete my report model and just…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Can i do http request via the custom function which created by clr?
Can i do http request via the custom function which created by clr?
Maintaining tablix width when hiding some columns in rdlc report
In our project, we got some rdl files that contains dynamic column, User can decide which to show or which to hide by a Multi-Selection Report Parameter. then it comes some problems: 1.if there is a report contains 10 columns, when the user selected 5…
AlwaysOne see all the bases on the primary server? Why?
Hi, when i access a listerner i see all the bases of the primary server. I notice that I see the base that was synchronized and also all the others that were not synchronized. Is that so by design? Did I imagine that it would only show the…
![](https://techprofile.blob.core.windows.net/images/4ScXrrpk-E2uuoOuZIV4UQ.png?8D80E5)
![](https://techprofile.blob.core.windows.net/images/ctcyKX4BnU-r4fRclNq-Ww.png?8D9AB2)
SQL 2017 Scheduled Maintenance Plan job
I created a reoccurring scheduled SQL maintenance job with my login account (myNetwork\myUsername) but the it fails each time. The Windows Application log states that the following: SQL Server Scheduled Job 'MaintenancePlan_FULL_Backup.Subplan' -…
![](https://techprofile.blob.core.windows.net/images/H_1YTLccAQAAAAAAAAAAAA.png?8D83AD)
SQL Server: Restoring database from a remote location directly vs. copy .bak file and then restore
SQL Server: Restoring database from a remote location directly vs. copy .bak file and then restore Will anybody know why restoring directly from a LAN location is far faster than the total time require for copying the .bak file first and then…
Unable to install sql server 2017 developer editiion x64 windows 10 Pro
Need Help with Following Error : 21623-summary-etpld023-20200831-202936.txtMicrosoft SQL Server 2017 Setup ------------------------------ The following error has occurred: There is a problem with this Windows Installer package. A DLL…
SQL Serverログオン不可が頻発(Error: 17189, Severity: 16, State: 1.)
【環境】 Microsoft Windows Server 2012 R2 Standard DBサーバーに対しSQL Serverの最大サーバメモリは、4096(MB)を設定しております。 ---systeminfo--- 物理メモリの合計: 8,191 MB 利用できる物理メモリ: 1,168 MB 仮想メモリ: 最大サイズ: 13,162 MB 仮想メモリ: 利用可能: 3,419 MB 仮想メモリ: 使用中: 9,743 MB 【質問内容】 …
How can i deny access to any sql management from lan and public network?
Hello, Can i deny access to any sql management from lan and public network? I mean the user SA to be able to be used to read and write in the bases but not to connect with the sql management or similar app. Thank you, Giorgos
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
SSRS Email settings
Hi, SQL Server 2012 Standard I dont see the column for entering authentication details for smtp server under email settings of SQL Reporting server configuration window. I edited the configuration file and added the userName and Password tags in…
Query to find list of all primary keys and check if they are clustered and if they are on uniqueidentifier column
Dear Experts, I have this requirement to query all the tables in my database to check if the tables have clustered indexes on the primary key and if the key column is an uniqueidentifier. I prepared this script below select o.name as TableName ,…
![](https://techprofile.blob.core.windows.net/images/f3a7f4ee4f8f40d691a550d3840b0327.png)
Multidimensional Project Data Source Wizard Fail SSAS
Hello, I'm trying to create a data cube in Visual Studio (SSDT) and I'm unable to launch Data Source Wizard. When I select New Data Source, I see the wizard, but when I click Next, the wizard dissapears. Has anyone faced such issue? Could this be…
Suppress Zeros and Empty Rows and Columns by using MDX
Hi, following is my MDX. Still getting zero rows and columns. how to remove zero rows and columns. Select Non Empty CrossJoin( CrossJoin( {{[Account].& [1]}, {[Account].& [2]}, {[Account].& [3]}}, {{[Measures].[YTD]}, …