Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,726 through 37,740 (of 59,072 total)

RE: Performance on Views that span databases on multiple servers

SQL Marathoner (7/11/2010)
You can try indexed view, which may solve the performance issue.
Ummm... Good idea but probably won't work here. See the following URL and look for "View...
--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)

July 11, 2010 at 2:51 pm

#1191266
RE: Performance on Views that span databases on multiple servers

Eric Anderson (7/9/2010)
We have many databases at our company. There are two in particular both of which are on two different virtual servers but both virtual servers are on 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)

July 11, 2010 at 2:37 pm

#1191263
RE: Are the posted questions getting worse?

Wow... Someone please tell me how this person got the job.
http://www.sqlservercentral.com/Forums/Topic950419-145-1.aspx
This is one of the reasons I'm so adamant about not posting answers to interview and homework questions. Saying...
--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)

July 11, 2010 at 2:33 pm

#1191262
RE: Are the posted questions getting worse?

Grant Fritchey (7/11/2010)
Jeff Moden (7/9/2010)
Interesting... PASS accepted my abstract on the Tally Table session. I'm actually a bit surprised at that. I had also submitted an abstract...
--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)

July 11, 2010 at 2:26 pm

#1191261
RE: Are the posted questions getting worse?

WayneS (7/9/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has...
--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)

July 9, 2010 at 9:19 pm

#1191103
RE: Are the posted questions getting worse?

Stefan Krzywicki (7/9/2010)
Jeff Moden (7/9/2010)
CirquedeSQLeil (7/9/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate"...
--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)

July 9, 2010 at 9:17 pm

#1191102
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/9/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has...
--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)

July 9, 2010 at 8:26 pm

#1191093
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/9/2010)
The Dixie Flatline (7/9/2010)
Congrats, Jeff. I will bring a big bag of peanuts to your session so your SSC fans can throw them at you if you...
--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)

July 9, 2010 at 8:24 pm

#1191092
RE: Convert CSV values in three columns to rows

Jeff Moden (7/6/2010)
Thank you for the test harness and your good code, Oleg. I'll check it out.
Sorry, Oleg... I've not nbeen able to put in the time to do...
--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)

July 9, 2010 at 7:29 pm

#1191088
RE: Are the posted questions getting worse?

Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has a problem 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)

July 9, 2010 at 4:30 pm

#1191061
RE: Are the posted questions getting worse?

Interesting... PASS accepted my abstract on the Tally Table session. I'm actually a bit surprised at that. I had also submitted an abstract on a new way...
--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)

July 9, 2010 at 4:24 pm

#1191060
RE: Are the posted questions getting worse?

The Dixie Flatline (7/9/2010)
Jeff, you have hp on the brain.
You need to clean the cages out more often ,,, or naybe less often. 😛
Heh... of...
--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)

July 9, 2010 at 4:18 pm

#1191058
RE: Try Catch alters behaviour of existing procedures

The Dixie Flatline (7/9/2010)
Double Forward Fourier Transforms ??
😛
--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)

July 9, 2010 at 4:16 pm

#1191057
RE: Best Approach To Enable and Allow Use xp_cmdshell Non sysAdmin Users

shoffman-569213 (7/8/2010)
The developers are using xp_cmdshell and the OS dir command to verify that the file path and file exists before loading the contents and doing further processing. Using...
--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)

July 9, 2010 at 3:45 pm

#1191051
RE: Try Catch alters behaviour of existing procedures

doobya (7/8/2010)
If you don't mind, I'll just go ahead and disagree with you on all those points. 😉 It all works exactly as I expect it to work according...
--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)

July 9, 2010 at 3:34 pm

#1191049

Viewing 15 posts - 37,726 through 37,740 (of 59,072 total)