I'm not sure how they plan on getting a lot of developers either. They're throwing the .NET DevConnections (ASP.NET/Visual Studio/SQL Server/Sharepoint Connections) in late April, also in Orlando. Paul...

Steve Jones - Editor (2/14/2008)

---

But there's a default in code as well. If you don't specify it, meaning just create an index, it's non-clustered.

I agree with you that people need...

Also - just so there's a distinction: synchronous mirroring and replication (synchronous) are not backup solutions. They're High Availability solutions.

Meaning - your backup scenario doesn't get replaced...

Steve Schmechel (2/14/2008)

---

Where I work we embed databases in our products. Often, before the user requirements are even fully understood, database developers and code developers (who know enough about...

Well - neither is going to do incredibly well if you consider that this has exponential growth (2 then 4 then 8 then 16 then 32) written all over...

I don't know if this helps you - but if you use the data conversion task to attempt the conversion - there's a "red arrow" coming out of it which...

Well - I meant it's a problem in that...

Can you not store the previous ID in a separate column in the main table? considering this is now going to generate what looks to be duplicate rows in...

Steve Schmechel (2/14/2008)

---

If you dig a little deeper into agile development you may find that often the early parts of a project don't require a relational database at all. ...

if you don't store them in a datetime, you won't be able to add them up easily, or substract, etc. your minutes will always need so be adjusted and...

As far as I know - the downloads are available, but only to a few. I suspect it's the licensing issue that is preventing this from being more widespread.

On...

Regarding my previous example, did you run profiler with the SP:StmtStarting event selected? That is the only event necessary to see the behavior. When I run the select statement with...

Cool - something to add to my reading list....I'll have to send him a stern talking to about orphaning blog readers like that! (I'm so sure he'll care about that.....:P)

Thanks!

Matt Marston (2/14/2008)

---

However, I do stand corrected, that in practice, it appears that SQL Server (at least when I test it on SQL Server 2005) also does further optimizatition depending...

Frances L (2/14/2008)

---

What is the purpose of

sum(case when b.Status = 1 ...