Jeff Moden

Forum Replies Created

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

RE: Finding the database

MS has many system stored procedures that us it so you can pass in 'somenondboschemaname.sometablename'. For example, sp_rename uses it and you can pass in up to a 4 part...
--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 5:12 pm

#2015808
RE: Perfmon

I didn't select any of the answers because I save my perfmon settings and reference them in the ICON that I have setup on the desktop. If I want 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 10:45 am

#2015790
RE: Logical Drives on a Solid State Platter

rchantler - Friday, December 7, 2018 7:47 AM
In the olden days we meticulously separated the system files from data files from log...
--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 10:36 am

#2015789
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

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