You are correct, the 'n' in nchar, nvarchar and ntext indicates that they are used for Unicode and means two bytes storage for every character. The standard practice is to...

You will need to supply more information in order for anyone to help. Could you post the query, DDL and sample data?

The lazywriter should normally be able to keep free space in the cache. As activity increases and the amount of free space gets lower the lazywriter will work more often....

My first article at SQL Server Central discussed this: Advice on using COUNT( )

As David says, COUNT(*) or COUNT(1) (or COUNT(9917456) or whatever) will be treated exactly the same...

Ok, I'll test later if I get the same behaviour. I am not expecting it though, usually there is something else behind these problems. Anyway, you can also check

What do you mean by "without using xp and components only using sp". T-SQL in itself has absolutely no functionality for this (of course). You could use the sp_OA* to...

I haven't had the time to read it yet, but I noted that Rushi Desai made a blog post about replacing an MSMQ q with a service broker q.

Can you specify exactly the steps to reproduce this? Since you are seeing it on different boxes I guess you have encountered a bug, and the only way to get...

No, you will need to add EXEC rights for procedures explicitly.

Ken Henderson just posted a very good blog post describing these dangers.

Well, dangerous can ean different things, but in a way yes. The sp_OA* procs have always been known as 'troublemakers'. First of all they themselves have had several fixes for...

And since I am anticipating a follow-up question, if you need the row with the column name to be the first one in the result set you should add an...

SELECT 'SampleField' AS SampleField

UNION ALL

SELECT SampleField

FROM ...

Note however that this requires the data in the column SampleField to be of the varchar (or similar) type.

I assume you are talking about usage statistics for the server. Using SQL Profiler you can trace activity in SQL Server, but that does have some effect on the performance...

Yes, I remember I had problems before I disabled the wysiwyg editor. Another thing that is annoying is that the Port Reply-button (when viewing a thread) opens in a new...