Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,236 through 17,250 (of 59,102 total)

RE: Correct MAXDOP setting

TheSQLGuru (7/19/2016)
Jeff Moden (7/19/2016)
smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend...
--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)

July 19, 2016 at 8:09 pm

#1890988
RE: Correct MAXDOP setting

smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some time fixing...
--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)

July 19, 2016 at 7:46 pm

#1890983
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

CELKO (7/19/2016)
Maybe I missed the question, but SQL/PSM is how the ANSI/ISO standards handle procedures and functions. Also triggers, God help us.
As an aside, the "parameter versus argument"...
--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)

July 19, 2016 at 7:36 pm

#1890981
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

Never mind. Post removed.
--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)

July 19, 2016 at 7:19 pm

#1890978
RE: how to set NULLs to Zero

ocean3300 (7/19/2016)
If you want to display sum(omlExtendedPriceBase) as 0 if the value is null, use ISNULL(SUM(omlExtendedPriceBase),0).
That's one of the many reasons why I don't use PIVOT. A good ol'...
--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)

July 19, 2016 at 6:59 pm

#1890977
RE: Creating a DBA Oncall list to email to group.

randy.moodispaugh (7/19/2016)
I want to automate this information to be emailed to a group, to allow for DBA's to swap Schedules. Just looking for some ideas for creating this...
--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)

July 19, 2016 at 3:12 pm

#1890965
RE: Restore wait for ASYNC_IO_COMPLETE unending

markoos1 (7/19/2016)
This could also be from lack of instant file initialization. http://mattslocumsql.blogspot.com/2014/02/why-are-my-database-restores-so-slow.html
A similar problem, which "Instant File Initialization" provides no help for is the number of VLFs contained in...
--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)

July 19, 2016 at 3:09 pm

#1890964
RE: Exporting Database tables to Text at the same time

gjuarez (7/19/2016)
Thank you for the answers posted. I am a bit new on scripting Cursors so i was wondering how to use a character for field terminator instead of 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)

July 19, 2016 at 3:04 pm

#1890963
RE: Identical Query, Different Execution Stats

And stats. Small change in stats can make for wildly different executions.
--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)

July 19, 2016 at 12:43 pm

#1890937
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

John Mitchell-245523 (7/19/2016)
Have a look at this page. In particular:
RESTORE is not allowed in an explicit or implicit transaction.
By the way, I don't think you need to switch back...
--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)

July 19, 2016 at 12:41 pm

#1890936
RE: Exporting Database tables to Text at the same time

pietlinden (7/18/2016)
Is this close?
-- create a cursor to loop over this result set
/* create a cursor to loop through each table... */
DECLARE @CmdLine AS NVARCHAR(200);
DECLARE @CmdCursor AS CURSOR;
SET @CmdCursor =...
--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)

July 19, 2016 at 12:10 am

#1890765
RE: Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL

Marcia J (6/25/2014)
What are some real-life examples of using the While statement that don't involve RBAR code?
Creating dynamic SQL for backups.
The "Bin Fill" and "Load Balancing" problems are classic problems...
--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)

July 18, 2016 at 9:29 pm

#1890754
RE: Exporting Database tables to Text at the same time

If it were me, I'd write a loop to step through the tables to create a BCP command that did a SELECT * from each table and then use xp_CmdShell...
--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)

July 18, 2016 at 9:27 pm

#1890753
RE: Execution plan differences in QA and Prod

TheSQLGuru (7/15/2016)
SQLBuzz (7/15/2016)
Strange ...I was just looking into the setting and i had found these
LogicalCPUs on Prod is 32
LogicalCPUs on Dev is 40
MAX DOP Setting 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)

July 18, 2016 at 9:17 pm

#1890751
RE: Users and Passwd after Failover.

This is why you shouldn't install SQL Server on local hard drives like the C: drive.
--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)

July 18, 2016 at 8:52 pm

#1890750

Viewing 15 posts - 17,236 through 17,250 (of 59,102 total)