Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,636 through 31,650 (of 59,099 total)

RE: Find best key columns for Clustered Index

SQLJocky (12/19/2011)
Thanks. I understand the concepts when you know the data but what if you don't know the data? Is there a quick script that will show each...
--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)

December 19, 2011 at 9:23 pm

#1423377
RE: To VIEW or Not To VIEW ... That is the Question.

David Moutray (12/19/2011)
bteraberry (12/19/2011)
Forbidding views doesn't really help anything in my opinion. Simply taking tools out of the toolbox doesn't prevent anyone from mishandling the tools that are still...
--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)

December 19, 2011 at 9:12 pm

#1423375
RE: What's the best way to get the 2nd largest element?

Michael Valentine Jones (12/19/2011)
SELECT TOP 1 a.f1 FROM ( SELECT TOP 2 b.f1 FROM tmp2nd b ORDER BY b.f1 ASC ) a ORDER BY a.f1 DESC
Heh... on of my favorites for "paging" code. 🙂 You left out @LinesPerPage = 1, @Page...
--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)

December 19, 2011 at 8:56 pm

#1423374
RE: Populate Start and End Time from Previous End Time

Just a couple of notes:
1. The clustered index contained columns that didn't matter.
2. You had two orphaned variables that did nothing in the code. I removed...
--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)

December 19, 2011 at 7:44 pm

#1423362
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/19/2011)
GSquared (12/19/2011)
Stefan Krzywicki (12/19/2011)
Revenant (12/19/2011)
bitbucket-25253 (12/19/2011)
. . . Being too darn lazy perfrom the necessary calculations required for rocket engine design by using my slide rule. ...
--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)

December 19, 2011 at 10:51 am

#1423220
RE: Are the posted questions getting worse?

Revenant (12/19/2011)
bitbucket-25253 (12/19/2011)
. . . Being too darn lazy perfrom the necessary calculations required for rocket engine design by using my slide rule. . . .
Yes, we are...
--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)

December 19, 2011 at 10:49 am

#1423219
RE: Last day of Month

VIG (12/19/2011)
Jeff Moden (12/19/2011)
Just thought I'd throw these in... they get rid of the behind-the-scenes operation of parenthetical grouping and remove one extra subtraction (for the month end calculation) for...
--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)

December 19, 2011 at 10:44 am

#1423218
RE: Last day of Month

Just thought I'd throw these in... they get rid of the behind-the-scenes operation of parenthetical grouping and remove one extra subtraction (for the month end calculation) for a tiny bit...
--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)

December 19, 2011 at 7:22 am

#1423096
RE: Last day of Month

VIG (12/18/2011)
declare @y int
declare @m int
select @y=2012,@m=2
select dateadd(month,(@y-1900)*12+@m,0)-1
Because there's no string conversions in that, that's one of the fastest was to do this... nicely 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)

December 19, 2011 at 7:09 am

#1423089
RE: People That Get It Done

I absolutely agree with taking ownership of a problem. However...
The problem is that "people that make it happen" frequently aren't the "people that make it happen right". 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)

December 17, 2011 at 11:13 am

#1422855
RE: Last day of Month

Koen Verbeeck (12/14/2011)
Jeff Moden (12/14/2011)
praneshram (12/14/2011)
----Last Day of Last Month
SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))) 'Last Day of Last Month'
Gosh no. Always find the first day of the next month and use "less...
--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)

December 17, 2011 at 8:34 am

#1422835
RE: Convert rows to columns

Basically correct. Just making sure. Remember that it's also aggregating the data as it "pivots" the 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)

December 16, 2011 at 11:02 pm

#1422790
RE: Populate Start and End Time from Previous End Time

MattieNH (12/15/2011)
Hi Drew,
I had sort of realized that, and tried to implement the 'Quirky Update' running total solution referenced in that article (19 pages printed), but probably attributable to my...
--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)

December 16, 2011 at 10:57 pm

#1422789
RE: need help on xp_fileexist

Gosh... you don't need a CLR for this.
EXEC xp_DirTree 'C:\',1,1
--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)

December 16, 2011 at 10:50 pm

#1422788
RE: i need to do a reverse lookup on zip and get city and state for us and canada.

JimbobsQL (12/16/2011)
It may be possible to do what you're after in a query, but without any sample data or DDL it makes things difficult for us.
Try this for help: http://www.sqlservercentral.com/articles/Best+Practices/61537/
Sounds...
--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)

December 16, 2011 at 10:47 pm

#1422787

Viewing 15 posts - 31,636 through 31,650 (of 59,099 total)