Tom.Thomson (8/1/2011)

---

Bad day today. Needed telephone for various things (could use mobile, but (a) expensive and (b) no loudspeaker and area mike so wife and I couldn't have joint...

Take a closer look at the database roles.

Don't be scared. Yes, there is a learning curve but use your knowledge...

staindshady_03 (7/26/2011)

---

to count days as half or full. for example if you do a datediff between two dates, it counts the difference but it doesn't count the date you start...

Why? What is the business case for this...

Just to add a little more (and this isn't Oracle bashing, just what I am learning), you will find that you will develop your code in packages instead of as...

staindshady_03 (7/26/2011)

---

I understand this, I guess I just wasn't being clear. Maybe if I illustrate a scenario that would explain it better:

____________________________________________________________________________________

StartDate ...

What I see is that you don't understand what the DATEDIFF function is doing. To help you, please read the following article: DATEDIFF Function Demystified.

Depends if you are moving from a development position to a development position or a DBA position to a DBA position.

Overall, yes the concepts are the same. As a...

Count me in.

Toreador (7/26/2011)

---

Lynn Pettis (7/25/2011)

---

It does now, but didn't originally. The problem with making corrections to...

Can you provide information regarding the installation of SQL Server on the two nodes?

dawalker-1068762 (4/14/2010)

---

I don't know if this is an option for you or not, but you can also use a "select into" and that is not logged. We do that with...

sknox (7/25/2011)

---

sjimmo (7/25/2011)

---

In one run against a table with 700M rows, I receive 4513066 rows covering all dates where number = 1. In the other I receive only 13935 records...

Look up Server-level Roles and Database-level Roles in Books Online.

If those two topics don't help, let us know.