Any time you need all of one side of a datum, even if the other side is missing.

All customers and prospects, even those who haven't placed orders, and orders data...

venoym (8/14/2012)

---

GSquared (8/14/2012)

---

call.copse (8/14/2012)

---

GSquared (8/13/2012)

---

...

If a table has X columns, and the default for LINQ is to call all columns (equivalent to Select *), which it is, adding a column...

Mad Hacker (8/14/2012)

---

I feel that there's a tradeoff in going either route. In my opinion, ORMs may be better suited for prototype apps and smaller and/or short lived database...

Nah. ...

call.copse (8/14/2012)

---

GSquared (8/13/2012)

---

And even then, on simple queries, it has to assume no underlying database object will be changed without also recompiling, redeploying, etc., the code that accesses it.

If a...

At the very least, we'd need to know what the trace definition is. What events is it capturing, and what characteristics of them?

CELKO (8/13/2012)

---

if you need to be explicit about that, then DateCE would be a better column name. [] Or name the table CalendarCE and use Date as the column...

Can you run a server-side trace, get the command that's issued at the beginning of it, and see where that's coming from? Won't give you a job name, but...

Had a belated thought on "portability", too. Just to be contrarian.

A database accessed through a .NET DAL, or JAVA DAL, you may be able to swap out the data...

TravisDBA (8/13/2012)

---

When the data access is direct from the app, embedded T-SQL in VB/VBScript/C#/whatever then all I can often do is advise the client on how their developers need to...

Lynn Pettis (8/13/2012)

---

This is how I would code it. Also note that I am using sys.indexes, not sysindexes.

IF EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')

...

CELKO (8/13/2012)

---

I disagree with the statement that "date", as a datatype, should never be used as a column name. In a calendar table, it makes total sense to...

Any reason to not use the "With Drop Existing" option on Create Index, instead of an explicit drop?

The first step is to make sure your boss, and everyone else, knows who you are, what you are there for, and to find out from them what they expect/want...

call.copse (8/13/2012)

---

TravisDBA (8/13/2012)

---

Here are just some of the reasons that I use stored procedures:

Security

The first ...

Performance

Parameterized queries are ...

Organization

Stored procedures encapsulate the logic of accessing and retrieving data...

Maintenance and...