Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,661 through 15,675 (of 59,101 total)

RE: Migrating 300+ databases. Need a script to transfer user permissions for all the users across all the databases

Eirikur Eiriksson - Sunday, February 12, 2017 4:31 PM
Ed Wagner - Sunday, February 12, 2017 2:40 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)

February 12, 2017 at 6:29 pm

#1928029
RE: Mixed page allocation

According to the official MS documentation you cited, you are incorrect. Here's the blurb from the first reference you cited...
"This setting is ON for all system databases. tempdbtempdb...
--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)

February 12, 2017 at 6:11 pm

#1928028
RE: Is having a lookup table that is for multiple entities a common practice?

Also consider and test for the data integrity problems that Gail spoke of. She's absolutely correct there. From what your boss sounds like, though, he'd shrug that off and insist...
--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)

February 12, 2017 at 5:24 pm

#1928025
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

Luis Cazares - Friday, February 10, 2017 12:27 PM
Something baffles me. You're using 70GB of data between data and indexes.
Why is...
--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)

February 12, 2017 at 11:01 am

#1928003
RE: Are the posted questions getting worse?

Hugo Kornelis - Sunday, February 12, 2017 3:41 AM
Jeff Moden - Saturday, February 11, 2017 5:17 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)

February 12, 2017 at 10:54 am

#1928002
RE: Keeping Fact Tables Online while Loading via Partition Switching

shubhankarthatte - Saturday, February 11, 2017 10:19 PM
Jeff Moden - Thursday, January 19, 2017 5:01 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)

February 12, 2017 at 10:42 am

#1927999
RE: What is perfect way to declare variable data type in asp.net to match SQL data type?

Understood but if you don't know that you shouldn't pass a "DOUBLE Word" to a "TinyInt", you're in deep Kimchi. 😉
--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)

February 12, 2017 at 10:33 am

#1927997
RE: SQL Server DBA training.

Just to further support my position on having an in-depth knowledge of "SQL" (T-SQL in our world) regardless of what you decide to specialize on, please see the following article...
--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)

February 12, 2017 at 10:31 am

#1927996
RE: Remove partitioning

As a bit of a sidebar, how much of the data is subject to change? Does the data in the table become totally static after some period of time? If...
--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)

February 12, 2017 at 10:27 am

#1927995
RE: Remove partitioning

Indianrock - Saturday, February 11, 2017 5:49 PM
Thanks for the link. I'll dig into it ( scanned it last week ).
I understood...
--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)

February 12, 2017 at 9:59 am

#1927994
RE: Is having a lookup table that is for multiple entities a common practice?

Doctor Who 2 - Saturday, February 11, 2017 6:54 PM
Jeff Moden - Thursday, February 9, 2017 9:41...
--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)

February 12, 2017 at 9:48 am

#1927993
RE: Are the posted questions getting worse?

Sean Lange - Friday, February 10, 2017 1:16 PM
For that matter I am shocked at how many people are still creating...
--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)

February 11, 2017 at 5:21 pm

#1927968
RE: Are the posted questions getting worse?

Michael L John - Friday, February 10, 2017 5:14 PM
With virtualized servers, less than 200 GB is not uncommon. We tend 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)

February 11, 2017 at 5:17 pm

#1927967
RE: What is perfect way to declare variable data type in asp.net to match SQL data type?

I don't know enough about asp.net to tell you off the top of my head but the following search seems useful.
https://www.google.com/?gws_rd=ssl#q=match+asp.net+variables+to+sql+server+data+types
--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)

February 11, 2017 at 5:11 pm

#1927966
RE: Remove partitioning

At a high level, all of the partitions must be merged to a single partition. All tables are "partitioned" in that they have a single partition.
I've not...
--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)

February 11, 2017 at 5:06 pm

#1927965

Viewing 15 posts - 15,661 through 15,675 (of 59,101 total)