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 = ...
A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...
When SSRS (SQL Server Reporting Services) fails to send emails, that’s usually due to improper SMTP server configuration. You should also check the SSRS permissions. There are a lot more possible ...
Take advantage of stored procedures, query pagination, query caching, and other advanced Dapper feature to simplify data access and ensure high performance. The Dapper ORM (object-relational mapper) ...
Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...
A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...
PASS Summit has become an annual pilgrimage for thousands of SQL Server professionals from around the world to join together. My very first demo at PASS Summit was in 2010, and today marks the third ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results