Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,716 through 26,730 (of 59,099 total)

RE: Counting Days with Reset

David.Lester (6/4/2013)
I have been struggling with this all morning, and I think I am missing something obvious. What I need to do is take a typical date dim 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 4, 2013 at 4:45 pm

#1621145
RE: Use of brackets around data names

Howard C. BAchtel-438731 (6/4/2013)
We recently upgraded to SQL Server 2012 and the Query Analyzer defaults to putting all data names inside brackets. Is there a way to change 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)

June 4, 2013 at 4:41 pm

#1621142
RE: Building a server?

Gosh... that's not a bad server (If it's 64 bit... don't know just by looking at processor numbers) especially for a small company. I believe I'd find some way...
--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 4, 2013 at 4:38 pm

#1621140
RE: How to view individual records?

Why wouldn't you just use SELECT TOP 100 * FROM dbo.yourtablename to see the individual rows of data?
--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 4, 2013 at 4:31 pm

#1621138
RE: Are the posted questions getting worse?

Brandie Tarvin (6/4/2013)
My Recovery Plan
1) SCREAM really loudly so everyone knows there is a problem.
2) Run out of the building as fast as possible.
3) Update my resume.
4) Job hunt.
5) Repeat...
--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 4, 2013 at 4:23 pm

#1621136
RE: Best way to find certain records.

No... haven't had the time, unfortunately. It would really be interesting to figure out why the supposed "Best Practice" method caused the optimizer to shift to a Nested Loop...
--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 4, 2013 at 4:19 pm

#1621135
RE: SSIS - What is the best practice for creating a fixed length flat file.

MWise (6/3/2013)
Its not an SSIS best practice because SSIS has built in tasks that already do this without having to write or maintain a single line of code. 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)

June 3, 2013 at 11:01 pm

#1620774
RE: Loading XML Data into SQL Server (SQL Spackle)

jcasement (5/31/2013)
While it offers a very brief sample to get going fast it should at least list other alternatives since some of them are quite nice. Readers need to be...
--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 3, 2013 at 10:54 pm

#1620772
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

I have no clue how to do this in SSIS simply because I don't useSSIS but here's the way I'd do it in T-SQL...
CREATE TABLE #Files
...
--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 3, 2013 at 9:45 pm

#1620765
RE: Are the posted questions getting worse?

Brandie Tarvin (6/3/2013)
Speaking of SQL_Variant, does anyone here actually use it?
I've never found a reason to use it or a need that made sense, so I'd love to hear...
--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 3, 2013 at 6:13 pm

#1620752
RE: Are the posted questions getting worse?

wolfkillj (6/3/2013)
I heard a great joke for nerds (I was about to call it "nerd joke", but it's for nerds, not about nerds) this weekend:
Why do computer science majors always...
--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 3, 2013 at 5:09 pm

#1620748
RE: Are the posted questions getting worse?

dbursey (6/3/2013)
Stefan Krzywicki (6/3/2013)
dbursey (6/3/2013)
Greg Edwards-268690 (6/3/2013)
Stefan Krzywicki (6/3/2013)
Greg Edwards-268690 (6/3/2013)
David Burrows (6/3/2013)
Jack Corbett (5/31/2013)
2. I can't stand when developers create databases without a data professional involved.
:ermm:
I'm...
--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 3, 2013 at 5:04 pm

#1620747
RE: SSIS - What is the best practice for creating a fixed length flat file.

MWise (6/3/2013)
I would not recommend rolling your own code to use FSO to create a fixed width file - that is definitely NOT a best practice. Either use BCP...
--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 3, 2013 at 4:33 pm

#1620744
RE: SSIS - What is the best practice for creating a fixed length flat file.

Sigerson (6/3/2013)
I stand corrected. I checked BOL briefly but I am not an expert with bcp by any means and haven't had any need to use a format file;...
--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 3, 2013 at 10:53 am

#1620656
RE: Are the posted questions getting worse?

Greg Edwards-268690 (6/3/2013)
Stefan Krzywicki (6/3/2013)
Greg Edwards-268690 (6/3/2013)
David Burrows (6/3/2013)
Jack Corbett (5/31/2013)
2. I can't stand when developers create databases without a data professional involved.
:ermm:
I'm a developer, I create...
--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 3, 2013 at 8:32 am

#1620586

Viewing 15 posts - 26,716 through 26,730 (of 59,099 total)