For now I am running:

Microsoft SQL Server 2005 - 9.00.3282.00 (X64) (Build 3790: Service Pack 2) . Can I lock the page in memory? I am...

Well I found out that datediff seems to do what I was looking for.

Thanks all for your help. Appreciated.

This seems to be a good approach, but some year have 52 weeks when some other have 53.

What I need to do it's adding a new volume to my table...

This is very interesting. But I will need to run this in two steps, since the date prior the current date need to be negative and after positive.

How I...

Thanks willtwc.

But if it's on the same RAID10, will I see performance improvement by doing this? I was told that If I create a new datafile (& Filegroup), they...

Hey Carlton, Thanks for the definition of CTP. 😛

I just wanted to know if someone knew the ETA for the production ready version. :unsure:

Do we know when Microsoft is planing to release a version after CTP?

Thanks Derek,

This is in a dev/test environment. So SP4 should be okay.

Thanks.

But this message appears ore the 24 hours after the restart of the SQL Server, not at the time of the restart itself.

As of now, sqlservr.exe is using 4,732,828K.

I know that SQL Server is not guaranteed to allocate the amount of memory specified in min server memory. If the load on...

The total physical memory in K seen in Task Manager is 16771100. This means it's ok, right?

It is a standalone SQL server where I have only 1 instance of SQL 2005 (default not named).

I was told that the in-place install feature is pretty stable. It...

Hi George,

I was out of town for a few days. I will need to dig in this query. I am more used to work with Sybase. The resource...

I am using the trimester for financial purposes not medical. Thanks for bringing this point...

Hi Adam,

Thanks for your reply. Currently I am running something similar every night to kill my connection. I would like to *** the table level to this. ...