Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,916 through 15,930 (of 59,101 total)

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
RE: Query is slow in production but fast in QA

Robin35 - Friday, January 13, 2017 10:32 AM
Hello,
I have Select query that runs slow in production but fast in QA. I know there...
--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 12:58 pm

#1922679
RE: TempDB on RAM Drive ?

sqld-_-ba - Friday, January 13, 2017 8:41 AM
@jeff - I did a stress test of the vendor code on SAN and RAM Disk,...
--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 12:19 pm

#1922667
RE: Data migration approach

sqlenthu 89358 - Thursday, January 5, 2017 5:01 AM
Thanks Grant for giving me direction. I'll check it out. One more thing. The text...
--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 8:29 am

#1922581
RE: TempDB on RAM Drive ?

sqld-_-ba - Thursday, January 12, 2017 8:49 PM
Our vendor application database is very tempdb intensive. TempDB (and all databases) are on Tier...
--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 12, 2017 at 11:24 pm

#1922470
RE: SSC Forum Updates

I've been having some issues posting code. In the past, I'd drop the correct IFCode on the post, copy and paste from SSMS into the IFCode and done. Now it...
--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 12, 2017 at 5:28 pm

#1922458
RE: SSC Forum Updates

Dave Convery - Thursday, January 12, 2017 9:10 AM
Jeff Moden - Thursday, January 12, 2017 9:05 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)

January 12, 2017 at 5:24 pm

#1922457
RE: Should we keep Comic Sans in the formatting options?

Eric M Russell - Thursday, January 12, 2017 11:55 AM
Dave Convery - Thursday, January 12, 2017 4:07 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)

January 12, 2017 at 4:27 pm

#1922449

Viewing 15 posts - 15,916 through 15,930 (of 59,101 total)