What is the SQL Server Edition?

You said "Windows Server 2008 SP1 64-bit"

What is the Edition? Is it Windows Server 2008 or Windows Server 2008 R2?

What are the results from this query?

select

[OBJECT_NAME]=

left(quotename(rtrim(a.[OBJECT_NAME]))+

quotename(rtrim(a.[COUNTER_NAME]))+

case

when rtrim(a.[INSTANCE_NAME]) = '' then ''

else quotename(rtrim(a.[INSTANCE_NAME])) end

,60),

[Memory GB]=

convert(decimal(10,3),round((a.[CNTR_VALUE]+0.000)/(1024.000*1024.000),3))

from

master.dbo.sysperfinfo a

where

a.[OBJECT_NAME] in ('SQLServer:Memory Manager')

What is the Version/Edition of SQL Server? 32-bit or 64bit?

What is the Version/Edition of Windows? 32-bit or 64bit?

You can do this with the "SQL Server Configuration Manager".

Mani-584606 (11/5/2012)

---

Thanks Jerry,

We have only one production ORACLE database with 6 schemas in it and having this makes database maintenance is very easy as application works great.

For example set up...

Mac1986 (11/4/2012)

---

Then can I drop and recreate the DB with My choice of data files?

But wait a min the how can I restore the data if its not possible..

What...

More on the whole can't use IDENTITY "requirement".

Just be aware that IDENTITY is for doing exactly what you are trying to do here is for, and will perform much better...

Jeff,

I see a couple of minor issues with the function:

1. Results may be a little off if the @DOB and @Now are not exactly set to 00:00:00, so I recommend...

Stefan Krzywicki (11/4/2012)

---

Here's a fun thing, in case anyone happens upon this thread.

If your job is scheduled to run once a day at 2AM, it will indeed run twice if...

The key to finding age is to find the birthday for the current year, and subtract 1 from the difference in years if the current date is before the birthday...

The OP posted this question four years ago.

You should not cross post.

Question answered here:

http://www.sqlservercentral.com/Forums/Topic1380756-391-1.aspx

No.

A restore will create the same number of files and the same file sizes.

scogeb (11/2/2012)

---

Michael Valentine Jones (11/2/2012)

---

scogeb (11/2/2012)

---

I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has...

I have seen that happen many times, and it was always due to poor IO performance.

You would think that newer would be faster, but that is often not the case....