BL0B_EATER (10/6/2015)

---

I wish I was Peggy, I pay for my own training courses and use annual leave to attend them and still respond to people on my time off. To...

Thanks Rodders,

I'm in Portland for a few days before Seattle, and won't be there until Tuesday.

At SQL Pass there's usually an SSC night. I'm certain I saw mention of it somewhere but can't find it again.

Could somebody tell me which night it is? Then...

ps_vbdev (10/1/2015)

---

Thanks,

I thought i read somewhere that you can move data from one partition to another. So in my example at the end of the year all the data in...

If I've understood correctly, then option 2 isn't possible. I believe MySQL allows partitions within partitions but I've never looked at it. With SQL Server you can have one partition...

I've been to Canada more times than I can recall - maple with pretty much anything. Maple with...

Edvard Korsbæk (9/29/2015)

---

Thanks both!

snapshots seems to be the answer to my question.

Seems like the examples in the first answers makes it possible to use my express edition, where solution two...

The Pass Summit schedule is now available:

http://www.sqlpass.org/summit/2015/Sessions/Schedule.aspx

Have you looked at snapshot backups?

http://wp.me/p3Vxvi-1P

That sounds like a nightmare to administer. Do you really have such a varying range of permissions that you'd need a DB account for every user?

In reality I suspect you'll...

kyagi.jo (9/4/2015)

---

Hi,

I am thinking of migrating one of my databases and implementing partitions, and using partition switching to load data quickly, so I'm reading up about it.

For the most...

Are there any error messages in the job history?

If so, can we see them?

What's the difference between 'None of the above' and 'Other'?

I had to pick that apart to understand it - it is very...

I'm sure there are other ways to solve this, but this is what immediately sprang to mind:

WITH CTE AS (

SELECT machineid,

COUNT(machineid) AS IPTotal

FROM testip

GROUP BY machineid

)

SELECT...