Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,421 through 18,435 (of 59,070 total)

RE: Setting up a SQL job that uses Bulk Load

Have you tried removing the "Run As" user?
--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 12, 2016 at 8:19 am

#1858371
RE: How to extract overlapping date ranges from a table of date ranges

Itzik Ben-Gan wrote about this quite a while back but he took the post down and haven't seen it reposted. Might be around somewhere.
Anyway, I'm assuming that some decent...
--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 11, 2016 at 7:43 pm

#1858230
RE: How to provide full alter permissions on a db

Heh... keep it simple. Give no one privs to do anything except execute stored procedures. 😀
--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 11, 2016 at 4:15 pm

#1858211
RE: Are the posted questions getting worse?

Michael L John (2/11/2016)
Sean Lange (2/11/2016)
Grumpy DBA (2/11/2016)
^ I think Michael L John beats you in the "dating yourself" category.
Indeed!!
Yeah, but I'm still younger than Moden!
Yeah... but I'm better looking...
--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 11, 2016 at 2:14 pm

#1858182
RE: Transaction log sizing of read-only databases

Ed Wagner (2/10/2016)
If it's truly read-only, then I'd guess that all index rebuilds and other optimizations should have already been done. Since you don't have any changes being written,...
--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 10, 2016 at 8:14 pm

#1857915
RE: Syntax Help Please

mw112009 (2/10/2016)
RBAR:
"scanning the table twice" ???.
We have 2 different tables ?
Also it would be nice if you could throw the syntax ( I have not used the ROLLUP before )
Luis'...
--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 10, 2016 at 9:21 am

#1857763
RE: Syntax Help Please

Instead of scanning the table twice, my suggestion would be to use a GROUP BY WITH ROLLUP and simply sort the output based on GROUPING().
--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 10, 2016 at 8:30 am

#1857739
RE: Report sent with subscription missing logo (.jpg)

mario17 (2/8/2016)
Update for all and another call for help!!
I figured out that subscription is running under service account, so I need to provide <Image access for this account>, not 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)

February 8, 2016 at 5:47 pm

#1857292
RE: SpinLocks

kkanaya (2/8/2016)
Hello,
Does anyone know what the following Spinlocks stand for?
name ...
--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 8, 2016 at 5:39 pm

#1857291
RE: Load text file to multiple tables in SQL server

mxy (2/8/2016)
Thanks it worked let me work on first set of data in the file.
Thanks again for your time.
How? When I try to load the file with Luis' code,...
--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 8, 2016 at 4:29 pm

#1857284
RE: Crafting Your Resume

Beatrix Kiddo (2/8/2016)
We're not allowed to install anything on our PCs (yeah), but it's a sound idea. I'm doing my best to stay motivated, but when nobody else cares it'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 8, 2016 at 4:14 pm

#1857282
RE: Crafting Your Resume

David.Poole (1/28/2016)
Curious what constitutes a suspicious gap, and does this apply when looking for contractors? What about a contractor looking for a permanent position now?
Very short employment periods, lots...
--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 8, 2016 at 4:11 pm

#1857281
RE: CHARINDEX

Anthony Ganley (2/8/2016)
I have list of 1000's of ID's - example below....
On a slightly different tack, where does the ORIGINAL data in that condition come from? If it's coming...
--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 8, 2016 at 3:55 pm

#1857279
RE: Partitioning in sql server 2012

PJ_SQL (2/8/2016)
"separate IO subsystems" does it mean multiple processors?
To add to what Gail said, it usually means separate disk "spindles" at the very least.
And I also agree. I've never...
--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 8, 2016 at 9:31 am

#1857166
RE: calculate total salary based on employee type

coolcurrent4u (2/8/2016)
Hello
see an sql fiddle http://sqlfiddle.com/#!3/f4be2/1
Regards
You should post your stuff on this site for two reasons...
1. Your SQL Fiddle says "loading" and "Please build Schema". Its useless (for...
--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 8, 2016 at 9:23 am

#1857163

Viewing 15 posts - 18,421 through 18,435 (of 59,070 total)