I think it goes back to before backup with truncate only was depcrecated. Switching to simple then shrinking the log file then switching back has pretty much the same...

How often are you running full/diff backups compared to transaction log backups? That would determine how long you need to hang onto your old tlog backups before you can...

Robert Mark (10/30/2014)

---

I don't know how anyone using an application and seeing a NULL value on the screen would equate the NULL value to anything other than a zero. ...

Robert Mark (10/30/2014)

---

I have two other considerations for NULL vs NOT NULL.

1) If you're application coding language requires checking for null values when you read in data from the database,...

radman_bobbin (10/30/2014)

---

I'm not sure that your example that Address_2 should allow NULLs is particularly convincing.

The approach I was taught (and still follow) is that if NULL "means something" in relation...

It looks like your join criteria might be too loose what's happening is that if you already have say two records in your archive table with the same student id...

Not that I know of, but if you're cool with losing data from the result set you can just pick a top X row count you know won't exceed the...

Couple questions, how wide is the table? And how long does just the select take(no insert)?

Do you want to limit the actual number of characters in the database or just the number of characters that get displayed?

Just out of curiousity is the cost of getting all this set up hardware, licenses, dev time...

Nice question, it's not trivia and it doesn't rely on intentionally misleading syntax.

Start telling anyone that complains about the problem that it's working as intended and they need to be...

ISNUMERIC doesn't necessarily mean it will convert successfully to a decimal.

SELECT ISNUMERIC('$123.5')

SELECT CAST('$123.5' as DECIMAL(19,2))

Do you have any kind of identity column or something that would indicate the order that rows were added in? At least then you would have some kind of...

Your application is opening a connection and never closing it, that could be intentional, they expect they'll use the connection again at some point, or just sloppy coding, they're not...