Batch file is nothing but simply a Text file which contain bunch of data/records/commands. 🙂

As far as I know price is same for 32 bit and 64 bit but better check with the vendor.

just try with b.id = a.id

Author could have eliminate the answer option "Error Message" from Question.

Question asked do not mention anything about table tblUsers

When executed the query ;

WITH Users(UserID, UserName) AS

(

SELECT TOP 1 intUserID, strUserName FROM tblUsers

)

SELECT TOP 2 tblUsers.*, Users.* FROM tblUsers, Users

Reults...

As suggested by Gila it would be gerat if you can shar the performance data.

However SQL Server is running TB of data and billions of rows in a table without...

SQL will run smoothly for 250 GB of data on 8 GB RAM depending your application and load.

First of all let me tell you that it's not always correct that...

I am not sure what you actually looking for?

following will give you the details of the created partition fucntions.

SELECT * FROM sys.partition_functions

HTH

Hello EdVassie,

Thanks for sharing this in detail 🙂

I was not sure about the master and done the location change for all systemdatabase. I was fortunate that nothing happen and everything...

SQL Server 2005 Standard & Enterprise Edition supports Operating system Maximum RAM.

Except occupying a little disk space; which won't bother you 😉

Provide more and specific detail like What OS version and edition you will be using and what SQL Server edition you are considering?

role SQLAgentUserRole will able to perform this considering he owns the job. Refer the following link for further detail.

http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx

HTH

For production environment it's not advisable to put change recovery model from Full to Simple to shrinkfile. If you do so you need to take Full backup ASAP.

I do not think for DB which is in Simple recoevery will help.

But you can do the same for Full recovery DB if you wish but make sure you...