Re: 170 MB

The SQL Server process in task manager does not show the real amount of memory it has. Since SQL Server is using AWE to allocate memory Windows in...

Take a look at the Hands-On Labs at MSDN.

Naturally, without indexes scans will be necessary, and then the unions will perform worse since two scans are required.

You'll need to create a table (normally a temp table) to hold the results. It must have the same number of columns, with correct datatypes and in the right order,...

Storing all datetimes in UTC is definitely the way to go. The client should be responsible for formatting the output as necessary, incl applying regional settings for timezones and DST.

Why...

Is the index a clustered index? If so my guess is that you have a lot of forward-pointers in it.

Note the WHERE clauses. If we where to select all the rows and just decide if firstname or surname should come first in fullname, then the union would be much...

Agree with Remi, this sounds weird for the database to handle. But if needed I would probably code it like this:

SELECT fullname FROM (

SELECT firstname + ',' + surname as...

If the database is set to full recovery model, which is the default, the log will keep growing until you make a log backup. When the backup is done the...

Can you not just unpin it? Don't know the exact terms for the user interface, but you can pin the windows to always show until you click the X as...

Use Enterprise Manager to generate a script for them, and then run that script against the other server.

In that situation IDENTITY should not be used. If it should ever be used.

No, the 'problem' is not solved by any of those methods. As Remi said above, the only way to guarantee a specific order of the results is to use ORDER...

Sorry, no idea exactly what the reason for this is. It could of course be a bug. But remember that the old system tables of SQL Server 2000 are no...

You can use either SQL Profiler or perfmon to see when files are grown.

Regarding 10% being right or wrong, the general advice is to not use autogrowth at all. Instead...