Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,926 through 14,940 (of 59,097 total)

RE: Why do some DBAs avoid DATETIME2?

Sergiy - Wednesday, June 7, 2017 7:21 AM
Jeff Moden - Wednesday, June 7, 2017 7:07 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)

June 7, 2017 at 7:47 pm

#1945922
RE: zipping to .gz

Heh... I hate people that send me .gz files and .rar files and all the rest. Just send me a good ol' fashion .zip file that works fine just about...
--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)

June 7, 2017 at 5:50 pm

#1945919
RE: Best way to handle a table-based queue?

Ok... first, there is no need for an explicit transaction. Having an explicit transaction for the two examples is a classic setup on a table for a pot wad of...
--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)

June 7, 2017 at 5:43 pm

#1945918
RE: Best way to handle a table-based queue?

Sam-263310 - Wednesday, June 7, 2017 9:28 AM
Matt Miller (4) - Wednesday, June 7, 2017 8:53 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)

June 7, 2017 at 1:17 pm

#1945887
RE: Simulate filling Transaction log

Sergiy - Wednesday, June 7, 2017 12:45 AM
abhij33t - Tuesday, May 23, 2017 7:33 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)

June 7, 2017 at 9:30 am

#1945841
RE: Why do some DBAs avoid DATETIME2?

Sergiy - Monday, June 5, 2017 8:53 PM
Adding to the pile:
Performance of operations on DATETIME2 is 20...100 times (depending on the operation)...
--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)

June 7, 2017 at 7:07 am

#1945800
RE: Best way to handle a table-based queue?

Sam-263310 - Tuesday, June 6, 2017 9:53 AM
NOTE: This is NOT a Service Broker question.

I have a table (ItemQueue) with items to...
--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)

June 6, 2017 at 9:27 pm

#1945718
RE: what is good career Sql Developer or sql DBA ?

xsevensinzx - Tuesday, June 6, 2017 7:37 AM
Most of the statistics and information out now is saying anything developer related is churning...
--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)

June 6, 2017 at 8:47 am

#1945632
RE: archive file which is older than week

If the file named file_data_181203.txt.zip contains the file named file181203.txt, then it's pound foolish to copy the txt file along with the zip file. Gross duplication of data. Just drop...
--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)

June 5, 2017 at 5:51 pm

#1945508
RE: UPDATE Duplicates Except for One Record in a Table

donato1026 - Tuesday, May 30, 2017 3:14 PM
Okay. And this will keep the most recent record? I want to keep the most...
--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)

June 5, 2017 at 9:10 am

#1945425
RE: Hierarchical data :skipping child rows up to the parent

SJanki - Monday, May 15, 2017 8:23 PM
Joe Torre - Monday, May 15, 2017 5:51 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)

June 4, 2017 at 9:41 pm

#1945328
RE: UPDATE Duplicates Except for One Record in a Table

Sergiy - Thursday, June 1, 2017 11:22 PM
donato1026 - Tuesday, May 30, 2017 1:11 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)

June 4, 2017 at 9:29 pm

#1945327
RE: Help with query

Now that there are multiple solutions for this problem, I have to ask, if the "current" start date will be replaced with the previous end date, why is there any...
--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)

June 4, 2017 at 9:22 pm

#1945326
RE: Devide ' n' Conquer techniques in t-sql query writing

By the same token, a lot of people think that "set-based" means "all in one query". While set-based code frequently does result in a single query, it's not always 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)

June 4, 2017 at 8:49 pm

#1945325
RE: Things to consider while creating new table for an application

Jackson89 - Sunday, June 4, 2017 4:21 PM
Jeff Moden - Sunday, June 4, 2017 1:15 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)

June 4, 2017 at 7:03 pm

#1945323

Viewing 15 posts - 14,926 through 14,940 (of 59,097 total)