Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,771 through 16,785 (of 59,101 total)

RE: How to close a file to move to another disk

The long boot time may be because all your databases are in the FULL Recovery Model, no backups have ever been taken, the log files have gotten huge, and they...
--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 23, 2016 at 12:46 pm

#1902901
RE: Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

paolo.bert (9/23/2016)
What to say, Jeff... First of all, maaany thanks for your thorough reply. I was afraid to post a so 'stupid' question on this Guru's cave, but now 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)

September 23, 2016 at 11:38 am

#1902879
RE: Urgent Help Need for DB Restoration

Now that you've solved your problem, prepare for the next problem by practicing how to do a restore until you can do it in your sleep. Having restore scripts...
--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 23, 2016 at 9:49 am

#1902836
RE: Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

paolo.bert (9/23/2016)
I am not a PRO, but I used them in Access97, writing SQL code (TRANSFORM command), a long time ago, and as far as I remember there wasn't 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 23, 2016 at 9:01 am

#1902812
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

Viewing 15 posts - 16,771 through 16,785 (of 59,101 total)