For example... If I create the following stored procedure:

create procedure test

as

select * from sys.databases waitfor delay '00:00:30'

and then run this:

declare @rc int

exec @rc=sp_exec_init 8

if (@rc=0)...

This is great, useful code. Thanks for sharing. Are there any limitations with calling stored procedures? I have an index management proc which I want to run in parallel calls....

Here is a code snippet. This is just a small bit of code. Some have many more joins with many of these function calls in the joins and in the...

Here is a code snippet. This is just a small bit of code. Some have many more joins with many of these function calls in the joins and in the...

Good article. Nice explanation of how to evaluate read operations vs write operations to determine a good fillfactor.

I have typically used this method to set index fillfactor on a per...

Nice content. Thanks. I agree, this method is not a fixall or a substitution for poor design. However, given certain scenarios, it is very useful and a concise way to...

OK I installed the 64bit MDASQL provider, SQL Server 2K8 SP1. The provider shows. I am able to create the linked server, but when I try to access Sybase, I...