Jeff Moden

Forum Replies Created

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

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
RE: It's all about Customer Service

My policy is simple. Prove the ROI, maintainability, safety, security, and long term cost of ownership of the new method along with an explanation as to why it can't be done...
--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 7:36 pm

#1939860
RE: SQL 2008 R2 varChar(Max) field not storing all data.. cutting off.

spitfire677 - Tuesday, April 25, 2017 3:55 PM
I recently moved my database from an older version of MS SQL Express to MS...
--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 7:17 pm

#1939859
RE: How to take database backup between 2 dates (database partitioning)?

saklanivijay87 - Monday, April 24, 2017 10:35 PM
2-3 tables.
Then it is possible and maybe relatively "easy" to do what you want 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 25, 2017 at 8:05 am

#1939757
RE: How to take database backup between 2 dates (database partitioning)?

saklanivijay87 - Monday, April 24, 2017 5:23 AM
I am working on desktop application using .net framework and sql server as database. It...
--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 24, 2017 at 8:37 am

#1939554

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