Using LoadDate as the leading column in primary clustered key makes sense in a table containing historical rows, because it's sequential (I'm assuming it's based on system date at the...

When tables and indexes are created, their internal data structure is effected by whatever collation setting was currently in effect. Similar to Fill Factor, I believe that after changing the...

Personally, I don't own an iPhone, Android device, or whatever. If I did, I'd keep my Hotmail or Gmail account stuff in the cloud and not have it setup to...

This is a good script.

One suggested addition would be a 'schemaname' column. When I'm unit testing in Development, I often times have a different version of the stored procedure...

LadyRuna (5/7/2012)

---

From examining several phones belonging to various people, I have determined that the "fingerswipe password" is essentially useless as security. It can perhaps prevent someone from accidentally opening your...

If a theif gained access to someone's smart phone, I'm sure they would be more than just a little curious about what kind of junk would be stored on it....

Does the password encrypt the critial data files on the iPhone, or is it just a means to prevent someone from accessing the folders via the operating system?

If the...

peter-757102 (5/3/2012)

---

rmechaber (5/3/2012)

---

peter-757102 (5/3/2012)

---

They are unable to model their data properly and often do not handle escaping well, causing errors in individual elements. But XML escaping is extremely simple and...

XML is good for exchanging data at the application level, but it's not very efficient for data storage in the database or exchange between two databases. That's why most DBA's...

Revenant (5/2/2012)

---

L' Eomot Inversé (5/2/2012)

---

. . . So, I think the plus side of being able to let the machine do some of the grunt-work for us greatly outweighs the...

If a good engineer actually wants to move into a magerial role, then that OK, but it's not necessarily a logical progression. There are other ways to reward good performance,...

Most sales professions get paid on commission, so it seems to me that a company's "best" sales people (those who consistently open a large number of high value accounts) should...

Yeah, replacing the DBA with a piece of software, is like replacing a personal trainer with an exercise video.

rarara (4/25/2012)

---

thanks for the advice guys.

just to clear up the cursor/trigger issue (:blush:) it was along these lines, fairly standard i thought:

[font="Times New Roman"]SET NOCOUNT ON

DECLARE c_item CURSOR...

rarara (4/19/2012)

---

hi sean,

sorry - its difficult to describe.

the vendor told me of a SP which should be running (but isn't) and it does two things:

1) delete from table_A where ID...