Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,876 through 31,890 (of 59,099 total)

RE: Where Do You Go for Authoritative SQL Server Best Practices?

I haven't downloaded it but, even if I did (as they have allowed and for personal use only), I've got this little thing about ethics. Even though they've not...
--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)

November 24, 2011 at 9:06 am

#1412740
RE: Why does the same code yield different results running in T-SQL interactively vs. as a TVF?

Heh... Sorry for the inch high letters and the late reply, Rich. I'm just getting caught up on some old posts.
I apparently took what you said the wrong 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)

November 24, 2011 at 8:45 am

#1412732
RE: Query to Assign a Sequence Number

JonFox (11/21/2011)
Thanks for the encouragement Jeff! Frankly, [font="Arial Black"]this is why I've been trying to spend time on the forums lately...it seems almost every time I try to help someone,...
--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)

November 24, 2011 at 8:33 am

#1412725
RE: Performance issue with tally solution

John Nelson-327605 (10/18/2011)
So...I'm liking the DelimitedSplit8K, but I need to increase it to an unknown number between 25K and 150K rows. Any way to modify this so I can...
--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)

November 24, 2011 at 8:22 am

#1412719
RE: Maximum Insert Commit Size

Heh... if "some idiot [can unplug] the power while it is still running", then you may have larger problems at hand. 😀 But, I get what you mean.
I don't...
--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)

November 24, 2011 at 7:59 am

#1412709
RE: Complex Join and Group By

Articles on pivots, crosstabs, and dynamic crosstabs...
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

November 23, 2011 at 8:26 pm

#1412540
RE: Get Data from XML Nodes for multiple rows

drew.allen (11/23/2011)
XML is case-sensitive. That appears to include the .nodes() function.
Drew
The first time I found that out, my thought was "Great... first, mandatory semi-colons and now mandatory casing....
--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)

November 23, 2011 at 8:18 pm

#1412539
RE: which High Avaiblity Option is better?

logicinside22 (11/23/2011)
Hi folks,
I have to keep report server real time updated with prodcution server databse . would like to know the suggestions which HA option is better...
--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)

November 23, 2011 at 8:16 pm

#1412538
RE: When are partitioned indexes slower than regular indexes?

winston Smith (11/23/2011)
...for certain queries ...
Ask the person that told you to produce the proof. All claims of performance or lack thereof should be accompanied by a code example....
--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)

November 23, 2011 at 8:06 pm

#1412537
RE: Maximum Insert Commit Size

My goal is that I want the package to be ALL or NONE but I also don't want lock up the table for too long. Any help is appreciated
Then don't...
--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)

November 23, 2011 at 8:03 pm

#1412535
RE: Draw a cirlce in report using BIDS 2008 R2

Pie chart filled to 100%?
--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)

November 23, 2011 at 7:55 pm

#1412534
RE: Are You Easy To Work With?

They’ve learned that the perfect is the enemy of the good, that some projects require inelegant solutions,...
While I agree that some projects don't require rocket science and the added scope...
--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)

November 23, 2011 at 7:53 pm

#1412533
RE: Uniqueidentifier.

kev43barrie (11/23/2011)
I have a variable of type uniqueidentifier. I would to include this in a varchar. I have tried CAST(@Var, NVARCHAR(50)) and CONVERT. But when I try...
--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)

November 23, 2011 at 7:31 pm

#1412531
RE: Are the posted questions getting worse?

Jim Murphy (11/22/2011)
The other organizer of our SQLSaturday in Austin (#97) just compiled the speaker feedback evals. I came in 3rd overall! I'm pretty pleased since it was...
--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)

November 23, 2011 at 7:13 pm

#1412530
RE: Decimal Number format as String

No problem, Ron. Your solution had just about everything in it. Nicely done.
--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)

November 23, 2011 at 5:03 pm

#1412519

Viewing 15 posts - 31,876 through 31,890 (of 59,099 total)