Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,476 through 11,490 (of 59,099 total)

RE: Move master DB due to restricted file permissions

alastair.dewar1979 - Saturday, August 18, 2018 5:08 PM
Jeff,
The only server I wish to use is that one running on my own...
--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)

August 18, 2018 at 6:56 pm

#2002372
RE: Annoying error message 'Cannot drop table because table does not exist' in ExecuteSQL Task BIDS 2008.

as0917041 - Friday, August 17, 2018 11:56 PM
To avoid wastage of time, what you can do is try a recovery tool, 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)

August 18, 2018 at 9:12 am

#2002365
RE: Replace String in multiple triggers

Steven.Grzybowski - Friday, August 17, 2018 7:24 PM
Jeff Moden - Friday, August 17, 2018 4:38 PM
--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)

August 17, 2018 at 7:54 pm

#2002341
RE: SSMS and SOS, difference in execution times

Heh... Oh no... I knew what it was. When I first saw the abbreviate when it came out, I was thinking of the old Navy abbreviation for some unknown form...
--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)

August 17, 2018 at 7:53 pm

#2002340
RE: Aggregate Data for the Last Day of the Month

Lynn Pettis - Thursday, August 16, 2018 11:25 PM
Sergiy - Thursday, August 16, 2018 7:22 PM
--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)

August 17, 2018 at 6:54 pm

#2002337
RE: Another Bulk Insert UNC Question... using SQL Authentication

Toddmonster85 - Thursday, August 16, 2018 7:18 PM
Hello... yes, tar and feathers for yet another bulk insert question....
We've chosen not to pursue...
--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)

August 17, 2018 at 6:30 pm

#2002336
RE: SSMS and SOS, difference in execution times

Sooooo..... SOS actually DOES stand for what I thought. 😀
--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)

August 17, 2018 at 6:11 pm

#2002335
RE: Move master DB due to restricted file permissions

alastair.dewar1979 - Friday, August 17, 2018 4:39 PM
Sue,
Many thanks for sending the permissions command through. When I ran the command...
--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)

August 17, 2018 at 6:07 pm

#2002334
RE: Help finding Fullback up file upon which differential backup is based

Lynn Pettis - Friday, August 17, 2018 3:16 PM
The real decision needs to be made by the business. They are the ones...
--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)

August 17, 2018 at 6:00 pm

#2002333
RE: Annoying error message 'Cannot drop table because table does not exist' in ExecuteSQL Task BIDS 2008.

VoldemarG - Friday, August 17, 2018 12:16 PM
It happens even though I include IF EXISTS statement before before Drop Table.
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)

August 17, 2018 at 5:53 pm

#2002332
RE: Converting gibberish String to DateTime

If the Date/Time "Field" is always after the first colon and you only want it to the nearest minute, this will work.

--===== This is NOT a...
--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)

August 17, 2018 at 5:09 pm

#2002331
RE: Replace String in multiple triggers

Steven.Grzybowski - Friday, August 17, 2018 10:37 AM
John Mitchell-245523 - Friday, August 17, 2018 9:37 AM
--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)

August 17, 2018 at 4:38 pm

#2002329
RE: How to a use a temp table as a destination for a dataflow in SSIS

Heh... or just do it all in T-SQL. 😀
--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)

August 17, 2018 at 4:28 pm

#2002328
RE: Long Formats

Steve Jones - SSC Editor - Friday, August 17, 2018 10:20 AM
Jeff Moden - Friday, August 17,...
--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)

August 17, 2018 at 4:27 pm

#2002327
RE: BIDS 2008 - can i insert a column into a comma-delimited flat file after it has been written to?

Why not just make sure that the full monty of data is present to begin with instead of writing out a file, then reading it back in, adding a column...
--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)

August 17, 2018 at 8:57 am

#2002270

Viewing 15 posts - 11,476 through 11,490 (of 59,099 total)