Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,696 through 31,710 (of 59,099 total)

RE: Does the Role of the DBA Need to Evolve?

Kevin Mao-243787 (12/13/2011)
Role of DBAs
Four roles are listed in first Chapter of Professional Microsfot SQL Server 2008 Administration: Production DBA,Development DBA, Business Intelligence DBA & Hybrid DBA. For smaller organzations,...
--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)

December 13, 2011 at 7:04 pm

#1420961
RE: Are the posted questions getting worse?

GSquared (12/13/2011)
jcrawf02 (12/13/2011)
Favorite email exchange of the day (after the other party read the recursive CTE date article in the newsletter, and I pointed them to Jeff's comment/article 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)

December 13, 2011 at 6:52 pm

#1420958
RE: Are the posted questions getting worse?

Ninja's_RGR'us (12/13/2011)
Jeff Moden (12/13/2011)
Steve Jones - SSC Editor (12/13/2011)
SQLRNNR (12/13/2011)
About due for a Pantsectomy :-D:-D:-D:-D
40F in Denver, no need for pants today.:-P
Gah! My eyes, my eyes!!!
Kilt again?? :w00t:~~:hehe:~~
Yep... knocks...
--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)

December 13, 2011 at 6:47 pm

#1420957
RE: Are the posted questions getting worse?

jcrawf02 (12/13/2011)
Favorite email exchange of the day (after the other party read the recursive CTE date article in the newsletter, and I pointed them to Jeff's comment/article in the discussion):
From:...
--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)

December 13, 2011 at 6:45 pm

#1420956
RE: Using Recursion and Date Tables to Simplify Date Logic

ShawnTherrien (12/13/2011)
I learned a bit here, but it turns out that my database is already set up in days with various attributes on them and then periods with their own...
--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)

December 13, 2011 at 5:17 pm

#1420948
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (12/13/2011)
SQLRNNR (12/13/2011)
About due for a Pantsectomy :-D:-D:-D:-D
40F in Denver, no need for pants today.:-P
Gah! My eyes, my eyes!!!
--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)

December 13, 2011 at 3:57 pm

#1420923
RE: Using Recursion and Date Tables to Simplify Date Logic

Sean Cowburn (12/13/2011)
Jeff, thanks for the link. Your article made a lot of sense. Not to mention that the code for the tally solution is much more simple 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)

December 13, 2011 at 3:54 pm

#1420922
RE: Using Recursion and Date Tables to Simplify Date Logic

The Calendar View in the article is based on a "Counting rCTE". Please see the following article for why you should avoid such a thing.
http://www.sqlservercentral.com/articles/T-SQL/74118/
--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)

December 13, 2011 at 6:12 am

#1420558
RE: Divide Decimal value By ^ value(XOR)

G-472796 is correct. You're probably looking for the POWER function. Just keep in mind that POWER returns the same datatype as the first operand. For example, trying...
--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)

December 13, 2011 at 5:54 am

#1420548
RE: find table relationships

You bet. Thank you for the feedback.
If you ever design tables, remember what you just went through. 🙂
--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)

December 13, 2011 at 5:33 am

#1420533
RE: DataBase Enging Tuning

Dev (12/13/2011)
Jeff Moden (12/12/2011)
Option 4... provided that it ISN'T a production server, learn from your mistakes... let DTA rip and discover the problems it causes. "A Developer...
--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)

December 13, 2011 at 5:27 am

#1420523
RE: SELECT statement - value gets truncated when selecting from XML column

MidBar (12/13/2011)
Hi Jeff,
Yes 8192 is the limit.
I want to read very long xmls from a table and concatenate in with a string to make dynamic SQL and later execute that.
Now...
--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)

December 13, 2011 at 5:04 am

#1420513
RE: Is a good practice to put a state field in a table?

luis martin ortiz barrutia (12/12/2011)
I wonder why other DBMS like clipper , foxpro, vfp, dbase, has the option to delete records as logically delete and kepp it 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)

December 12, 2011 at 10:10 pm

#1420351
RE: Tempdb 838GB's 2 mornings in a row

SkyBox (12/8/2011)
MyDoggieJessie (12/8/2011)
Difficult to tell with out a StartTime reference as well but those are some seriously long durations. Looks to me that a LOT of SSIS jobs are...
--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)

December 12, 2011 at 9:58 pm

#1420347
RE: Need help with Unpivot

dndaughtery (12/12/2011)
I have a sproc that counts the number of records where certain columns from matching records in 2 tables aren't eual in value as below.
Select
sum(case when WS.[PID]...
--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)

December 12, 2011 at 9:52 pm

#1420345

Viewing 15 posts - 31,696 through 31,710 (of 59,099 total)