Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,126 through 37,140 (of 59,072 total)

RE: Finding Unique Non-Repeating Random Numbers

Brandie Tarvin (8/23/2010)
jcrawf02 (8/23/2010)
Brandie Tarvin (8/23/2010)
I had no idea what that comment was supposed to mean. Since you replied, maybe you can explain it to me? @=)
Related to the PS...
--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)

August 23, 2010 at 9:34 pm

#1210768
RE: Disk configuration for TempDB

Nadrek (8/23/2010)
One other trick is to put TempDB on, say, a pair of local SSD's in RAID1; keep it off the SAN.
Given the price per SAN spindle, 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)

August 23, 2010 at 9:30 pm

#1210767
RE: Dates from Calendar control

Riskworks (8/23/2010)
and c.rd between @start and dateadd(hh,-1,dateadd(dd,1,@end))
Gosh... that seems like "Death by SQL" because you're actually missing a whole hour in the day. Try this, instead...
and c.rd >=...
--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)

August 23, 2010 at 9:14 pm

#1210765
RE: Data Type and Length

paul.knibbs (8/23/2010)
There is sometimes a HUGE performance penalty (2:1) to be paid for using VARCHAR(MAX) depending, of course, on what you're doing. Correct sizing is always important. I'd...
--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)

August 23, 2010 at 9:09 pm

#1210763
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/23/2010)
I saw that from Brent. Paul is garnering lots of respect from the other gurus.
We need to get Paul out here in the US for some...
--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)

August 23, 2010 at 8:47 pm

#1210758
RE: Are the posted questions getting worse?

Awesome info, Jack. Didn't know about the Chapter LM. That pretty much solves the whole thing. I'll setup a test with Roy. Thanks a bunch.
{edit} ...
--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)

August 23, 2010 at 8:43 pm

#1210757
RE: Are the posted questions getting worse?

Grant Fritchey (8/17/2010)
Jeff Moden (8/17/2010)
Alvin Ramard (8/17/2010)
I would appreciate if any of you who are going to use remote speakers, or are going to broadcast your user group meetings, could...
--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)

August 23, 2010 at 8:12 pm

#1210754
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/19/2010)
jcrawf02 (8/19/2010)
Steve Jones - Editor (8/19/2010)
The Red Gate Source Control webinar starts in a few, if any of you are interested
http://www.sqlservercentral.com/articles/webinar/70854/
Perfect timing, thanks Steve! (good show,...
--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)

August 23, 2010 at 8:03 pm

#1210752
RE: How to read first line of each text file in a folder and validate

steve-893342 (8/23/2010)
Well, at least with the BULK INSERT method I came up with, I first created 2 staging tables. Then for each each file, I needed to BULK...
--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)

August 23, 2010 at 6:12 pm

#1210740
RE: How to read first line of each text file in a folder and validate

steve-893342 (8/23/2010)
I did mock up a BULK INSERT variation but, whilst eliminating the need for a format file, at the same time the specter of RBAR 🙁 was introduced. Or...
--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)

August 23, 2010 at 1:08 pm

#1210662
RE: Finding Unique Non-Repeating Random Numbers

jcrawf02 (8/23/2010)
pete callaghan (8/22/2010)
Support the animated giff comment - they get do very old very quickly.
For those of you who are bothered, go to your Control Panel (top left...
--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)

August 23, 2010 at 1:04 pm

#1210660
RE: DATEADD

SwayneBell (8/23/2010)
Jeff,
Stay folksy. Your articles are great the way they are.
I'm new to the forums and not a DBA by profession. I read the posts and articles here to broaden...
--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)

August 23, 2010 at 12:49 pm

#1210654
RE: Cumulative Updates & Hotfixes

Steve Jones - Editor (8/23/2010)
I'll say this is one reason I think we need those yearly service packs. A more stable, tested version of patches that gets us to 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)

August 23, 2010 at 12:48 pm

#1210653
RE: tsql retrieve records on date

Kingston Dhasian (8/23/2010)
But i mostly use this method to write a quick query. It is short and sweet.
... and slow. Heh... I normally want the highest speed when I...
--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)

August 23, 2010 at 6:23 am

#1210399
RE: When creating new table does column order matter if different data types?

Here's why I specifically wanted a "Paul" reference... I knew he'd get into...
Using DBCC IND and DBCC PAGE to examine a row in detail
It's too bad the comments 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)

August 23, 2010 at 6:05 am

#1210388

Viewing 15 posts - 37,126 through 37,140 (of 59,072 total)