There are multiple articles at SSC that may be of your interest:

- Generating Missing Dates and Numbers By Jacob Sebastian http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/

- The "Numbers" or "Tally" Table: What it is and...

I mostly use SQLServer Management Studio to get to my SQLServers.

But I'm a dba and rarely developer.

With regards to your Access conversion:

- Keep in mind Microsoft has a tool that...

raid is not mandatory !

However .... if you have no raid volume for your sqlserver databases, it is game over if you lose the drive, where with e.g. a raid1...

george sibbald (10/4/2010)

---

🙂 ah such an optimist! I do not think so but if it...

Did they benchmark TVF vs scalar functions vs CLR functions for this case ?

Thank you for the feedback.

Can you provide some performance data of their tests and chosen solution ?

Grant Fritchey (10/2/2010)

---

It depends on how your views are put together. If they're all simply "SELECT *" type of views, then they more or less fix themselves as they are...

What your are trying to do is a piecemeal restore.

(ent edtn / dev edtn needed )

ref: http://msdn.microsoft.com/en-us/library/ms177425.aspx

check Restore headeronly in BOL.

It provides the info you need.

You can use it this way:

if (select isnull( object_id(N'tempdb.[dbo].[#Tmp_BackupHeaders]'), 0)) <> 0

begin

DROP table #Tmp_BackupHeaders

end

-- versie SQL2K5 sp2

create...

please post your configuration settings "min server memory" and "max server memory".

On every 64-bit os, you should set the max server memory or else it may grab all ram.

(the...

If you're going for the choice to copy the table to a staging table scenario, keep in mind to re-link all objects that are related to or have been related...

Adi Cohn-120898 (9/28/2010)

---

I have to admit that I don’t agree with ALZDBA’s opinion. It is important to know and realize what clustered index does and how dropping it and\or...

How is this for a coincidence ... just today ... converting another db to sql2005 .... data_purity messages ....

my query only captured 7 rows of the 68 rows reported...

digdave7 (9/27/2010)

---

...The end goal here is to shift the clustered index from the GUID to the BigInt column, if we can avoid dropping the indexes and migrate them, as you...

sandy-833685 (9/27/2010)

---

Thx,

But its not hardcoded its an value which is stored in variable which is having a datatype as datetime. and after going through certain select and execution stored procedure.And...