Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,701 through 11,715 (of 59,099 total)

RE: Automate daily table backup

Ah... yeah. Agreed.
Unfortunately, it looks like the OP has flown the coop.
--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)

July 27, 2018 at 7:39 pm

#1999333
RE: SQL/DBA freelance work

Let's see... you've posted no references, no links, no resume, you joined this site 9 years ago, made exactly one reply post, and now you expect this site to be...
--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)

July 27, 2018 at 9:28 am

#1999260
RE: Speeding Up Incremental ETL Proceses in SSIS by Using MD5 Hashes

sabyasm - Thursday, September 2, 2010 10:22 AM
[font="Comic Sans MS"]This is an excellent article.However - I am facing a peculier problem 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)

July 27, 2018 at 7:50 am

#1999241
RE: How to pass and use Variable on CTE

luissantos - Friday, July 27, 2018 7:14 AM
Hello,
Thanks for all your replies , i will go create function to split values.
Many thanks
LS
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)

July 27, 2018 at 7:46 am

#1999240
RE: dm_db_index_physical_stats - LIMITED or DETAILED

p.s. Am I suggesting that you should use GUIDs in all cases? NOT ON YOUR LIFE! If you truly have an APPEND ONLY INSERT index that suffers no "ExpAnsive"...
--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)

July 27, 2018 at 7:41 am

#1999236
RE: dm_db_index_physical_stats - LIMITED or DETAILED

Leo.Miller - Thursday, July 26, 2018 8:40 PM
I'm really interested in this:
And let me know if those 3rd party apps 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)

July 26, 2018 at 10:46 pm

#1999193
RE: dm_db_index_physical_stats - LIMITED or DETAILED

Leo.Miller - Wednesday, July 25, 2018 8:46 PM
Being in the SQL Server Managed Services business I (we) have too many clients...
--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)

July 26, 2018 at 6:50 pm

#1999186
RE: Joining large tables to small tables.

andycadley - Thursday, July 26, 2018 12:18 PM
sgmunson - Thursday, July 26, 2018 11:26 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)

July 26, 2018 at 3:21 pm

#1999171
RE: Deleting Data

Eric M Russell - Thursday, July 26, 2018 7:02 AM
That guy in the dapper suit with no history and the perfectly crafted...
--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)

July 26, 2018 at 10:32 am

#1999129
RE: Are the posted questions getting worse?

Sean Lange - Thursday, July 26, 2018 8:17 AM
Some of you probably know that I have played bass in several bands over...
--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)

July 26, 2018 at 8:30 am

#1999112
RE: Are the posted questions getting worse?

Grant Fritchey - Thursday, July 26, 2018 7:43 AM
Jeff Moden - Thursday, July 26, 2018 7:33 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)

July 26, 2018 at 8:12 am

#1999108
RE: Are the posted questions getting worse?

Luis Cazares - Thursday, July 26, 2018 7:45 AM
Jeff Moden - Thursday, July 26, 2018 7:33 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)

July 26, 2018 at 7:59 am

#1999102
RE: Extended events question

vsamantha35 - Thursday, July 26, 2018 3:40 AM
Hi All,
I have a question related to extended event ring buffer target.
In SQL Server,...
--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)

July 26, 2018 at 7:51 am

#1999099
RE: Are the posted questions getting worse?

Again, no need to pile on but I wanted you to see this one, as well.
https://www.sqlservercentral.com/Forums/1978632/Try-catch-block-in-SQL-statement-not-in-TSQL
Heh... people wonder why I start interviews with the...
--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)

July 26, 2018 at 7:33 am

#1999091
RE: Automate daily table backup

andycadley - Thursday, July 26, 2018 6:48 AM
Indeed. And how you solve the problem if you do care might depend on 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)

July 26, 2018 at 6:54 am

#1999078

Viewing 15 posts - 11,701 through 11,715 (of 59,099 total)