Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,841 through 33,855 (of 59,099 total)

RE: On call support experience

{EDIT} Terrible post from a seriously caffeine deprived day removed. My apologies.
--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)

May 26, 2011 at 8:32 pm

#1330762
RE: retrieve views containing reference to a specific column

Lowell (5/26/2011)
glad I could help!
Thansk for the feedback!
Great code but it's another reason for me to hate what MS thinks is "progress". :sick: The f4 key use to have...
--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)

May 26, 2011 at 8:25 pm

#1330760
RE: How to manage databases without sysadmin role?

I have to admit, this is all a bit odd. The app, which I assume has been thoroughly tested to run correctly and safely, can't use SA 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)

May 26, 2011 at 8:20 pm

#1330758
RE: Making where clause dynamic in tsql

I assume that you don't really mean "Dynamic SQL". I assume you mean how do you do this in a single pass instead of 3.
The answer is simple... Build...
--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)

May 26, 2011 at 7:54 pm

#1330753
RE: Help on constraint

bayalapudi_k (5/26/2011)
Hi Guys,
I am new to the forum and first post of my sql. I am in my initial learning stage and need all you guys help.
I need a solution...
--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)

May 26, 2011 at 5:18 pm

#1330724
RE: Are the posted questions getting worse?

Gianluca Sartori (5/26/2011)
Jeff Moden (5/25/2011)
Gianluca Sartori (5/25/2011)
No way, the Summit is too far and too expensive for me.
Especially now that I'm moving into freelance consulting.
You have the right attitude, Gianluca....
--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)

May 26, 2011 at 5:14 am

#1330173
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

WayneS (5/25/2011)
Jeff Moden (5/25/2011)
Besides... everyone knows to use a CLR for these type of things, right. :-P:-P:-P:hehe:
Yes, I know. But, when you're selling software solutions, you can't mandate their use...
--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)

May 25, 2011 at 8:07 pm

#1330050
RE: Are the posted questions getting worse?

GilaMonster (5/23/2011)
Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give telephonic support...
--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)

May 25, 2011 at 7:42 pm

#1330048
RE: Are the posted questions getting worse?

GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.
You are all coming? Right?
Outstanding! Congratulations to two people who couldn't deserve...
--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)

May 25, 2011 at 7:38 pm

#1330047
RE: Are the posted questions getting worse?

Gianluca Sartori (5/25/2011)
No way, the Summit is too far and too expensive for me.
Especially now that I'm moving into freelance consulting.
You have the right attitude, Gianluca. You'll do well....
--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)

May 25, 2011 at 7:36 pm

#1330046
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mark hutchinson (5/25/2011)
@jeff
Here's an idea to kick around for varchar(max) data...use a tally table (or cte equivalent) to split the very large string into strings less than 8000 characters 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)

May 25, 2011 at 1:49 pm

#1329921
RE: Importing very large flat file throws truncation errors

As a side bar, I absolutely agree with Lowell's recommendation. I never import directly into the "final" table. I always use a staging table (Temp Table or otherwise)...
--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)

May 25, 2011 at 10:30 am

#1329812
RE: Importing very large flat file throws truncation errors

Lowell (5/25/2011)
the columns in the table and the columns in the BULK insert must match exactly, with no extra or missing columns....unless you use a format file.
As a possible alternative...
--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)

May 25, 2011 at 10:28 am

#1329808
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

fahey.jonathan (5/25/2011)
Thanks for the great article and the code that goes with it.
Is there a reason why you chose a VARCHAR(8000) instead of a VARCHAR(MAX)? I modified 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)

May 25, 2011 at 10:24 am

#1329806
RE: Looking for reasons...

ChrisM@home (5/25/2011)
Something similar: a data feed to a warehouse was comparing the 10M row DW orders table to the 10M row OLTP orders table then aggregating to obtain the most...
--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)

May 25, 2011 at 6:43 am

#1329624

Viewing 15 posts - 33,841 through 33,855 (of 59,099 total)