Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,176 through 35,190 (of 59,099 total)

RE: ssis and ssrs interview questions

parmar.randheer11 (1/30/2011)
Hi,
I have consolidate few SSRS and TSQL questions for interview on my blog http://SQLServerQuest.blogspot.com .
you can check SSRS interview questions from there.
Thanks
Randheer
I got just a couple of questions in...
--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)

February 2, 2011 at 11:46 pm

#1281734
RE: SSIS task causes tempdb to grow uncontrolled

romanoplescia (1/27/2011)
It was collation... :angry:
Oh, now THAT's interesting. Talk about a difficult thing to find. Thanks for the feedback.
--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)

February 2, 2011 at 11:39 pm

#1281733
RE: Formatting Dates with 3 Character Months (SQL Spackle)

David McKinney (1/28/2011)
Jeff Moden (1/23/2011)
You bet. Thanks for the feedback, the tips, and a couple of other things.
As a side bar, recursive CTE's tend to be a bit slow...
--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)

February 2, 2011 at 11:25 pm

#1281728
RE: Execute As

charles evans (2/2/2011)
You're right the one can't declare and assign in the same line with local variables in SQL 2005. Adding that feature in SQL 2008 made turning ad-hoc...
--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)

February 2, 2011 at 11:17 pm

#1281727
RE: Execute As

Patrick Cahill (2/2/2011)
This is my first article...
Then my hat is really off to you, Patrick. Comprehesive code with a decent format embedded in a well written article that explains...
--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)

February 2, 2011 at 11:15 pm

#1281726
RE: Display More Than 8000 Characters (SQL Spackle)

JJ B (1/31/2011)
Believe it or not, this kind of thing can have a production purpose. I have to send "narrative" from our database to a database in another agency....
--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)

February 2, 2011 at 10:56 pm

#1281725
RE: Display More Than 8000 Characters (SQL Spackle)

Dugi (1/28/2011)
Hey Jeff, I'm late here, but really this is very nice article, thanks for sharing!
Wish you more success my friend,
Dugi
No problem. Thanks for the read and 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)

February 2, 2011 at 10:54 pm

#1281724
RE: Display More Than 8000 Characters (SQL Spackle)

TheSQLGuru (1/28/2011)
Just gotta love the things you can do with a Numbers table!
They do make certain things in life a whole lot easier. Thanks for stopping by, Kevin.
--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)

February 2, 2011 at 10:53 pm

#1281723
RE: Are the posted questions getting worse?

WayneS (1/31/2011)
So... what's your favorite data modeling tool?
Starting a new job today... I get to use whatever tools I want. I've used ERwin and PowerDesigner in the past. IMHO, ERwin...
--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)

February 2, 2011 at 9:57 pm

#1281714
RE: Are the posted questions getting worse?

jcrawf02 (1/31/2011)
GilaMonster (1/31/2011)
WayneS (1/31/2011)
So... what's your favorite data modeling tool?
Pencil and paper (or marker and whiteboard).
Personally, I prefer using Grant
Me too but he get's really ticked when you try 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)

February 2, 2011 at 9:54 pm

#1281711
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/31/2011)
Yikes, lots of thread activity since I disappeared Fri am.
Being unwired is nice 😉
Sounds like great fodder for an editorial. 🙂
--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)

February 2, 2011 at 9:50 pm

#1281709
RE: Execute As

I haven't taken the time to run the code yet either... but I did read the article. The title of the article doesn't even come close to describing 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)

February 2, 2011 at 8:20 am

#1281469
RE: Killed a SPID; Not Completing...

GilaMonster (2/1/2011)
Jeff Moden (2/1/2011)
I've seen several instances of such a thing happening. Although I don't claim it to be a panacea, I've found the another session on a different...
--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)

February 1, 2011 at 2:56 pm

#1281157
RE: Killed a SPID; Not Completing...

Ninja's_RGR'us (2/1/2011)
Jeff Moden (2/1/2011)
Craig Farrell (1/31/2011)
dajonx (1/31/2011)
Hi,
I was wondering if there is a way to remove a killed SPID that has been in rollback for a week without restarting SQL...
--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)

February 1, 2011 at 2:54 pm

#1281156
RE: A Great Deal of Hot Air

Shifting gears a bit... I've always thought it to be absolutely ridiculous that one would run coolers for a data center... in 15^oF weather. 😉
--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)

February 1, 2011 at 10:32 am

#1281069

Viewing 15 posts - 35,176 through 35,190 (of 59,099 total)