Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,556 through 33,570 (of 59,099 total)

RE: Recursive User-Defined Function

GSquared (6/20/2011)
Jeff Moden (6/20/2011)
GSquared (6/20/2011)
He's very technically proficient
Considering that he recently recommended FK's on First and LastName columns and he still uses a While Loop/Push Stack to convert from an...
--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)

June 20, 2011 at 5:42 pm

#1341539
RE: PerfectDisk Vs DisKeeper

SQLRNNR (6/20/2011)
Jeff Moden (6/19/2011)
SQLRNNR (6/18/2011)
As per stopping services, both utilities can cause serious latency in the database if trying to defrag during normal operating hours. Both require serious IO...
--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)

June 20, 2011 at 11:01 am

#1341326
RE: Import CSV with text qualifier

BCP and BULK INSERT are virtually identical now-a-days. Neither will handle true CSV (with text qualifiers, etc) without a bit of work. If the text qualifiers are used...
--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)

June 20, 2011 at 8:00 am

#1341207
RE: Recursive User-Defined Function

GSquared (6/20/2011)
He's very technically proficient
Considering that he recently recommended FK's on First and LastName columns and he still uses a While Loop/Push Stack to convert from an Adjacency List 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)

June 20, 2011 at 7:36 am

#1341189
RE: how to print characters after third occurrance of a character

That's why I wanted to know if there will only and always be just 3 occurances so we can use a singe CHARINDEX on the REVERSE image of the string...
--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)

June 20, 2011 at 7:28 am

#1341183
RE: Storage Space Estimation (Can Calc Table Size)

Jeff Moden (6/19/2011)
dec_obrien (4/2/2007)
Hi,
I'd like to guesstimate how much space is required for a 2005 database and log file. I can calculate the size of the tables...
--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)

June 20, 2011 at 7:25 am

#1341178
RE: Difficulty grabbing values from same table where all the columns use the same key

Naked Ape (6/19/2011)
Oops - got my aliases a bit screwed up there ... I should have checked a bit more before posting;
SELECT sales.Project, rep1.DisplayName, rep2.DisplayName, rep3.DisplayName, rep4.DisplayName, sales.Spend
FROM [Table 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)

June 20, 2011 at 4:55 am

#1341040
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

No... it's not just you. Something has gone dreadfully wrong (I hope I have a copy somewhere). I send an email to Steve Jones.
--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)

June 20, 2011 at 4:21 am

#1341029
RE: comparing the varchar data type value

glen.wass (6/16/2011)
so Cheat is < than cheat
It really does "Depend". What it depends on is the default server collation, the collation of a given column in the table when...
--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)

June 19, 2011 at 9:08 pm

#1340954
RE: Recursive User-Defined Function

CELKO (6/18/2011)
Avoid procedural code in SQL whenever you can. Recursive CTEs are really cursor loops, not full recursion...
That's funny coming from a guy who's famous for using a 1960's Push-Stack/While...
--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)

June 19, 2011 at 8:48 pm

#1340951
RE: Storage Space Estimation (Can Calc Table Size)

dec_obrien (4/2/2007)
Hi,
I'd like to guesstimate how much space is required for a 2005 database and log file. I can calculate the size of the tables but how...
--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)

June 19, 2011 at 8:32 pm

#1340950
RE: question on date functions: dateadd(qq,datediff(qq,-1,GETDATE()),-1)

ankit.shukla1105 (6/19/2011)
-1 here represents a year before 1900 i.e 1899
Not really. It's precisely 1 day before the first day of 1900. Yes, it occurs in 1899 but...
--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)

June 19, 2011 at 8:30 pm

#1340949
RE: Difficulty grabbing values from same table where all the columns use the same key

Almost forgot. Please see the following link for how Cross Tabs work and how they compare to Pivot.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

June 19, 2011 at 8:19 pm

#1340948
RE: how to print characters after third occurrance of a character

roshan.zanwar (6/19/2011)
Hi all,
I am trying to print characters after rd occurance of character 'a'.
Suppose My column name is Emp_Name & one of the record like ababaccc.
So i am 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)

June 19, 2011 at 8:14 pm

#1340947
RE: Difficulty grabbing values from same table where all the columns use the same key

Here's one solution. As normal for me, the details are in the comments in the code. Post back if you have any questions. I'd also like...
--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)

June 19, 2011 at 8:09 pm

#1340944

Viewing 15 posts - 33,556 through 33,570 (of 59,099 total)