GitHub

5_job_Maintenance.sql

INNER JOIN [msdb].[dbo].[sysjobsteps] sjs ON sjs.[step_uid] = sjsl.[step_uid] INNER JOIN [msdb].[dbo].[sysjobs] sj ON sj.[job_id] = sjs.[job_id] To set how VLDBs are handled, set @VLDBMode to 0 = ...
GitHub

sqlserver_to_exasol.sql

Do NOT use the obsolete jTDS driver. (Validated with mssql-jdbc 13.4.0 against SQL Server 2025 17.0.4055 -> Exasol 2025.1.11.) See the connection examples at the end of this file. truncation', ...
InfoQ

Azure Data Lake Analytics and U-SQL

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
Microsoft

Working with date/time values and SQL Server

TL;DR: if you want to use date/time values from a SQL Server table in PowerApps, use the datetimeoffset column type and your life will be easier. The datetime (and friends) column type represent an ...
TechRepublic

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...
TechRepublic

Displaying money values in currency format in SQL

Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader’s problem. A reader sent ...