SQL Tact
Friday, February 18, 2011
"Heterogeneous queries and use of OLEDB providers are not supported in fiber mode."
›
This is a classic. I've seen this in environments where someone is trying desperately to resolve SQL Server performance issues. Out ...
Monday, February 14, 2011
Using a DDL trigger push changes over a linked server
›
Here's a script I put together to automatically propagate schema changes to keep two SQL Server databases in sync using a DDL trigger. ...
2 comments:
Monday, January 31, 2011
Deadlock info from XEvents XML
›
Here's a handy script I developed to take advantage of the built-in XEvents System Health session in SQL 2008. XEvents is the new infr...
1 comment:
‹
›
Home
View web version