(Fikrat Azizov) I was helping diagnose underperforming ETL jobs for one of my clients. They had SQL Server Agent Jobs which were calling SSIS packages to populate their DWH and these jobs were running much slower than they used to and were failing occasionally.
Tag: sql server
#0415 – SQL Server – Performance Tuning – Use STRING_AGG to generate comma separated strings
(Nakul Vachhrajani) With more and more data being exchanged over APIs, generating comma-separated strings are becoming a much more common requirement.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 8649, State 1, Severity 17
(Pinal Dave) While trying to upgrade my SQL instance to the latest patch of SQL 2017, I encountered an issue. This has happened earlier with a few of my clients earlier but this time the cause was different.
Azure SQL Database Online Columnstore Unicorn and Rainbow Theory
(blobeater) As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without major blocking operations on the queries that are executing while you are transforming the data.”
Disk Space and SQL Server
(Jason Brimhall) One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a production outage, the need exists.
Creating CRUD Stored Procedures in SQL
(Hannes Du Preez) Create, Read, Update and Delete operations are pivotal for any database application. These DML (Data Manipulation Language) statements can become risky to do, especially if you are new to databases and do not know how these statements work.
Lesson Learned #78: DataSync – Cannot enumerate changes at the RelationalSyncProvider for table ‘customertable’ – Execution Timeout Expired
(Jose M Jurado) Yesterday, I worked in a service request with a lot of lessons learned when our customer was using Azure SQL Data Sync to synchronize around 15 million of rows.
SQL SERVER – FIX: 3637 – A Parallel Operation Cannot be Started From a DAC Connection
(Pinal Dave) This was indeed one of an interesting error which I have never seen earlier and it is about DAC Connection.
SQL SERVER – Query Listing All the Indexes Key Column with Included Column
(Pinal Dave) Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, we identified the customers had too many indexes on tables.
SQL SERVER – Upgrade Error – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You Do Not Have Permission
(Pinal Dave) A few days back, I published the blog on the same error message and one of the blog reader responded and ask how can I generate the script if I don’t have another SQL Server?