StrayCatDBA questions

StrayCatDBA answers

• How often are SQL Server Index Usage Stats Updated and what triggers it?
• Transmit data to client on specific page, based on SQL Server column or row update
• MSTest Unit tests (VS 2012) vs. SQL Server, intermittent Primary Key collisions
• Will SQL Server Service Broker be supported in SQL Azure in future?
• Stored procedure with table name as parameter amongst others
• SQL Server Full Text Search around numbers and underscores
• Trigger Error: The current transaction cannot be committed and cannot support operations that write to the log file
• bcp - dump via xp_cmdshell vs. sp_oaMethod Security
• Filtered index seek for `is NULL` condition and scan for opposite
• How do I check if table exists and it's not empty in one IF