Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,741 through 16,755 (of 59,067 total)

RE: Staging area best practice

Having 3 different databases has other advantages than those already mentioned. The BIG ones are that your "IMPORT" and "STAGING" databases likely don't need to be backed up because...
--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)

September 22, 2016 at 4:36 pm

#1902678
RE: Today's Random Word!

djj (9/22/2016)
Y.B. (9/22/2016)
djj (9/22/2016)
Revenant (9/22/2016)
Kaye Cahs (9/22/2016)
eccentricDBA (9/22/2016)
Ray K (9/21/2016)
Ed Wagner (9/21/2016)
Grumpy DBA (9/21/2016)
Ed Wagner (9/20/2016)
Grumpy DBA (9/20/2016)
Ed Wagner (9/20/2016)
Butter
Face
Palm
Rosey
Garden
Madison (Square)
Zingers (Dolly Madison Bakery)
Snoballs ®
Calories
Counting
Down
Out
Delivery
--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)

September 22, 2016 at 12:44 pm

#1902614
RE: Email alerts when server reboots

Credits to Navy beans bet on it being a "Startup Proc". See the following for more details...
https://www.google.com/?gws_rd=ssl#q=startup+procs+sql+server
{edit} Apologies... didn't scroll down far enough. Didn't see Richard's post nor...
--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)

September 22, 2016 at 12:29 pm

#1902606
RE: Cleaning up "rotten" tables - need help with code

I'd be in deep Kimchie if I deleted some of my empty tables because they're used to prop up some very necessary "Instead of" triggers on a View that we...
--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)

September 22, 2016 at 12:28 pm

#1902605
RE: Migrating Multiple Tables from one DB to Another

I don't use SSIS so I can't help much there but... how would setting up Replication (not a favorite of mine, BTW) for these 21 tables compare or is that...
--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)

September 22, 2016 at 12:10 pm

#1902598
RE: The 10X Programmer

Rod at work (9/22/2016)
Jeff Moden (9/21/2016)
djackson 22568 (9/21/2016)
Jeff Moden (9/21/2016)
Steve Jones - SSC Editor (9/21/2016)
Jeff Moden (9/19/2016)
To be honest, I've yet to run into a supposed 10X programmer that's worth...
--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)

September 22, 2016 at 10:07 am

#1902532
RE: How to use BCP to Import Data from .xls or .csv files

david.leyden (9/21/2016)
I import a lot of flat text and I would use BULK INSERT to do it from the server side and BCP to do it from client side. BCP...
--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)

September 22, 2016 at 7:40 am

#1902464
RE: The 10X Programmer

Sean Redmond (9/22/2016)
I wonder how attractive a 10x programmer (or DBA in this case) would be to a manager. Sure, it's great to have a person that does the work...
--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)

September 22, 2016 at 7:32 am

#1902459
RE: Server Drive Configuration

Terry B-214928 (9/22/2016)
Backups are on a separate server.
Thanks
With that out of the way, then I agree... you probably don't need to put TempDB on a separate drive.
I will also advise...
--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)

September 22, 2016 at 7:01 am

#1902450
RE: Want to learn SQL

BrainDonor (9/22/2016)
chatwithgeorgelucas (9/22/2016)
Hey Jeff, Can you please provide me the link. Thanks in advance.
In case you've misunderstood Jeff's humour -
Using either Yahoo, Google or Bing search for "SQL Tutorial"...
--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)

September 22, 2016 at 6:05 am

#1902421
RE: Processing Flat file with no delimiters

joeroshan (9/22/2016)
Jeff Moden (9/21/2016)
I ask because the easiest and absolutely fastest way to import this data would be do create a BCP format file with line sensitivity. It 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)

September 22, 2016 at 5:48 am

#1902409
RE: Backup Restoring - Insufficient free space

Minnu (9/21/2016)
Hi Team,
Restoring SQL Server database from one server to another.
Actual Database size is: 14.3 GB
But while restoring getting below error.
The database required 127533776896 additional free bytes, while only 47082643456...
--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)

September 21, 2016 at 4:14 pm

#1902312
RE: Server Drive Configuration

Terry B-214928 (9/21/2016)
Hello - We will be setting up a SQL server to host our accounting system databases. There will be around 90 users accessing the system.
The server has...
--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)

September 21, 2016 at 4:09 pm

#1902311
RE: Processing Flat file with no delimiters

waxb18 (9/21/2016)
Morning All,
I've received a flat file which needs to processed into a SQL table, the only problem being that the file has no column delimiters hence when imported...
--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)

September 21, 2016 at 3:04 pm

#1902302
RE: How to use BCP to Import Data from .xls or .csv files

You don't need to use XP_CmdShell and BCP to import unless you're working around a privs issue.
And, to skip the headers, use the "First Row" option.
--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)

September 21, 2016 at 2:56 pm

#1902297

Viewing 15 posts - 16,741 through 16,755 (of 59,067 total)