Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,181 through 24,195 (of 59,099 total)

RE: Permissions

raghu.sudheer (3/12/2014)
Thanks for the reply. These are all DATABASE level and if create a new database i need to grant permissions to that DATABASE.
Is there any way that all...
--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)

March 12, 2014 at 7:37 pm

#1696612
RE: How to archive emails from yahoo?

SQL Guy 1 (3/12/2014)
I need to archive all my emails from all folders from yahoo. Are there any tools, programs to do this? I need to save them 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)

March 12, 2014 at 7:32 pm

#1696610
RE: help with a instead of trigger

gfoulks (3/12/2014)
okay so the table in question has the following columns
DateTime
Acct_Number
SSN
Script_Code
Div_indicator
first_name
last_name
ani
terminate_area
transfer_area
Periodically we are getting records in this table where ani = 614xxxxxxx
We want to prevent all records with the ani...
--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)

March 12, 2014 at 7:19 pm

#1696609
RE: Help with hierarchical structure without hierarchical relation field...

PiMané (3/12/2014)
Nevyn (3/12/2014)
That wasn't what I was suggesting.
What were you going to put in the calculated Parent ID column for Sean's solution? Surely you weren't going to refer...
--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)

March 12, 2014 at 7:12 pm

#1696608
RE: Are the posted questions getting worse?

Luis Cazares (3/12/2014)
dwain.c (3/12/2014)
Luis Cazares (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.
Thanks in advance.
P.S. Please don't ask for DDL and sample 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)

March 12, 2014 at 6:43 pm

#1696603
RE: avoid self join

dwain.c (3/12/2014)
mxy (3/12/2014)
Thanks for you reply that works perfect!
in case if we have 10 payments (empsal, empsal1..empsal9) and dates paiddate1 through 10 what we need to do?
Did you try my...
--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)

March 12, 2014 at 6:36 pm

#1696602
RE: I need to delete 20 million rows from a table...

GilaMonster (3/12/2014)
Jeff Moden (3/12/2014)
GilaMonster (3/12/2014)
MyDoggieJessie (3/12/2014)
TRUNCATE will be faster and be minimally logged.
Fully logged. It's efficiently logged, but it is fully logged, not minimally logged. Minimally logged has a specific...
--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)

March 12, 2014 at 5:36 pm

#1696586
RE: A True SQL OS

jownby (3/12/2014)
DavidL (3/12/2014)
It would be an interesting scenario, sort like paying a premium to M$ to NOT have windows installed:-P
Is that like when Porsche wants to sell you...
--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)

March 12, 2014 at 2:46 pm

#1696548
RE: I need to delete 20 million rows from a table...

Very cool. Thanks for the feedback. Just wanted to make sure.
--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)

March 12, 2014 at 2:44 pm

#1696547
RE: I need to delete 20 million rows from a table...

Siberian Khatru (3/12/2014)
Shrinking my files down to a manageable level which should solve my disk space crunch a bit.
Shrinking your files will also make a narly trainwreck out of your...
--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)

March 12, 2014 at 1:10 pm

#1696529
RE: I need to delete 20 million rows from a table...

GilaMonster (3/12/2014)
MyDoggieJessie (3/12/2014)
TRUNCATE will be faster and be minimally logged.
Fully logged. It's efficiently logged, but it is fully logged, not minimally logged. Minimally logged has a specific definition.
I do wish...
--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)

March 12, 2014 at 1:08 pm

#1696528
RE: Are the posted questions getting worse?

Greg Edwards-268690 (3/11/2014)
And 5 or 6 lines of MDX likely solves the whole thing if you build a cube.
Or use PowerPivot in Excel to let the user play with 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)

March 11, 2014 at 10:09 pm

#1696209
RE: Core T-SQL

@chrism-2,
I noticed that you've not written an article on this subject yet and thought I'd give you a nudge. I think the list you came up with is outstanding...
--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)

March 11, 2014 at 8:19 pm

#1696206
RE: Are the posted questions getting worse?

Grant Fritchey (3/11/2014)
Editing and rewriting the query tuning book for 2014 when I came across this:
Queries may be attempting to deal with data in a row-by-row fashion (or to quote...
--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)

March 11, 2014 at 6:19 pm

#1696190
RE: Copy file to folder with current date

Gary Varga (3/11/2014)
Jeff has a great point and it shouldn't be an issue but please note:
Applies To: Windows 8, Windows Server 2008, Windows Server 2012, Windows Vista
That's what they say....
--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)

March 11, 2014 at 9:33 am

#1696038

Viewing 15 posts - 24,181 through 24,195 (of 59,099 total)