Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,171 through 34,185 (of 59,099 total)

RE: Need help with script

sql2k8 (4/21/2011)
TABLE A values ...
--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)

April 24, 2011 at 8:23 pm

#1315302
RE: ERD diagram vs. Implementation

SethT3 (3/11/2010)
I am a database administrator. I am not a data architect. I am easily confused.
I am working with a SQL Server 2005 database that has little 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)

April 24, 2011 at 8:13 pm

#1315301
RE: Are the posted questions getting worse?

LutzM (4/23/2011)
... or even within one page:
Did you folks notice that the "Add to briefcase" button is now available for forum posts, too?
THANK YOU STEVE!!!
Makes SSC even more convenient...
--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)

April 24, 2011 at 7:25 pm

#1315298
RE: Normalization

Duplicate post withdrawn.
--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)

April 24, 2011 at 4:16 pm

#1315294
RE: Import/Export files (.txt/.csv/.xls) into SQL 2005 Compact Edition

Ok... I got all of my griping out of the way :-D. Does anyone have an answer for balasach82 question about how to import txt/csv/xls data into CE because...
--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)

April 24, 2011 at 4:12 pm

#1315293
RE: Import/Export files (.txt/.csv/.xls) into SQL 2005 Compact Edition

David Burrows (4/24/2011)
Jeff Moden (4/23/2011)
Pardon my ignorance. What's an "SDF"?
Crikey Jeff, I'm agog with amazement :hehe:
You being a SQL god an 'all 🙂
I guess DBA's don't venture out of...
--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)

April 24, 2011 at 3:44 pm

#1315290
RE: NEED HELP= Monthly SQL database growth calculation script

Syed Jahanzaib Bin hassan (4/24/2011)
Check this script if you have any problem or modification required then tell me
Did you read this statement in the end of my post
Regards,
Syed Jahanzaib Bin...
--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)

April 24, 2011 at 3:24 pm

#1315288
RE: Need Urgent Help with Capacity Report Script

I hate it when this happens. This is a duplicate post. The other post is at http://www.sqlservercentral.com/Forums/Topic1097279-391-1.aspx
--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)

April 24, 2011 at 3:23 pm

#1315287
RE: Normalization

Welsh Corgi (4/24/2011)
I'm sure that you know that you can determinte information from the FIPS county code so that you do not need to store a lot of information 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)

April 24, 2011 at 3:15 pm

#1315284
RE: NEED HELP= Monthly SQL database growth calculation script

Syed Jahanzaib Bin hassan (4/22/2011)
CREATE TABLE DBINFO(ID INT IDENTITY(1,1) PRIMARY KEY
...
--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)

April 23, 2011 at 9:53 pm

#1315226
RE: Import/Export files (.txt/.csv/.xls) into SQL 2005 Compact Edition

Pardon my ignorance. What's an "SDF"?
--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)

April 23, 2011 at 9:46 pm

#1315225
RE: Normalization

Welsh Corgi (4/23/2011)
Jeff,
I have no issues with your address solution but it requires an extra join and it can degrade performance.
If the objective is perfect normalization then go with an...
--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)

April 23, 2011 at 9:37 pm

#1315224
RE: Need Urgent Help with Capacity Report Script

hydbadrose (4/17/2011)
I created the store pro cedure with all the other information
I missed that. If you'd care to share that stored procedure, I can show you a couple of...
--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)

April 23, 2011 at 5:09 pm

#1315219
RE: Date function in sql server 2005

getalok_akg (4/23/2011)
HI Jeff Moden,
Many many thanks for your reply , In my application , we are considering week from Saturday to friday .Let me elaborate more :
Week 1 (for 2011)...
--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)

April 23, 2011 at 4:10 pm

#1315206
RE: Difference between temp table, table variable, derived table and CTE

Gosh, if that didn't sound like an interview question, I don't know what does.
--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)

April 23, 2011 at 4:00 pm

#1315204

Viewing 15 posts - 34,171 through 34,185 (of 59,099 total)