That's not true, Scott.  Not that you should but you can go back to the FULL Recovery Model from the BULK_LOGGED recovery model at any time without any kind of...

Thanks, Erland.  Interesting use case for the year/100 stuff.

Again, though... they don't need to be full backups.  They can be diffs to save some time and, possibly, reduce the size of backups.

I use 2 monster .sql scripts to answer SSC/SO questions.  One currently has 13,787 lines and contains 32 occurrences of 'fnTally' of which 24 specify the sequence begin with...

out of the normal but in a particular application from one of my clients sequences always started at 1000.

And on a similar situation, multi-tenant, each tenant would start at...

That's not a bad idea.  I think I may actually have a copy of that database, now that you mention it.  Heh... if nothing else, it would make for good...

Getting back to Itzik's challenge, I had a question form in my mind.  As a pre-amble to the question, I've found that I use "1" as a starting...

Hi, Still kind of a newbie to SQL Server. Anyway I have two tables: tblStaging and tblWorking. The staging table is updated every 15 minutes and I need to...

If you actually need a sequence, then we have a CREATE SEQUENCE statement in the language I need to just generate a set of integers then I would use

SELECT...

To be sure, I don't see any temporal queries in section 2.1... just the construct for your million row table.

Section 2.2 has a couple of temporal queries where you use...

how often have you needed to generate a sequence that started with something other than "1" or "0"?

I guess about every time when I wanted a sequence of something...

We differ in opinion only on whether or not using the Bulk Logged or Simple Recovery Model would be a "Pyrrhic victory" victory or not.  I'm simply not...

p.s.  Just in case there's a question about where I stand on this, I DO absolutely agree that taking a dif backup before and after Minimally logged rebuild should be...

I could be wrong but, from your description, it seems to me that you've not identified what the I/O contention is being caused by, yet.  I/O contention is usually a...

Those are really good questions, Scott.  First, I agree that the differentials are a great idea whether you're in the BULK LOGGED or SIMPLE Recovery Models.  Better to be safe...