Jeff, thought you might reply to this :-D. I've read a number of your posts trying to wean us off cursors.

I think we're on solid ground here as I need...

Thanks Florian, seems I missed that when looking thru BOL. Will try a static cursor.

Ken

I guess I've been used to being in standard payscales in larger companies that seemed fair. Though I must say at a smaller company I stumbled across the salaries of...

So much of performance and value is subjective in our field. I probably make more mistakes than my coworkers but I also get more done. That's because I take initiative....

David.Poole (5/19/2009)

---

From that point on they simply do the 9-5, do what they are told and no more. Go with the flow and game what ever daft metric is...

Gilles Willard (5/13/2009)

---

Don't mean to sound like a wild-eyed proselytizer, but THE way to both prevent back trouble and take care of it when you already have it is yoga.

I...

"You wouldn't expect Lebron James to be able step into a Cleveland Browns uniform and play quarterback."

Actually He does play for the Cleveland Browns...... in a commercial in his dreams...

NoKoMo (5/8/2009)

---

Naming conventions. It seems a rather difficult task for most to name the tables and fields in a way that would make logical sense - thus supporting readability....

Wow, found this 4 years later! A helpful way to quickly get our procs and tables saved into text files off to a backup drive.

Thanks,

Ken

I made a slight change in mine to take into account an Offline DB:

insert into @dbs

select name from sys.databases where state_desc 'offline' order by name

Ken

sue (1/29/2009)

---

SQL Server Central is an incredible, reliable site on which I depend each and every day in the quiet isolation of my cubicle....and to think that there are another...

fuller.artful (1/5/2009)

---

In my early days, I was a "cowboy coder". I learned my lessons. Now I write a comment header for every module before I write a single line of...

Thanks for the script Jorge; it's timely for us as we're going thru the very issue now of large transaction logs. For us, setting the access mode to single user...

Jeff Moden (12/5/2008)

---

Sorin Petcu (12/5/2008)

---

Oh, I hate smoking and its effect!! There are many peoples here where I am working who go out of the building and smoke. This is...

david.murden (12/5/2008)

---

skjoldtc (12/5/2008)

---

It is the excesses that make life interesting and enjoyable. It is also what makes life potentially shorter. I would rather enjoy an excess of something now even...