Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,426 through 10,440 (of 59,099 total)

RE: delete records in batches?? and recursive for tables

pietlinden - Thursday, December 6, 2018 9:19 PM
The whole point of doing the delete in batches is that it doesn't increase 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)

December 7, 2018 at 7:02 am

#2015749
RE: Lax Security is Harmful for Employment

Eric M Russell - Thursday, December 6, 2018 3:39 PM
Some economists have asserted that mortgage robo-signing was partially to blame for...
--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)

December 6, 2018 at 7:59 pm

#2015720
RE: Lax Security is Harmful for Employment

Eric M Russell - Thursday, December 6, 2018 1:15 PM
It's hard to separate the sarcasm from truth in this Onion story. :unsure:
--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)

December 6, 2018 at 3:34 pm

#2015710
RE: MoSQL

Lynn Pettis - Thursday, December 6, 2018 9:08 AM
Comes down to using the right tool for the job.
Heh... so different size hammers....
--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)

December 6, 2018 at 3:26 pm

#2015709
RE: Restoring with multiple BAK-files (with multiple CPU-cores)

gkramer 23701 - Thursday, December 6, 2018 8:17 AM
Enterprise edition
In that case, if you're not using compression, you should give it 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)

December 6, 2018 at 3:21 pm

#2015708
RE: blocking for same query on user DB

Let's stop guessing... what is the query? What is the actual execution plan. Please see the second link in my signature line below for what we need to be able...
--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)

December 6, 2018 at 9:11 am

#2015683
RE: delete records in batches?? and recursive for tables

s.ravisankar - Thursday, December 6, 2018 8:12 AM
I have number of tables , I want to purge record based 3 month timeline.
eg:
select...
--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)

December 6, 2018 at 8:38 am

#2015675
RE: Pivot multiple columns into one row

Uji2 - Thursday, December 6, 2018 8:29 AM
Is there a way to do this in one statement without writing dynamic sql?
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)

December 6, 2018 at 8:33 am

#2015671
RE: MoSQL

Heh.... to play a bit on the quote in my signature line (which is also a play on words)...
Them (whoever they are): "Yeah Jeff? Well, to a hammer,...
--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)

December 6, 2018 at 8:25 am

#2015666
RE: Restoring with multiple BAK-files (with multiple CPU-cores)

Do you have the Standard or Enterprise edition of SQL Server?
Also, spitting the backups to multiple files could actually slow things down unless you can guarantee that each...
--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)

December 6, 2018 at 8:14 am

#2015663
RE: Where clause on a bit column

tmmutsetse - Thursday, December 6, 2018 7:23 AM
Hi Experts,
I want results based on a where clause , all columns in the where...
--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)

December 6, 2018 at 7:59 am

#2015662
RE: TempDB previous usage

I find that if it's actually to be found in the default trace, you got damned lucky. Most default traces get full and rollover very quickly on busy systems.
--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)

December 6, 2018 at 7:51 am

#2015660
RE: Practical Uses for Synonyms in SQL Server

Alan G-436699 - Friday, July 1, 2016 1:44 PM
I've recently discovered a great use of synonyms. My company won't refresh UAT from...
--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)

December 6, 2018 at 6:58 am

#2015650
RE: adding each row incremental

Ah... just can't do it... there are a few things wrong with that site including their statement of "you agree to license everything you submit by
--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)

December 5, 2018 at 6:38 pm

#2015620

RE: Lack of clustered index generally a good idea?

Scott Coleman - Friday, November 30, 2018 2:42 PM
it is just too darn difficult to choose a good clustering key. As 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)

December 5, 2018 at 6:26 pm

#2015619

Viewing 15 posts - 10,426 through 10,440 (of 59,099 total)
Prev
1
2
3
…
695
696
697
…
3,938
3,939
3,940
Next