Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,231 through 31,245 (of 59,101 total)

RE: urgent help with SQL query please

Lucky9 (2/7/2012)
Thanks a lot for the quick reply Evil Kraig.
I have tested the query provided by you it works fine for the first and third record but the output 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)

February 7, 2012 at 7:20 pm

#1444258
RE: How can we find out if a particular database is the defualt database for any login ?

As a sidebar, I'm loath to use the master DB as the default for any login because people forget they're there and end up saving tons of garbage in 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 7, 2012 at 6:26 pm

#1444251
RE: How to find last accessed date time of a SQL Server 2008 database?

My q2uestion would be.... why do you have tables that people access that have no indexes?
--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 7, 2012 at 6:21 pm

#1444249
RE: Hierarchy Query

fahey.jonathan (2/7/2012)
cdh-727733 (2/7/2012)
I can't do that unfortunately as this is to be driven from user searches which I can't predict.
What I am suggesting is that you create a complete hierarchy...
--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 7, 2012 at 6:05 pm

#1444247
RE: Help with a query.

xRafo (2/7/2012)
Thanks to all,
this query can execute with -while statement-?
Yes... it can. Why would you want to use slower code for this, though?
--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 7, 2012 at 4:16 pm

#1444212
RE: SA for database ownership?

SQLRNNR (2/7/2012)
Elliott Whitlow (2/7/2012)
Thanks Jeff. The paragraphs before it mentions not using sa specifically talks about IT department mode vs ISV mode. I don't think you can take...
--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 7, 2012 at 4:01 pm

#1444205
RE: SA for database ownership?

Elliott Whitlow (2/7/2012)
Jeff,
What MS doc is this? It sounds like best practices for a shared hosting environment. In THAT environment I would agree with not being owned...
--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 7, 2012 at 12:52 pm

#1444065
RE: complex problem

Too funny! 🙂 People used to laugh at me when they asked me what the first thing I'd do as a DBA in the morning (besides grabbing coffee). ...
--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 7, 2012 at 9:18 am

#1443898
RE: SA for database ownership?

SQLDCH (2/6/2012)
I'm having to deal with this now (database ownership) and came across a SQL Server 2005 best practice doc from Microsoft, stating that databases should not be owned by...
--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 7, 2012 at 9:07 am

#1443880
RE: How can I use this in a function?

Chrissy321 (2/6/2012)
Jeff,
Thanks for the code and education on Inline Table Valued Functions! That should work.
I considerd a calendar/date period table but since there was no business days or holiday requirements...
--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 7, 2012 at 8:58 am

#1443871
RE: ssis and ssrs interview questions

herladygeekedness (2/6/2012)
keep the thread alive, it IS entertaining. Any grown up can sit in an interview and tell the truth. It takes a real fake to memorize Q&A for regurgitation...
--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 6, 2012 at 4:56 pm

#1443502
RE: Are the posted questions getting worse?

Grant Fritchey (2/6/2012)
Go easy on him. He's trying. Gentle guidance, not all up in his grill.
My "dope slapping" comes across more like that (easy on him) than I'd like. ...
--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 6, 2012 at 4:46 pm

#1443497
RE: Please fix the "Pretty Print" class in the forums and the article "Contribution Center"

Steve Jones - SSC Editor (2/6/2012)
OK, #5 seems to be fixed. Posting from IE8, and copy/paste to SSMS 2008R2 preserves line breaks for me.
In terms of #s 1 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)

February 6, 2012 at 4:18 pm

#1443494
RE: Calculating Work Days

rick.myers (2/6/2012)
This functions doesn't actually work. Just try Jan 1, 2012 to Jan 31, 2012. Or February 2012.
Since you tried it, how about sharing what you're getting for results...
--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 6, 2012 at 4:16 pm

#1443493
RE: Are the posted questions getting worse?

Heh... you guys must be talking about my recent favorite candidate for the "Flying Porkchop Award". I just dope slapped him where he posted two links that did Triangular...
--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 6, 2012 at 8:12 am

#1443178

Viewing 15 posts - 31,231 through 31,245 (of 59,101 total)