This is a very good point. This is where the hardware architecture makes a difference...

For instance, on an ES7000, you could affinitize SQL Server to run on only 12...

Just a little comment regarding your article: you do not need to have both /3GB and /PAE in order to enable AWE. All you really need is the PAE switch...

Actually, the use of PAE alone should not cause any issues. All you are doing is tell the OS to load a 36-bit version of the kernel (as opposed to...

One more thing:

In high availability environments, the typical load is not of much importance. What is important is the amount of time SQL Server (or another process) tops the CPU...

You may be really surprised about this (as I was), but there is a way...... actually I found this by mistake.

Create an instead of trigger, and recreate the INSERT statement....

Hi Nickel,

It depends on your RelatedId field. Does it reference the original ID created of your p_cat='01'? If it always does, then your query will work regardless on how many...

I don't know if this can be generalized, but you can do this:

Declare @s-2 varchar(255)

exec master.dbo.xp_getnetname @s-2 OUTPUT

Select @s-2

The @s-2 variable now...

Just one thing:

It seems that your transactions/sec calculation include the Count(*) from the Test_Transaction table, which I am assuming is not something you want to measure other that for the...

Yes and No. As you mentioned, if you want to bypass a variable, you will have to state in you INSERT SQL which parameters you want to use such as:...

To answer you question, using chars to insert into a date field should not be a problem (when used like this). Actually, when you pass dates from a client application,...

One more option:

Try creating a new database from scratch (with fresh system tables) and recreate your tables along with the data (either through a transfer or a script).

I had...

This is a great article. Certain DBAs are reevaluating their skillsets as a result of the next release of SQLServer, Yukon. Yukon will be deeply integrated within the .NET Studio...

Daniel, thanks for your input and your feedback.

I agree with you. Actually, I have seen cases where so many locks exist on small and static tables that the application...

Thank you Jon. Good questions - let me try to answer them.

Actually, it seems that SQL Server can interact with normal DLLs. However, the DLL's functions have to be exported...

Yes you are right. There are many ways to skin a cat. And sp_OACreate is definitively a good alternative.

To answer your question, I prefer not to use sp_OACreate when...