Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,231 through 37,245 (of 59,098 total)

RE: ssis and ssrs interview questions

Lynn Pettis (8/19/2010)
Jeff Moden (8/18/2010)
I just got done with a long run of interviews for a Sr. Systems DBA and an SQL Server T-SQL Developer. There were about 8...
--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)

August 20, 2010 at 10:26 am

#1209794
RE: Normalize a table query

You bet. Thanks for the feedback.
Also, since you're new to this forum, you might want to take a look at the first link in my signature line below. ...
--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)

August 20, 2010 at 9:42 am

#1209753
RE: Linking to the Previous Row

Cade Roux (8/20/2010)
I scrolled through the discussion and I didn't see any mention that CTEs can be stacked. This makes some operations a lot easier to read and maintain...
--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)

August 20, 2010 at 9:24 am

#1209743
RE: Last Day of Month subscription for Shared SSRS schedule

dso808 (8/18/2010)
Hi everyone - just wanted to pitch in. Trying to also set up my subscription to send out at the very last day of the month. I've...
--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)

August 20, 2010 at 9:20 am

#1209736
RE: Huge size of unused space problem

ashkan siroos (8/20/2010)
Dear Steve,
Thanks for reply. I have stopped shrinking my data base.
Know Please tell me what to do?
How can i understand why my database grows beyond 50MB...
Thanks,
Ashkan
Although it's...
--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)

August 20, 2010 at 9:12 am

#1209733
RE: Error in Generating scripts

Bhuvnesh (8/18/2010)
Jeff Moden (8/18/2010)
Bhuvnesh (8/18/2010)
Anamika (8/18/2010)
Hi,
SELECT * FROM [font="Arial Black"]SYSOBJECTS[/font] WHERE XTYPE = 'P'
output of this query gives the new SP name.
My problem is while getting the create script 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)

August 20, 2010 at 9:02 am

#1209726
RE: DATEADD

Jeff Moden (8/19/2010)
m.kadlag (8/17/2010)
Hi All, I have a table with following structure:
ID
DATETIME
ID will be generated for different timestamps.
I have a small query to be written which will return the count...
--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)

August 20, 2010 at 8:57 am

#1209725
RE: DATEADD

sujeetps (8/20/2010)
Hi,
I faced a similar situation when I need to get the list of all the tables with the index on them. I had to show null for the those...
--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)

August 20, 2010 at 8:55 am

#1209722
RE: Are the posted questions getting worse?

Brandie Tarvin (8/20/2010)
To all reading this thread:
Jack and Steve could be throwing hissy fits and using the internet to stir up the masses, but they're being very restrained 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)

August 20, 2010 at 8:43 am

#1209711
RE: Are the posted questions getting worse?

Alvin Ramard (8/19/2010)
Brandie Tarvin (8/19/2010)
The problem with that, Alvin, is you get members who are just "sitting around" suddenly able to apply for the committee positions because they've been around...
--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)

August 20, 2010 at 8:36 am

#1209703
RE: Are the posted questions getting worse?

Roy Ernest (8/19/2010)
Jeff Moden (8/18/2010)
Jeff Moden (8/17/2010)
Roy Ernest (8/17/2010)
Jeff, Thank You. Our user group would love that. maybe for September we could try that out? 🙂 Thanks once again. 🙂
...
--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)

August 20, 2010 at 8:12 am

#1209681
RE: separate results hourly from a query

Info on the Tally table may be found at the following URL. http://www.sqlservercentral.com/articles/T-SQL/62867/
--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)

August 19, 2010 at 3:41 pm

#1209399
RE: separate results hourly from a query

I'd post a coded answer except I can't start a new message with code in it. The filters at work pick it up as a possible SQL injection attack...
--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)

August 19, 2010 at 3:38 pm

#1209395
RE: separate results hourly from a query

jerry-621596 (8/19/2010)
Thanks! Didn't even notice that. Was simply taking what he had and adding the ideas to it.
Sorry Jerry... didn't mean to direct that at you. Op...
--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)

August 19, 2010 at 3:37 pm

#1209393
RE: separate results hourly from a query

select pass_fail_indicator
from unit_status
where station = 'LG01-TIDASSGN-03'
and pass_fail_indicator = 'P'
and modified_date
between to_date('08/18/2010 08:00:00','mm/dd/yyyy hh24:mi:ss')
and to_date('08/18/2010 15:00:00','mm/dd/yyyy hh24:mi:ss');
TO_DATE is an ORACLE function. Use a Tally table 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)

August 19, 2010 at 3:34 pm

#1209390

Viewing 15 posts - 37,231 through 37,245 (of 59,098 total)