rocky_498 (9/21/2012)

---

Hi Guys,

Here again, This Cursor and Procedure runs fine with no Problem, if i schedule in morning around 5:30am.

Now i have question is how i can receive...

The clustered index does not have to be the primary key. Yes, Microsoft recommends that all tables have a custered index. It is even suggested that this index...

CELKO (9/21/2012)

---

Celko won't like it because recursive CTEs are a Microsoft specific extension to the SQL syntax. By all means read his book (or any other posts on...

I have seen it where once a week is good enough, but i have also seen it where it needed to be run every two hours to keep the application...

Abu Dina (9/21/2012)

---

as I said, this one question could last an entire interview.... it all depends on how nasty the interviewer wants to be!

I'm sure some expert will come along...

I understood that you were...

I prefer to backup disk to disk and let network backups backup those files to tape.

Plus, we usually keep one or two weeks of backup files available on the network...

PiMané (9/21/2012)

---

Entire table and indexes locked?!

Isn't there a way to lock only a row or...

PiMané (9/21/2012)

---

GilaMonster (9/21/2012)

---

SQL does not lock at the table level by default. The locks it takes are based on the amount of data the operation needs, the amount of other...

Still like to see the ddl for the table snd some sample data.

Sean Lange (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

Okay, a non-cursor way to accomplish this same task:

declare @SQLCmd varchar(max);

select @SQLCmd = (select 'exec insert_sp ' + cast(md.sid as varchar) + ';' + char(13) +...

I'd start with the sys.server_principals (server level) and sys.database_principals (database level, in each database) system views. Look these up in Books Online for more information on them.

SomewhereSomehow (9/20/2012)

---

Lynn Pettis (9/20/2012)

I simply refuse to provide him any financial gain from any book I may purchase. His total lack of professionalism that he has demonstrated on this...

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

...

Luis was able to help because at the time he had no opinion of me or the thread and wasnt...

SomewhereSomehow (9/20/2012)

---

Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as I like...