Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,416 through 14,430 (of 59,097 total)

RE: Index Seek not possible if you want every row of table, correct?

Arsh - Wednesday, September 6, 2017 7:28 AM
Please if this helps too.
https://www.youtube.com/watch?v=GSZPvF2u6WY
Good link, Arsh. Thanks.
--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)

September 6, 2017 at 8:17 am

#1958369
RE: Are the posted questions getting worse?

TomThomson - Tuesday, September 5, 2017 1:30 PM
Jeff Moden - Sunday, September 3, 2017 5:37 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)

September 6, 2017 at 7:31 am

#1958350
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, September 6, 2017 6:04 AM
So... I'm not going to be around as much as usual over the next...
--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)

September 6, 2017 at 7:23 am

#1958346
RE: 70-461... free practice tests/labs, etc that aren't total garbage

scarr030 - Monday, February 13, 2017 2:36 PM
Hi All,
I'm fairly new to SQL. 0 IT experience before a year ago, and now...
--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)

September 5, 2017 at 10:59 pm

#1958262
RE: To automatically change the value of a column if a particular date time is reached

poornima.s_pdi - Tuesday, September 5, 2017 9:10 PM
Hi Joe Celko,
Thanks for your reply.
You said the following,
Not only is your design fundamentally wrong,...
--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)

September 5, 2017 at 10:34 pm

#1958260
RE: Database Development Made Easy?

miapjp - Tuesday, September 5, 2017 8:08 AM
Jeff Moden - Saturday, September 2, 2017 12:01 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)

September 5, 2017 at 10:29 pm

#1958258
RE: Determine Monday of next month and Monday of next week

jcobb 20350 - Tuesday, September 5, 2017 2:20 PM
Ok, so let's throw this out the window and get to the real point...
--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)

September 5, 2017 at 10:18 pm

#1958257
RE: Determine Monday of next month and Monday of next week

Lynn Pettis - Tuesday, September 5, 2017 3:51 PM
Jeff Moden - Tuesday, September 5, 2017 2:52 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)

September 5, 2017 at 10:05 pm

#1958256
RE: Stalled Query?

alex.sqldba - Tuesday, September 5, 2017 2:24 PM
Evening Guys,
I am making a change to a table that contains NTEXT and an NVARCHAR(4000)....
--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)

September 5, 2017 at 10:03 pm

#1958254
RE: Scaling up on a virtual machine

agerard 65681 - Tuesday, September 5, 2017 1:59 PM
Thanks Jo
We have gone past the usefulness of the MaxQueueThreads setting. It's currently set...
--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)

September 5, 2017 at 10:00 pm

#1958253
RE: Index Seek not possible if you want every row of table, correct?

Maxer - Tuesday, September 5, 2017 8:28 AM
I have a table, it has a clustered index on customer_ID.
I need to return every...
--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)

September 5, 2017 at 9:43 pm

#1958252
RE: Slow queries during busy times

TheSQLGuru - Tuesday, September 5, 2017 6:02 AM
Jeff Moden - Monday, September 4, 2017 9:27 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)

September 5, 2017 at 9:15 pm

#1958251
RE: What is your definition of a DBA?

Avi1 - Tuesday, September 5, 2017 2:11 PM
In small organization of course one resource may have to do all the tasks related...
--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)

September 5, 2017 at 3:10 pm

#1958218
RE: How to handle business hour loads?

Chris Harshman - Tuesday, September 5, 2017 2:03 PM
Using either the ALTER SCHEMA TRANSFER or SYNONYM methods, blocking would occur if someone...
--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)

September 5, 2017 at 3:03 pm

#1958216
RE: Determine Monday of next month and Monday of next week

Lynn Pettis - Tuesday, September 5, 2017 2:19 PM
Jeff Moden - Monday, September 4, 2017 6:30 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)

September 5, 2017 at 2:55 pm

#1958210

Viewing 15 posts - 14,416 through 14,430 (of 59,097 total)