SQL 2005 x64 will keep grabbing memory as long as nothing else on the system is using it, even if there is very little work for it to do.

But it...

You would probably see a performance decrease by splitting a single drive, because you've probably added a lot more head movement as the disk has to constantly jump back and...

There are complicated permission issues with asking a server to use the Jet driver to open a file on another server.  Try to figure out what the exact issue is. ...

I feel a disturbance in the Force, like the sound of 16 64-bit cores suddenly screaming for more RAM.

On my BOL toolbar there is a group of three buttons between "Help Favorites" and "Ask a Question".  The button on the right is "Sync with Table of Contents".  It...

Your mileage may vary, but we saw duration of large processes drop from several hours to 10-20 minutes after going to a new x64 SQL Enterprise server with 24GB RAM.

Previous...

If you script all database objects and run the script in a new database, you'll find out very quickly which views and procedures are invalid because of references to tables or...

I wasn't trying to be a smartalec, sorry if it came off that way.  I was trying to emphasize that the name you use for the table alias is completely...

The quick answer is that you left out an alias.  Any time you use a derived table subquery you have to name it, so it should look like:

)

That whole subquery is just to generate test data.  Each of the UNIONed SELECT statements generates one record.

You would replace FROM (...) as rents with FROM <renttable>, where <renttable> is...

I ran into the same problem, and I wish I had a good solution.  I gave up on the maintenance plan cleanup task and wrote my own procedure, using "xp_cmdshell...

Your query is too complicated to read and debug.

My first suggestion is to add a derived table subquery to define the common expressions so you don't have to repeat the...

The partitioned table is spread all over your disk, while the tables from the partitioned view are much more localized in the primary filegroup.  The only way to get a...

The only reason we're still talking about this is that the original poster seems to be unconvinced that partitioned tables are superior, and the only reason I can think of...

Why worry about partitioned views?  You can create a partitioning scheme that maps the partitions for each year into the same filegroup (presumably PRIMARY).  Then you have one table, one...