Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,436 through 21,450 (of 59,072 total)

RE: Export Fixed Width

elee1969 (2/26/2015)
Is using Ragged Right adding another column?
What's preventing you from trying it to see?
--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)

February 26, 2015 at 5:09 pm

#1780432
RE: Nested Cursor example

There's no question here. The third select on the original post shows the set-based replacement for the cursors. The title truly reflects what was posted... it's an example....
--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)

February 26, 2015 at 5:03 pm

#1780431
RE: Share your best possible answers--

Moin Ul Haque (2/26/2015)
Jeff Moden (2/25/2015)
Moin Ul Haque (2/25/2015)
I can quote my own experience here - Out of need, I was asked to develop a database maintenance solution which would...
--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)

February 26, 2015 at 5:00 pm

#1780430
RE: Are the posted questions getting worse?

Steve Thompson-454462 (2/26/2015)
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences....
--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)

February 26, 2015 at 3:46 pm

#1780422
RE: Are the posted questions getting worse?

Lynn Pettis (2/25/2015)
... Mark one off, 2 days on the calendar to go. 2 days on the calendar to go, 2 days to go, ...
And for the geeks out there:
......
--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)

February 25, 2015 at 9:56 pm

#1780116
RE: Alpha numeric range groupping

ibbo14 (2/25/2015)
They need to be grouped by range specific to the alpha numeric part, which can vary within the same despatch.
Will the alpha-numeric part ALWAYS be 3 characters starting at...
--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)

February 25, 2015 at 9:02 pm

#1780109
RE: Query help. Previous using previous row

johnnycougar (2/25/2015)
If I could get some assistance to figure out how to update this temporary table, I can handle the rest downstream.
Not entirely true for what you need...
--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)

February 25, 2015 at 5:08 pm

#1780094
RE: Trying to insert results from sp_spaceused (tablename) into different table.

Dan121 (2/25/2015)
did this: exec sp_spaceused 'AdventureWorks.person.address' still not working 🙁
Heh... what does that mean? "Still not working". Are you getting an error? What are the symptoms?
--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)

February 25, 2015 at 4:37 pm

#1780089
RE: Remove the double quote

kennyhuang0108 (2/24/2015)
Hi Jeff,
I need to output to text file so that another department can upload to its DB and migrate to another system.
That is the whole project about.
Thanks.
If...
--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)

February 25, 2015 at 4:32 pm

#1780087
RE: delete data from partitions - faster approach

Tara-1044200 (2/20/2015)
partitioned tables using enterprise 2008.
The proper way to do it would be to SWITCH out the month(s) of data that you want to delete, drop the switched out table(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)

February 25, 2015 at 4:24 pm

#1780085
RE: The best way to write this sql query

fdthompson35 (2/25/2015)
we want the following fields from the PERSON table
personid
personnum
fullnm
we want the following field from the ASSIGNPAYRULE TABLE
payruleid
where the personid from the PERSON table = the employerid 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)

February 25, 2015 at 2:40 pm

#1780069
RE: Are the posted questions getting worse?

Brandie Tarvin (2/25/2015)
Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist (the star) is humanoid but not human.
I...
--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)

February 25, 2015 at 1:56 pm

#1780060
RE: Are the posted questions getting worse?

SQLBill (2/25/2015)
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. ...
--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)

February 25, 2015 at 1:53 pm

#1780058
RE: How to find who is indirectly connected to a database?

Grant Fritchey (2/25/2015)
Those are cross-database queries and not technically connections between the databases. First, I'd suggest reexamining your security to prevent that type of stuff if it's occurring in ways...
--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)

February 25, 2015 at 1:48 pm

#1780056
RE: Restore to Point in Time DURING Differential Backup

As a bit of a sidebar, I can't figure out why anyone would allow a DIF backup to continue during a PIT Restore.
--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)

February 25, 2015 at 11:50 am

#1780025

Viewing 15 posts - 21,436 through 21,450 (of 59,072 total)