Follow up to my above post, here's my code

Create Table

CREATE TABLE TestPartition15m(

[Id] [BIGINT] NOT NULL,

[DateCreated] [DATETIME2](3) NOT NULL,

[Amount] [INT] NOT NULL,

[SupplierId] [INT] NOT NULL,

[PartitionId] AS (CONVERT([TINYINT],ABS(DATEDIFF(DAY,CONVERT([DATE],'20000101',(112)),[DateCreated])%(14))+(1),(0))) PERSISTED NOT NULL,

...

Glad to say hi to you at SQLBits.

qh

How are you observing data mismatch?

qh

Hi Joy

A quick google search brings up plenty of samples (Office/Excel templates) that you can tweak...

Eirikur Eiriksson (6/12/2014)

---

Eric M Russell (6/12/2014)

---

Hollywood should make a film called "A Day Without a DBA" just to show the ignorant public (and cocky app developers) what a total global...

Don't forget any deprecated features or code. (And any DTS packages!)

There is a Technical Upgrade to SQL 2008 R2 ref guide here.

Edit: since you going P2V, you may want...

In my travels as a contractor/freelance DBA I have lost count of the times I have tried to explain to a SAN/Storage admin that databases GROW, some faster than others...

Going to this also (Friday & Saturday), so looking forward to meeting fellow DBAs and learning a bunch of stuff.

Be nice to meet Steve Jones, (and say thanks for publishing...

BobMcC (7/3/2014)

---

Yes, it's a DW environment. However our current business practice of how we load data and report off it don't lend itself to one of the perks of partitioning;...

Indeed, no offense intended.

qh

😀

qh

MysteryJimbo (7/10/2014)

If only it was that simple. What about registering the publisher at the distributor? Enabling replication on the new publisher? Simply restoring with keep_replication will not...

If you do a simple google search Joy, I...

+1 for Upgrade Advisor. You have not really specified any details as towards your existing servers, eg - are they OLTP? Or OLAP? How often are they going...

http://www.freelancer.com

Caveat: I have never used the above site, but looking at the project offers it would seem that is what the OP is requiring.

qh