You do need the log file. That's what the error message is telling you, the log file is not an optional part of the database.

Restore from your last good backup.

Simplifies the parser, makes it easier to extend the language. T-SQL's getting to the point where it's hard for the parser to...

I think my cell phone has more than 8GB...

SSMS doesn't have a T-SQL compiler. When you ask for a piece...

Jason-299789 (11/14/2014)

---

Gail/Lynn/Ed,

I don't disagree, and as Lynn states maybe if MS enforced it so that code wouldn't compile without the use of the statement terminators, like they do in C#/C++...

Lynn Pettis (11/14/2014)

---

Can't remember it off the top of my head, but there is another statement added in SQL Server 2014 that states the same requirement, the preceding statement must...

Then stop wasting your time looking at...

Table definitions, index definitions and execution plan please?

If by 'some time' you mean 'a few minutes', then yes. Otherwise no.

Ok, so the posted code is not the code that's failing, but an edited version...

In the other session (where it doesn't run), is there an existing temp table created with matching names? You won't get a create table error if there is, SQL uniquifies...

Only supported as part of...

Ok, so what's the goal of the partitioning? Fast load? Parallel load? Index rebuilds at the partition level? Partition switching for archive/delete of old data?

Luis Cazares (11/13/2014)

---

g.britton (11/13/2014)

---

SeanNerd (11/13/2014)

---

My question is about indexing strategy for the following scenario:

I have a table where we cannot use the typical int identity primary key column. The table...

.Well they should start doing so .The trend over the last few versions is...