January 2010 - Posts

• Adding a PK online?

  I just read in a forum about a user who want to replikate a table, but the table doesn't have a PK. The table is pretty large, and having the table not available while adding the PK is undesireable. The table has a clustered index already, and there are Read More... Posted Wednesday, January 13, 2010 10:53 AM by TiborKaraszi | 4 Comments Filed under: indexes, Performance

• Is there and overhead to RPC events?

  I recently read a discussion whether RPC events add overhead compared to just submitting text. I got curious and did some testing, which I want to share. Background, SQL events Using most APIs, if you just submit a query to SQL Server, you will get what Read More... Posted Monday, January 11, 2010 12:31 PM by TiborKaraszi | 4 Comments Filed under: API, Performance