Jeff Moden

Forum Replies Created

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

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
RE: updating records from a staging table while converting and removing trailing or leading spaces

NewBornDBA2017 - Friday, August 17, 2018 8:33 AM
Done
update [Staging].[StgContactdata]
set CompanyNid = REPLACE(CompanyNid, char(9),'')
update [PMG].[Contactdata]
set CompanyNids = convert(int,s.CompanyNid)
FROM [PMG].[Contactdata]...
--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:55 am

#2002269
RE: Long Formats

Steve Jones - SSC Editor - Friday, August 17, 2018 8:10 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 8:38 am

#2002262
RE: Using UPDATE()

TomThomson - Friday, August 17, 2018 8:11 AM
Jeff Moden - Friday, August 17, 2018 7:42 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 8:36 am

#2002261
RE: Using UPDATE()

Heh... this will make a good, quick ice-breaker question for interviews like the "How do you get the current date and time in T-SQL". Litmus strips anyone? 😀
--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:42 am

#2002234

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