Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,206 through 17,220 (of 59,067 total)

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
RE: Exporting Database tables to Text at the same time

Do the tables all have the same columns?
--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:48 pm

#1890749
RE: Odd! Objects Shown Up in Master after DB Restoration

Lynn Pettis (7/18/2016)
Michelle-138172 (7/18/2016)
I created a script to restore multiple databases in one shot. What's weird is, I often see objects from the dbs being restored show up in Master....
--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:35 pm

#1890748
RE: Recursive CTE Alternative

Hi Scott,
A properly formed rCTE will traverse a well formed million node hierarchy in less than a minute on most machines. If it doesn't, with the code is incorrect...
--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 7:14 pm

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

lsalih (7/18/2016)
Jeff -
I am placing it in a package for others to use, not for my own use. Some prefer to run a package than running the script. That 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)

July 18, 2016 at 4:59 pm

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

CELKO (7/18/2016)
You can get a full or near full implementation of the PSM in DB2, PostgreSQL, MySQL, Mimer and a few other products.
The SQL/PSM was primarily written by 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 18, 2016 at 4:56 pm

#1890739

Viewing 15 posts - 17,206 through 17,220 (of 59,067 total)