Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,801 through 37,815 (of 59,072 total)

RE: Are the posted questions getting worse?

Hey Grant! What day is your local Pass meeting on in July? I'm going to be in lil' Rhody from the 11th to the 17th and I'd love...
--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 2, 2010 at 3:30 pm

#1188445
RE: Are the posted questions getting worse?

Here's a real life example of what I'm talking about. I gave a 2 hour session at my local Pass chapter. The first hour was an intro to...
--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 2, 2010 at 3:28 pm

#1188444
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/2/2010)
Part of a problem I see with the whole process is that there aren't good guidelines. No criteria that describe how we pick things.
We did get...
--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 2, 2010 at 3:23 pm

#1188441
RE: Creating Clustered index on a large table

TheSQLGuru (7/2/2010)
Once again we are moving into the world where a professional would be worth his/her weight in gold - or at least silver (metals are SOOOO inflated in price...
--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 2, 2010 at 3:16 pm

#1188438
RE: SSRS rendering limits?

jcrawf02 (7/2/2010)
humph. Well, that's just annoying. Thanks for the response Jeff.
Agh... sorry about the short response, Jon. I just get ticked off at all these wonder "magical" GUI's that...
--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 2, 2010 at 3:11 pm

#1188436
RE: hi i need cursor program

rajendra prasad-377679 (7/2/2010)
the main task is.
scenario:
assume if a production company take material for a weekly basis..
this week they have a stock 800 ton rawmaterial.
for daily basis they going to 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)

July 2, 2010 at 2:53 pm

#1188433
RE: hi i need cursor program

Ram:) (7/2/2010)
yes I agree with Mr.Gail.. You may not need cursor for this..
As per my understand.. simple triggers will work for you
Whoa! Hold the phone! Triggers? For...
--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 2, 2010 at 2:42 pm

#1188432
RE: Split string using Tally Table

BWAA-HAA!!!! First, this is NOT a good example of Tally Table code. It doesn't use a Tally Table and it doesn't use anything that could be called efficient....
--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 2, 2010 at 11:23 am

#1188372
RE: SSRS rendering limits?

jcrawf02 (7/2/2010)
I have a view for a mailing list, pulls roughly 236k rows of data, SELECT * from that view runs in about 30 seconds in SSMS, when I pull...
--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 2, 2010 at 8:57 am

#1188266
RE: Flexible ETL package

John Mitchell-245523 (7/2/2010)
I would say so, yes, otherwise you will need to change your code every time your exclusion list changes.
John
Z'actly.
--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 2, 2010 at 8:07 am

#1188224
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Wiztech Russ (7/1/2010)
These articles are very well written, even an accidental DBA like myself can understand the logic in what you are describing. The actual examples also make it far...
--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 2, 2010 at 7:44 am

#1188213
RE: Importing flat files

Ok... I've been watching this one for a bit and I'm curious... so let me ask a couple of questions, please.
1. It's my understanding that if 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)

July 2, 2010 at 6:51 am

#1188164
RE: To split comma delimiterd string

RBarryYoung (5/4/2009)
Please see this article [/url]by some really smart guy who hangs out here.
Heh... I know it's been over a year and I'm sorry I missed this. Thanks for...
--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 1, 2010 at 7:21 pm

#1187984
RE: To split comma delimiterd string

rafidheenm (12/22/2009)
Hi ezhil,
please check this article ..
This article has two types of split.
1. XML split
2. SQL Function (Basic SQL string split for SQL 2000 or later)
http://www.sqlservercentral.com/articles/XML/66932/
With regards,
Rafidheen.M
Just saw...
--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 1, 2010 at 7:20 pm

#1187983
RE: How to handle Tempdb.dbo.##XXXXXXX

zeeaay (7/1/2010)
Under my Systems Databases>tempdb>temporary tables; I have there table with dbo. ##XXXXXX. when I run an application I get the following error
Microsoft SQL Server Cannot insert the value NULL...
--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 1, 2010 at 6:41 pm

#1187978

Viewing 15 posts - 37,801 through 37,815 (of 59,072 total)