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 = ...

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 ...

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 ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...