Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,771 through 25,785 (of 59,099 total)

RE: ORDER BY, Bad form?

BAAA-HAAAA!!!! What the heck... here's what I call the "Half Blind and Crazy" method. You see why it's "Half Blind" and it's "Crazy" because you really shouldn'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 2, 2013 at 12:11 am

#1655118
RE: ORDER BY, Bad form?

Shifting gears a bit and owing to the fact that sometimes users actually do want blind sorts, the following will work, still only hits the table once, is very easy...
--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 1, 2013 at 11:09 pm

#1655115
RE: ORDER BY, Bad form?

I have a bit of a problem doing it the way you did it.
First, the ORDER BY you created is what I call a "Blind Sort". There is nothing...
--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 1, 2013 at 10:51 pm

#1655113
RE: ORDER BY, Bad form?

SQL_FS (10/1/2013)
I think people are misunderstanding, allow me to clarify. I'm not trying to ask whether or not using ORDER BY [Column Position] is bad form or not. ...
--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 1, 2013 at 9:56 pm

#1655110
RE: T-SQL counts

Actually, this is going to cause a mess for me when we upgrade from 2005 because NULL is considered to be a DISTINCT value. For 2005, the correct answer...
--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 1, 2013 at 8:31 pm

#1655106
RE: Variable Declaration

If I found a DECLARE nested in an IF like that in real life, there would be some high velocity pork chops in the future of the Develper that wrote...
--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 1, 2013 at 8:14 pm

#1655105
RE: Urgent: How to shrink this huge DB?

halifaxdal (10/1/2013)
I did the following to empty ldf: 1. Put the recovery mode to simple; 2. dbcc shrinkdatabase('database_name')
This made the ldf to minimum from 99GB down to 1M
I then tried...
--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 1, 2013 at 2:13 pm

#1655061
RE: Installing a 1t db and best practices to keep 3 data bases in sync

Just a suggestion...
Keeping a reporting database in sync with production is a fine idea. Keeping a development database in sync with production is going to be a very painful...
--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 1, 2013 at 2:09 pm

#1655060
RE: Are the posted questions getting worse?

jasona.work (10/1/2013)
Thanks. I initially held off on doing that, kind of felt like bringing gun to a hammer fight...
Don't hold off. Mods are supposed to be above all...
--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 1, 2013 at 1:19 pm

#1655038
RE: ORDER BY, Bad form?

IIRC, ordinal ORDER BYs have been deprecated. Even if they weren't, I see no advantage to using them other than typing fewer characters.
--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 1, 2013 at 12:06 pm

#1655015
RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

T.Ashish (9/29/2013)
I have faced the same situation in an interview where interviewer asked me a question on triggers.
I tried my hard to convince him that we...
--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 1, 2013 at 11:48 am

#1655001
RE: Prevent backups on C:\ drive?

Kurt W. Zimmerman (10/1/2013)
kevaburg (10/1/2013)
Kurt W. Zimmerman (10/1/2013)
I think the resolution is more a function of control. As a DBA restrict access to those developers who don't at by 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)

October 1, 2013 at 7:45 am

#1654908
RE: Need Help on Fastest Search Logic

born2achieve (9/30/2013)
Hi Jeff,
your sample data format is perfect. This is how my data will looks like. Do you have any solutions.....
Not sure yet. I know this is taking a...
--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 1, 2013 at 7:22 am

#1654886
RE: Are the posted questions getting worse?

Grant Fritchey (10/1/2013)
Please. For purposes of employment, some of us cannot comment on politics because no matter what side I argue for, I'll yack off a customer or six. Can...
--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 1, 2013 at 7:13 am

#1654882
RE: Competence trumps a good cultural fit

I went back and reread a lot of the posts on this thread. A lot of them talk about one extreme or another or both extremes.
We're not trying 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)

October 1, 2013 at 6:38 am

#1654868

Viewing 15 posts - 25,771 through 25,785 (of 59,099 total)