Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout
Your SQL Agent Jobs may be silently failing when using Linked Servers.
2016-05-02
2,452 reads
Chad Feghali
Read-Only Routing for Non-Microsoft Clients
An alternative read-only routing technique for non-Microsoft clients.
2015-12-28
2,528 reads
The Case for Specifying Data Types and Query Performance
Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.
2015-06-22
6,186 reads
Blogs
Get Configuration Change History From the SQL Server Error Logs
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Forums
Gentlest of Reminders, Don't Stop Learning
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
table with varcahar(max)
Gurus, there is a table which is very slow to query , it has...
Query goes crazy.
Hi. I have a query that returns few rows (out of 7 table join,...
Ask SSC