Jeff Moden

Forum Replies Created

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

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
RE: Use uniqueidentifier field in place of int

Lynn Pettis - Tuesday, April 3, 2018 5:32 PM
Want my guess. In the source table the EnrollmentRecordID is a uniqueidentifier. In 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 3, 2018 at 6:49 pm

#1985393
RE: Use uniqueidentifier field in place of int

daniness - Tuesday, April 3, 2018 12:08 PM
In brief, the reason I was trying to do this is to pull from 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 3, 2018 at 5:15 pm

#1985389
RE: How to retrieve all the data group types at the same time in sql server?

below86 - Monday, April 2, 2018 1:01 PM
Jeff, If you have a better solution please include it. I would really like to...
--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 2, 2018 at 1:12 pm

#1985219
RE: imsage test

Seems to work well on both a direct click and opening in a new tab with a right click. How was the image placed on the page? Copy'n'paste or "drag"?
--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)

March 31, 2018 at 9:17 am

#1985143
RE: SELECTing a hierachy

george-178499 - Friday, March 30, 2018 9:42 PM
How is the link established between School 3 and District 1. Do you have 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)

March 31, 2018 at 8:54 am

#1985142
RE: SSRS - "Virus/Spyware Download Blocked"

I'd have to say that the software on all fronts is doing precisely what it was designed to do. I also don't believe there will be anything that you can...
--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)

March 31, 2018 at 8:42 am

#1985141
RE: Temporal Tables - Delete Conflict

Mike Hotek - Friday, March 30, 2018 2:04 PM
Well, I'm trying to figure out a way around another massive hole in 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)

March 31, 2018 at 8:36 am

#1985140

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