Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,901 through 24,915 (of 59,099 total)

RE: Updating a column in one table from another table

Just to be clear, Chris was trying to get the OP to teach themselves how to answer such simple questions on their own instead of making them permanently dependent on...
--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)

January 3, 2014 at 8:42 pm

#1677479
RE: Breaking Down Barriers

below86 (1/3/2014)
Jeff Moden (1/3/2014)
..."Tips'n'Tricks" ....
Is there a place on this site where these type tips and tricks can/are posted? Under 'Scripts'? Or is there a place under 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)

January 3, 2014 at 8:11 pm

#1677477
RE: Are the posted questions getting worse?

We really dodged the bullet with the "Hercules" snowstorm than nailed New England. We only got about 6 inches here about 20 miles north of Detroit.
That's about to change......
--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)

January 3, 2014 at 8:00 pm

#1677476
RE: SQL rollback issues keep occurring due to lack of drive space

mbrady (1/3/2014)
Just as an FYI I found that error in case anyone else comes searching for a similar issue.
Msg 9002, Level 17, State 4, Line 3
The transaction log for database...
--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)

January 3, 2014 at 7:48 pm

#1677475
RE: sort by serialcode

The following will handle more levels than you can shake a stick at with numbers as large as 99999999. You'll need the DelimitedSplit8K function for this and I've included...
--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)

January 3, 2014 at 5:18 pm

#1677471
RE: DBCC

JohnFTamburo (1/3/2014)
nihal9200_kwada (1/3/2014)
Can I use DBCC RULEOFF and DBCC RULEON in a trigger ? I want to disable merge and hash joins optimizer rules.
And also Do I need to provide...
--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)

January 3, 2014 at 4:24 pm

#1677463
RE: SQL rollback issues keep occurring due to lack of drive space

mbrady (1/3/2014)
Wash, rinse and repeat for as many times as it takes to fill the table using all the distinct codes. This was working fine until I forgot 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)

January 3, 2014 at 4:15 pm

#1677461
RE: Breaking Down Barriers

andrew.morrell 67746 (1/3/2014)
DBAs and Developers are at times both purists but I find that developers tend to be a little more pragmatic in allowing some things to wait until 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)

January 3, 2014 at 12:56 pm

#1677418
RE: DBCC

nihal9200_kwada (1/3/2014)
Can I use DBCC RULEOFF and DBCC RULEON in a trigger ? I want to disable merge and hash joins optimizer rules.
And also Do I need to provide any...
--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)

January 3, 2014 at 12:28 pm

#1677413
RE: There is insufficient system memory in resource pool 'default' to run this query

krishnamohan6669 (1/1/2014)
Perl script job which inserts data for about 5GB daily.and they are doing the same process from many months and they are experiencing the problems from recent months.
Can u...
--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)

January 3, 2014 at 12:24 pm

#1677410
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

jimgawn (1/3/2014)
Thank you for your gracious response!
With respect to formatted Date tables, I think a lot of data warehousing folks would beg to differ. People like Ralph Kimball advocate...
--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)

January 3, 2014 at 11:56 am

#1677403
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

dwain.c (1/2/2014)
Thanks yet again for an insightful article (probably one of the few of your I hadn't read prior). Indeed, a crack was filled.
I was curious what the SQL...
--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)

January 3, 2014 at 9:06 am

#1677335
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

jimgawn (1/2/2014)
"We all know that formatting data in SQL Server is your basic Bozo-no-no".
No we don't. That's a Luddite position. T-SQL has a fairly rich set of string-manipulation...
--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)

January 3, 2014 at 8:55 am

#1677326
RE: Exclude Columns When Using Bulk Insert

That would be the exact reason for reading the column header into a table and doing the comparison. It would show the basic structure to the user and identify...
--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)

January 3, 2014 at 8:31 am

#1677312
RE: Query for specific format

Excellent. Thanks for the feedback.
On the Oracle shift that you're having to make (I had to work with Oracle for about 3 years), my best advice would be 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)

January 3, 2014 at 8:28 am

#1677307

Viewing 15 posts - 24,901 through 24,915 (of 59,099 total)