Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,106 through 15,120 (of 59,101 total)

RE: SSIS ForEach Column loop

I can't help thinking that someone needs to fix the design of this whole thing but, if you absolutely need it, please see the following article for how to do...
--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)

April 29, 2017 at 4:09 pm

#1940496
RE: Find and Replace a value across all tables in database

With absolutely no disrespect to the author, I cringe a bit when I see things like this. It generally means that the database wasn't properly designed to begin with. 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)

April 29, 2017 at 4:03 pm

#1940495
RE: Are the posted questions getting worse?

Luis Cazares - Friday, April 28, 2017 11:55 AM
<rant>
Have you ever encountered a situation where your company defines certain authorized software and...
--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)

April 28, 2017 at 8:48 pm

#1940467
RE: Questions for me to ask during a job interview

On a more serious note than my previous post, I'd likely ask the following questions as well as some of those already posted.
1. What kind of 3rd party...
--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)

April 28, 2017 at 8:33 pm

#1940464
RE: Questions for me to ask during a job interview

Heh... you forgot the most important question of them all.
Why might a Reuleaux triangle be a better shape for a manhole cover than a circle and how does...
--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)

April 28, 2017 at 11:16 am

#1940412
RE: SQL Query Running Count

ChrisM@home - Friday, April 28, 2017 10:22 AM
lhynlen - Friday, April 28, 2017 8:35 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)

April 28, 2017 at 11:11 am

#1940411
RE: Script to restore production database to test server

sqlfriends - Thursday, April 27, 2017 10:34 AM
Jeff Moden - Thursday, April 27, 2017 7:50 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)

April 27, 2017 at 3:36 pm

#1940320
RE: How to manage temporary tables

hurricaneDBA - Thursday, April 27, 2017 1:58 PM
You know I remember that the application support guy is running reorganization and index maintenance...
--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)

April 27, 2017 at 3:10 pm

#1940318
RE: How to manage temporary tables

Hold the phone... the problem the OP is talking about is with TempDB. That pretty much has nothing to do with the query he posted except if you look at...
--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)

April 27, 2017 at 8:03 am

#1940209
RE: Script to restore production database to test server

sqlfriends - Wednesday, April 26, 2017 3:46 PM
Is there a simple and clean script that can copy a full backup of 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)

April 27, 2017 at 7:50 am

#1940205
RE: Query Performance Standards - Overall Per DB

Heh.... dollars to donuts, it's going to turn out to be an ORM whammy that takes a tiny time to execute, has a 2 to 29 second compile time, and...
--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)

April 26, 2017 at 9:38 pm

#1940137
RE: Nuance of datetime data type in SQL Server

GeorgeCopeland - Thursday, April 13, 2017 1:54 PM
Thinking like this has caused more bugs over the last 70 years than the NULL....
--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)

April 25, 2017 at 10:16 pm

#1939867
RE: Deadlock with two update statements

What is the cardinality of the RecordLocator column?
I ask because you're talking to the guy that brought Expedia.com to its knees for a couple of minutes by adding...
--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)

April 25, 2017 at 9:57 pm

#1939865
RE: Proactive vs Reactive

GeorgeCopeland - Tuesday, April 25, 2017 12:54 PM
Skimping on database admin is a business mistake. Why do people make business mistakes? 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)

April 25, 2017 at 8:44 pm

#1939863
RE: Proactive vs Reactive

Alex-489474 - Tuesday, April 25, 2017 2:14 AM
First off many people believe that SQL Server is self-administering
No, my complaint...
--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)

April 25, 2017 at 8:12 pm

#1939862

Viewing 15 posts - 15,106 through 15,120 (of 59,101 total)