Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,526 through 24,540 (of 59,099 total)

RE: Help finding an old post

Heh... my Dad said something similar. "More than 30 articles? Sounds like a 30 chapter book to me".
There's no way I would have gone from being...
--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)

February 1, 2014 at 8:10 pm

#1685329
RE: The DBA is Dead

I put predictions of the "Death of the DBA" right up there with predictions that the Y2K problem and the end of the Mayan calendar were going to be the...
--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)

February 1, 2014 at 7:50 pm

#1685328
RE: SQL Best practices, policies and code-smells.

David Atkinson (1/29/2014)
Is anyone actively using any tooling (free or commercial) to help with T-SQL best practices?
WHOSE "Best Practices"?
--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)

February 1, 2014 at 7:40 pm

#1685327
RE: SQL Best practices, policies and code-smells.

I could rant for a couple of hours on the term "Best Practices" but I won't put anyone through that. Suffice it to say that I've become more than...
--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)

February 1, 2014 at 7:39 pm

#1685326
RE: Help finding an old post

Heh... correct. :blush: I really don't have 2K12 installed anywhere to mess with. I have a copy of the Developer's Edition sitting on my desk and I haven't taken...
--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)

February 1, 2014 at 6:43 pm

#1685324
RE: Need to query db to return all instances for Canada. (Country, State, City)

Except for the unnecessary verbosity caused by 3 part naming instead of the preferred 2 part naming (use synonyms instead of 3 or 4 part naming), it seems ok as...
--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)

February 1, 2014 at 4:41 pm

#1685323
RE: Please help me with this year(date) totals comparing to column values in same table

You're requirements are a bit difficult to understand and the code for the inserts for #Tab2 is broken. That may be the deterrent to most folks here, not to...
--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)

February 1, 2014 at 4:29 pm

#1685320
RE: Newbie needs a little pointing

Thanks for the feedback.
--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)

February 1, 2014 at 4:03 pm

#1685316
RE: Help finding an old post

I'll save you some time...
I don't currently have a 2K12 machine available so I can't demonstrate the LAG method (I don't like to post code I haven't tested) but the...
--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)

February 1, 2014 at 3:33 pm

#1685314
RE: Help finding an old post

sqldriver (2/1/2014)
The one I have in mind had solutions from all the big guns.
BWAA-HAAA!!!! Was I there? 😛
Also, Michael, I'll see how your solution adapts when I have...
--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)

February 1, 2014 at 3:20 pm

#1685313
RE: using a user defined function in a view - need help

Sure but the price you have to pay is to listen to a lecture first. 😉 Don't be offended by any of this. Rather, think of it as...
--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)

February 1, 2014 at 2:53 pm

#1685311
RE: Newbie needs a little pointing

Gosh. Sound like you don't actually need anything other than a simple REPLACE for this.
--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)

February 1, 2014 at 1:17 pm

#1685305
RE: Adding to SQL Server

Let me preface this rant by saying that you've hit a real "sweet spot" for me. I'll also say that I wouldn't trade in SQL Server for any other...
--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)

February 1, 2014 at 12:59 pm

#1685304
RE: How to Remove login limit in Windows server 2012 SP1

If you're actually talking about remote logins via "Remote Desktop", I believe your out of luck.
Why not just set it up as a normal server on the domain...
--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)

February 1, 2014 at 11:50 am

#1685298
RE: Help finding an old post

sqldriver (1/30/2014)
Hi,
A while back I recall reading a post on here where a user needed to update a column with values until there was a new value, then update with...
--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)

February 1, 2014 at 11:46 am

#1685296

Viewing 15 posts - 24,526 through 24,540 (of 59,099 total)