Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,661 through 33,675 (of 59,099 total)

RE: Are the posted questions getting worse?

The regular and half day session lists for PASS came out today. I didn't make the cut this time. I'll probably have to turn down the "alternate" 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)

June 15, 2011 at 5:36 pm

#1339386
RE: Are the posted questions getting worse?

Grant Fritchey (6/15/2011)
That's 10,000 posts, done.
Wait, now it's 10,001.
Way to go, Grant! As many have said, thank you for the time you've spent teaching the rest of us. ...
--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)

June 15, 2011 at 5:29 pm

#1339385
RE: Finding dates in Dates tally table

sku370870 (6/15/2011)
Regarding your comments about the PK ... I have always just made sure that every table (well, almost every table) has an identity column used as the PK.
But you're...
--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)

June 15, 2011 at 7:25 am

#1338957
RE: SQL command

ying7690 (6/14/2011)
SELECT RECID,BranchRECID,ScheduleContinueS,EndDate
FROM tblBranch_Schedule
WHERE DATEDIFF(DAY,StartDate,GETDATE()) > 0 AND DATEDIFF(DAY,GETDATE(),EndDate) >= 0
AND DATEDIFF(DAY,GETDATE(),EndDate) <=15 AND EXISTS (SELECT RECID,BranchRECID,ScheduleContinueS,EndDate
FROM tblBranch_Schedule
WHERE DATEDIFF(DAY,GETDATE(),StartDate) > 0);
SELECT RECID,BranchRECID,ScheduleContinueS,EndDate,DATEDIFF(DAY,GETDATE(),StartDate)
FROM tblBranch_Schedule
where DATEDIFF(DAY,GETDATE(),StartDate) > 0 AND DATEDIFF(DAY,GETDATE(),StartDate) <30;
I want...
--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)

June 14, 2011 at 10:59 pm

#1338760
RE: How to check the number of columns in a source dynamically?

sultan_vnj (6/13/2011)
Hi There,
in my package when pulling the data from the source
today i have 4 columns, but some other day the number of columns may change.
So, how to check...
--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)

June 14, 2011 at 10:56 pm

#1338759
RE: description of view columns

elham_azizi_62 (6/12/2011)
hello all.
I need to access to description of view columns.I know to access description of table columns.please give me one script that show description of columns of views.
Gosh... they're...
--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)

June 14, 2011 at 10:55 pm

#1338758
RE: One procedure to insertupdate all master tables using if statements

allmhuran (6/13/2011)
My gut reaction is that this is an ugly solution (particularly bringing XML in, ugh... XML...).
Does your manager have a particular reason for wanting to do it this...
--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)

June 14, 2011 at 10:53 pm

#1338757
RE: Deadlocks Solution

mya (6/14/2011)
We have application that is causing deadlocks. The developers can't do anything to prevent deadlocks. I don't have permission to see the code. I can only run a trace...
--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)

June 14, 2011 at 10:48 pm

#1338756
RE: Finding dates in Dates tally table

Also, a Calendar table works much faster if the PK and the Clustered Index are on the Date column. Unless it's there for purposes of some type of table...
--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)

June 14, 2011 at 10:44 pm

#1338755
RE: Finding dates in Dates tally table

sku370870 (6/14/2011)
I have an application where everything is about project dates - meeting dates, timeline dates and microtimeline dates - every step in every process has a target date 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)

June 14, 2011 at 10:41 pm

#1338754
RE: Finding dates in Dates tally table

opc.three (6/14/2011)
DayInstanceInMonth - tinyint - values 1-5 representing the n-th time this day has occurred in the month
Most people don't think of such a thing. I was going 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)

June 14, 2011 at 10:37 pm

#1338753
RE: Why? Just because...

My guess would be "Absolute stupidity". 😛 They have no idea about the paradigm shifts necessary to do such a thing nor how much it's going to cost them...
--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)

June 14, 2011 at 6:43 pm

#1338738
RE: SQL Query

CELKO (6/14/2011)
... avoid needless dialect ...
I'm very much in favor of that idea. You should try it sometime.
--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)

June 14, 2011 at 6:40 pm

#1338737
RE: Best Practices - Variations of the same report (Seniors only)

... and please don't be so pompous to label your post as "Seniors Only". You might just talk a couple of us seniors out of helping with an attitude...
--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)

June 14, 2011 at 6:35 pm

#1338734
RE: Using xp_cmdshell to query active directory, global group names are truncated in results

Elliott Whitlow (6/14/2011)
Jeff,
I've reviewed that code and as I read it, you have to take advantage of a hack that allows you to use xp_regwrite as a non-privileged user coupled...
--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)

June 14, 2011 at 3:36 pm

#1338693

Viewing 15 posts - 33,661 through 33,675 (of 59,099 total)