I have an old PIII 450MHz lap top and don't get the problem no matter how many windows I have open.

Mind you I do tend to use Firefox rather than...

TEMPDB is a special case that is used for a variety of cases so you don't need any specific permissions.  You will notice that there is a guest user in...

If your first few steps only take a few seconds then I would use temporary tables or table variables and have a stored procedure return the records you want in...

Not as the script stands.

sp_spaceused has an @updateusage parameter and to use that you either need to be the dbo or in the sysadmin role.

I've not used it here so...

The only way I can think of doing it would be to save the DTS package rather than use the "Run Immediately" option.  You could then edit the CREATE TABLE...

CREATE TABLE #TableSize(

 TableName SysName,

 NumOfRows Int ,

 Reserved VARCHAR(10),

 Data VARCHAR(10),

 IndexSize VARCHAR(10),

 Unused VARCHAR(10)

)

DECLARE @sNextTable SysName

SET @sNextTable=''

WHILE @sNextTable IS NOT NULL

 BEGIN

  SELECT @sNextTable = MIN(Name)

  FROM dbo.SysObjects

  WHERE Type='U'

  AND Name > @sNextTable

  IF @sNextTable IS NOT NULL

   INSERT...

Are the apps all accessed via a browser?  Could you put a block on all access attempts that don't originate from the web server or IT computers?

If the apps connect via...

Provided your index statistics are up-to-date and you have a primary key and/or clustered index on your table then the following query is the quickest way of getting a row...

Check the table and indexes.

If you don't use double-byte characters then replace an NVARCHAR, NCHAR, NTEXT columns with VARCHAR, CHAR, TEXT equivalents.

If you have these columns then not only will...

SELECT *

FROM t

WHERE CONVERT(CHAR(6),t.testdate,112) < CONVERT(CHAR(6),getdate(),112)

I would say I agree with 45%-50% of what is in this article.

For example, I wouldn't create scripts that use the fully qualified object name i.e. database.owner.object because that means...

I work with a variety of web CMSs and one of the things they share in common is a config file that allows me to switch their own internal logging...

I have got to ask what "Quand on parle du loup, on en voit la queue " means.

My French was limited to asking for bread and milk so I seem...

I seem to remember a configuration setting that sets the maximum query cost.

I'm at home at the moment so don't have access to BOL or a server to tell you...

I'm a self taught Visual C++ programmer.

I have never managed to get any of the example xp sources to compile and I believe it is down to the configuration of...