Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,616 through 12,630 (of 59,102 total)

RE: Replica of Store Procedure taking more time

anoop.mehra - Wednesday, April 4, 2018 11:24 PM
Hi All,
I have optimized one store procedure. Original is taking 35 seconds to take data...
--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 5, 2018 at 8:30 am

#1985680
RE: Is the DBA Title Dying?

roger.plowman - Thursday, April 5, 2018 7:18 AM
Jeff Moden - Thursday, April 5, 2018 6:58 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 5, 2018 at 8:26 am

#1985678
RE: Is the DBA Title Dying?

I actually wouldn't want the server to do a whole lot of stuff auto-magically. Humans would have to write the code to get it to do all that and 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 5, 2018 at 6:58 am

#1985651
RE: Purge database

Lidou123 - Thursday, April 5, 2018 5:33 AM
Hello everyone
I want to give you news of my project.
I was able to set up as...
--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 5, 2018 at 6:56 am

#1985650
RE: Issue with using Ola Hallengren Backup script

Ola Hallengren - Tuesday, April 3, 2018 7:38 AM
I have released a new version of the script with support for striping of...
--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 5, 2018 at 6:35 am

#1985640
RE: Exercise to practise SQL

svrtechnologies.com - Wednesday, April 4, 2018 10:51 PM
Hi,
Can you please give us the name , author, ISBN of 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)

April 5, 2018 at 6:01 am

#1985621
RE: imsage test

You might want to try just a copy'n'paste and see if you get the same good results. In the recent past, doing such a thing would certain paste to 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)

April 4, 2018 at 3:55 pm

#1985565
RE: Deleting old records isn't freeing up space?

RVSC48 - Wednesday, April 4, 2018 2:37 PM
You won't see the available space after deleting data until a shrink occurs. Most experts agree,...
--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 4, 2018 at 3:52 pm

#1985564
RE: taking very long time to execute

saptek9 - Wednesday, April 4, 2018 1:58 PM
I have a table with following stats:
443114382 rows,
reserved 45511728 kb,
680616 kb index size...
--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 4, 2018 at 2:33 pm

#1985559
RE: Shrunk Database

mlorek - Wednesday, April 4, 2018 12:57 PM
Ok thanks all for the responses. I will rebuild all the indexes at this 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)

April 4, 2018 at 2:22 pm

#1985558
RE: Is the DBA Title Dying?

ZZartin - Wednesday, April 4, 2018 1:42 PM
I don't think the title is dying, however I would say that there are becoming...
--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 4, 2018 at 2:17 pm

#1985557
RE: Automatically Create indexes as needed

steve 96379 - Wednesday, April 4, 2018 8:18 AM
Good points. I had posted the script to help out and your comments are...
--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 4, 2018 at 8:59 am

#1985474
RE: Quick and Dirty DR Solution Using Robocopy

Eric M Russell - Thursday, December 14, 2017 12:12 PM
A few months back, I was migrating about 4 TB of databases 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)

April 4, 2018 at 8:06 am

#1985458
RE: Automatically Create indexes as needed

steve 96379 - Wednesday, April 4, 2018 7:07 AM
This has been designed to specifically ensure that duplicate indexes never occur if you actually...
--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 4, 2018 at 8:00 am

#1985457
RE: The SQL Joke Thread

I just heard a great joke and Luis is intimately familiar with it.
Let's get rid of all stored procedures and move everything to the cloud. 😀
--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 3, 2018 at 7:43 pm

#1985395

Viewing 15 posts - 12,616 through 12,630 (of 59,102 total)