Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,711 through 10,725 (of 59,095 total)

RE: DT_BYTE to DT_DBDATE

jklenk86 - Monday, November 5, 2018 7:12 AM
Jeff Moden - Sunday, November 4, 2018 8:20 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)

November 5, 2018 at 7:23 am

#2012388
RE: Execute a Stored Procedure against every row insert in Table

azhar.iqbal499 - Monday, November 5, 2018 4:10 AM
I have around 200 tables and we have insert in each table with in each...
--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)

November 5, 2018 at 6:01 am

#2012377
RE: Reaping the benefits of the Window functions in T-SQL

Lynn Pettis - Friday, November 2, 2018 10:32 AM
Eirikur Eiriksson - Friday, November 2, 2018 8:08 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)

November 5, 2018 at 5:34 am

#2012372
RE: The SQL Twilight Zone

Steve Jones - SSC Editor - Friday, November 2, 2018 1:30 PM
Rod at work - Friday, November...
--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)

November 4, 2018 at 5:28 pm

#2012359
RE: OPENROWSET - issue with spaces in the file name

mr-967650 - Sunday, November 4, 2018 4:59 PM
Jeff Moden - Sunday, November 4, 2018 4:34 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)

November 4, 2018 at 5:25 pm

#2012358
RE: What can be the benefits of copy_only backup

The biggest benefit is that the DBA team won't kill you for screwing up their backups. 😉
--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)

November 4, 2018 at 5:23 pm

#2012357
RE: How To Truncate Log with Transaction Replication

ken 16613 - Thursday, November 1, 2018 11:43 PM
For the record, I ran in to a couple of issues executing the plan...
--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)

November 4, 2018 at 5:03 pm

#2012356
RE: Full Backup Files - Fastest Way to Copy Over WAN

dajonx - Friday, November 2, 2018 7:31 AM
Ohh, my attempted blog. Haha!
Do you happen to have Riverbed appliances? I noticed that SMB2/SMB3 are...
--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)

November 4, 2018 at 4:58 pm

#2012354
RE: Concatenate Strings in a COLUMN using comma delimiter, I need some nice code.

mw_sql_developer - Friday, November 2, 2018 9:52 AM
Folks.. No need to reply... All set, I just modified the code a bit ,...
--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)

November 4, 2018 at 4:53 pm

#2012353
RE: OPENROWSET - issue with spaces in the file name

frederico_fonseca - Sunday, November 4, 2018 4:26 PM
Cant try it at the moment but in any case a word of advise.
ACE driver...
--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)

November 4, 2018 at 4:34 pm

#2012352
RE: TSQL query suddenly taking hours to run

Wolfmeister - Sunday, November 4, 2018 2:44 PM
Thanks for the replies guys, much appreciated.
I've tried adding the suggested index, so I'll...
--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)

November 4, 2018 at 4:06 pm

#2012350
RE: OPENROWSET - issue with spaces in the file name

mr-967650 - Sunday, November 4, 2018 1:04 PM
Jeff Moden - Sunday, November 4, 2018 11:45 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)

November 4, 2018 at 3:59 pm

#2012349
RE: OPENROWSET - issue with spaces in the file name

I've not been able to make it fail with the following code, which I've just tested on my box.

SELECT *
FROM OPENROWSET
(
--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)

November 4, 2018 at 11:45 am

#2012344
RE: Explaining Our Professions to Our Parents

stan.kappiris - Saturday, November 3, 2018 6:35 PM
Iâ€™ve been playing with computers a long time. But when somebody asks me what 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)

November 4, 2018 at 10:51 am

#2012343
RE: synonyms vs views when using a linked server

JSB_89 - Sunday, November 4, 2018 8:32 AM
Thanx Jeff will check with the SAN team, but going back to my original question...
--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)

November 4, 2018 at 9:13 am

#2012342

Viewing 15 posts - 10,711 through 10,725 (of 59,095 total)