Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,156 through 37,170 (of 59,098 total)

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
RE: When creating new table does column order matter if different data types?

GilaMonster (8/23/2010)
Jeff Moden (8/22/2010)
There's one I didn't know. Have a got a Paul or MS link for that?
Got a Paul link (or three).
http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-record.aspx
http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx
http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-27-How-does-the-storage-engine-find-variable-length-columns.aspx
Everything in his category 'On disk structures'...
--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 5:54 am

#1210381
RE: Search part of string within part of string

You can't really use regular expressions in SQL Server unless you do an SQLCLR.
The real problem here is that even if you can get it to make human-like decisions, even...
--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 5:53 am

#1210380
RE: Linking to the Previous Row

niyinks (8/23/2010)
Hi
The table above identifies my problem, it reuses the end date and start date. Thus having multiple entries for a date instead of having a few entries only...
--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 5:47 am

#1210379
RE: Do you advise to apply Recomendations given by DTA?

GilaMonster (8/23/2010)
Jeff Moden (8/22/2010)
I'm pretty sure that statistics TIME and IO don't include SQLCLR and I believe they sometimes miss what's happening in UDF's that a query may contain.
Correct on...
--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 5:40 am

#1210376

Viewing 15 posts - 37,156 through 37,170 (of 59,098 total)