Hi All,

I have enabled the 3GB switch and also checked the Performance monitoring log: Target server memory and Total server memory.

I have also set the Max server memory to 6GB,...

Hi All,

Thanks for your reply, really appreciated.

My boot.ini file looks like this:

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /NoExecute=OptIn

How will I change it to use the max server memory, in...

Hi Mate,

I had this problem last month, make sure that you sort out the following:

1. Both databases have thesame level of service packs, i.e make sure one isnt older than the...

Thanks for the reply, the file size we are talking of here is around 200GB at one time.

Thanks

When adding files to the actual filegroup, this is the bit where its really slow...

Hi Guys,

Thanks for the reply, its just that normal day set up processes like BCP or even creating filegroups through TSQL takes ages.

Any advice/solution to this problem ?

Thanks

But within a very large database, I want to have the flexibility of backing up individual filegroups.

Does anyone currently use filegroup backup and what has been your experience with it...

Thanks all

With regards to the date column, its a datetime column so I need the convert to roll it up. But I will find a way around that.

Also, its heavily...

on my installation list under sql 2005, I do not have anything that says Client here.

On SQL 2005, I know there is Client Network Utility, are you talking of thesame thing...

Thanks for the reply, this method will simply shrink the log, I am looking for a way to actually reduce the initial size the log file has been set to.

Thanks

There is no calendar table on the database, what exactly do you mean here ?

Also, I am thinking of using a Cursor, as I reckon that might be faster instead of...

I done a DBCC Checktable and it returned 10 consistency errors.

Is there no way i can get all the data on this table out of the system safely

The function will run on a group by which can return over a thousand rows, meaning that the function will be called thousands of times.

At the moment, If I run...

Thanks for the reply

Here is the scenario, during inserts no searches will be done on the columns, but after a day or two, when the insert would have definitely finished,...

I would also like to know which is faster, querying a Monthly partitioned view for a day or the actual underlying table for that day?