Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,871 through 15,885 (of 59,063 total)

RE: Powershell Script for regular DBA activities

Such utilities can be easily used by the developers in the team without making them approach to DBA for such tasks on various development or testing environments.
Who fixes...
--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)

January 14, 2017 at 10:36 pm

#1922781
RE: Upgrade Architecture Mismatch

mceventphoto - Saturday, January 14, 2017 7:28 PM
I am trying to upgrade SQL Server 2012 Developers Edition (32 Bit) to SQL Server 2012 Standard...
--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)

January 14, 2017 at 10:02 pm

#1922780
RE: DBAs Need to Learn to Develop

TomThomson - Saturday, January 14, 2017 6:58 PM
Jeff Moden - Tuesday, December 13, 2016 7:53 AM
On...
--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)

January 14, 2017 at 9:47 pm

#1922779
RE: Sum of Rows per a unique id

The comments in the code below explain how this can be done. Also, see the first link under "Helpful Links" in my signature line for how to post to get...
--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)

January 14, 2017 at 9:06 pm

#1922778
RE: Writing the Correct Query is Important

Considering recent events, I think it terribly ironic that you published this particular article at this particular time.
--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)

January 14, 2017 at 8:23 pm

#1922777
RE: are there dark themes available?

BWAAA-HAAAA!!!! Insane for having a white background? I depend on the White background to provide enough light so that I can find my pizza at night! 😉
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)

January 14, 2017 at 6:28 pm

#1922770
RE: Table Space Related Question

KGJ-Dev - Friday, January 13, 2017 1:11 PM
00000
Hi Jeff,
Thank you for your time on this post and could you please elaborate your...
--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)

January 14, 2017 at 3:02 pm

#1922761
RE: Table Space Related Question

KGJ-Dev - Friday, January 13, 2017 10:37 AM
Hi,
I have a table with 100 * 1000 rows now and this will grow by 10k...
--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)

January 14, 2017 at 1:24 pm

#1922757
RE: what user membership to assign?

A better thing to do, in many cases, is to use Windows Active Directory Groups. Then, you only need to assign the group privs once in SQL Server since 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)

January 14, 2017 at 1:21 pm

#1922756
RE: Table Space Related Question

Grant Fritchey - Saturday, January 14, 2017 9:19 AM
KGJ-Dev - Friday, January 13, 2017 8:28 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)

January 14, 2017 at 1:04 pm

#1922754
RE: FAQ: Using the new forum Software (Jan 2017)

This thread is a really good idea. A really good FAQ would be how to post code that preserves indentation and avoids overly large line spacing.
And, yeah... feel...
--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)

January 13, 2017 at 7:58 pm

#1922723
RE: Query is slow in production but fast in QA

Apparently the spaminator ate my last post. If you want to read more about Trace Flag 1118, please see the following link (trying again)...http://www.sqlskills.com/blogs/paul/misconceptions-around-tf-1118/
--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)

January 13, 2017 at 4:31 pm

#1922719
RE: Table Space Related Question

Just in case you need authoritative justification to do so for TF 1118, please see the following link...
http://www.sqlskills.com/blogs/paul/misconceptions-around-tf-1118/
--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)

January 13, 2017 at 2:57 pm

#1922714
RE: Query is slow in production but fast in QA

On your end, is TempDB configured the same on both machines? Also, do you have Trace Flag 1118 turned on at startup? If not, you need to do that. I've...
--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)

January 13, 2017 at 2:08 pm

#1922701
RE: Table Space Related Question

If the deletes don't clear entire pages, then the pages will remain regardless of how sparsely populated they may be and, yes, that can hurt performance.
--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)

January 13, 2017 at 1:00 pm

#1922681

Viewing 15 posts - 15,871 through 15,885 (of 59,063 total)