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...

sqldba_newbie (4/23/2012)

---

GSquared (4/23/2012)

---

I'd have to see the reason for the Union All statements (evident from the query, most likely) to be more specific, but if it's all coming from one...

Straight up, I wouldn't consider a job that required special access to my Facebook account (I don't have one) or personal life. That's just a red flag... coming from the...

Carlaabanes (4/23/2012)

---

hi, how 'bout in my case? i wanna go back to being an sql ninja in the back seat. you see i was a dot net developer for some...

selvakumar.sms (4/17/2012)

---

hi all

i am very new to sql server admin. so please suggest some very good books and sites to learn basic and advance of sql...

You can use the xp_logininfo procedure to returns information about Windows users and Windows...

You mentioned that you've been using Text Search engine in the past, so this advice assumes that at least some of your routinely searched terms are contained in text columns....

shahgols (4/16/2012)

---

Thank you very much for that information!

I have already created that user using code, and it still cannot log in...that's what I see in SQL Server logs. It's...