Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,726 through 25,740 (of 59,099 total)

RE: Are the posted questions getting worse?

Speaking of "unbelievable", is [font="Arial Black"]THIS[/font] all that a Master's degree + the ability to walk on water is worth nowadays?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 8:12 pm

#1656139
RE: Slow Script

homebrew01 (10/5/2013)
Chris, is this the equivalent of a LEFT JOIN based on 4 columns ?
AND NOT EXISTS (SELECT 1 FROM T3
WHERE T3.COL1 = T2.COL1
AND T3.COL2 = T2.COL2
AND...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 8:00 pm

#1656137
RE: Are the posted questions getting worse?

GilaMonster (10/5/2013)
Jeff Moden (10/5/2013)
GilaMonster (10/5/2013)
A lot of the gaming forums are starting to moderate heavily. Don't think they have much choice anymore, the amount of vile, abusive, hate type comments...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 7:56 pm

#1656136
RE: Create loop to send out emails

Stubby Bunny (10/4/2013)
What I need to do is create a loop that loops through the data to produce an email to send out. the following is sample data. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 7:50 pm

#1656134
RE: Are the posted questions getting worse?

GilaMonster (10/5/2013)
A lot of the gaming forums are starting to moderate heavily. Don't think they have much choice anymore, the amount of vile, abusive, hate type comments was just getting...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 5:32 pm

#1656128
RE: Are the posted questions getting worse?

Stuart Davies (10/5/2013)
Jeff Moden (10/5/2013)
I love the penis enlargement ads... they're written proof that I don't have anything to worry about. 🙂
.
Sorry Jeff - the best one I ever got...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 5:25 pm

#1656127
RE: I need help Please :(

It's going to be very interesting if the company ever adds extra readers. 😉
We're talking about computers here and it always fascinates me that an IN/OUT reader system doesn't do...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 5:22 pm

#1656126
RE: IT Security

Let's talk about the "other side" of security.
From what I've seen on these very forums, most companies shouldn't be allowed to be in business never mind write even...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 4:48 pm

#1656124
RE: MSDB.mdb file is 50GB

obulay (10/4/2013)
When I run the query
http://stackoverflow.com/questions/3927231/how-can-you-tell-what-tables-are-taking-up-the-most-space-in-a-sql-server-2005-d
it only shows the total space of 100 MB.
Did you ever know MSDB on your system to be smaller? What has probably happened is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 3:39 pm

#1656118
RE: Are the posted questions getting worse?

I love the penis enlargement ads... they're written proof that I don't have anything to worry about. 🙂
I agree, Tom. Both moderated and unmoderated have problems. It think...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 3:21 pm

#1656116
RE: Qourum disk running low on disk space

I have a similar problem that turns out to be some rather inefficient code that truncates several very large tables and reloads ALL of the data from an AS 400...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 3:11 pm

#1656115
RE: The Ratio

1:5 for me not including any end user involvement or "Client Data Architects" or Project Managers or BA's or Managers or anyone from NetOps any offsite consultants or any of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 2:50 pm

#1656113
RE: The Ratio

John Mitchell-245523 (10/4/2013)
Two DBAs to about 19 developers. And they insist we handle stuff like backups and restores on development servers for them, "because the DBAs have always done...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 2:39 pm

#1656112
RE: Are the posted questions getting worse?

Grant Fritchey (10/3/2013)
Brandie Tarvin (10/3/2013)
Odd. I don't see your post yet, Grant. Does MSSQL moderate their comments?
Weird. Still nothing. Jeremy must be very unhappy with me.
I hate moderated forums. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 2:04 pm

#1656109
RE: Beginner, Expert, or Both?

I believe you meant "competent" rather than "complacent" in the following...
They're expert beginners, and since they can accomplish the things they're asked to do at their jobs, they think they're...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 5, 2013 at 1:32 pm

#1656106

Viewing 15 posts - 25,726 through 25,740 (of 59,099 total)