Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,141 through 19,155 (of 59,072 total)

RE: running sql profiler

GilaMonster (11/4/2015)
Jeff Moden (11/4/2015)
ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?
Depending on where you run it from and how you run it
Profiler can fill up 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)

November 17, 2015 at 8:11 pm

#1840519
RE: Best practices - Linked server naming convention

sqld-_-ba (11/6/2015)
- developers should not have to modify code when deploying between environments DEV->TEST->PROD. This rules out using actual server name as linked-name.
- the name should easily identify actual server...
--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)

November 17, 2015 at 7:58 pm

#1840518
RE: Index Build Space Calculation

p.s. Allocating another 50-100GB to the app is going to be a whole lot cheaper than you having to mess around all the time whenever you defragment the tables.
--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)

November 17, 2015 at 7:52 pm

#1840517
RE: Index Build Space Calculation

have2much (11/9/2015)
If possible
- switch recovery model of the database to simple before starting rebuild and switch to full once done ?
- Partitioning may also help where you do have...
--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)

November 17, 2015 at 7:47 pm

#1840516
RE: Table Paritioning

Welsh Corgi (11/9/2015)
Jeff Moden (11/9/2015)
Welsh Corgi (11/9/2015)
I have written a Stored Procedure to Archive Tables.
I have been asked to Partition the tables.
Would I be better off to hold off 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)

November 17, 2015 at 7:34 pm

#1840515
RE: Rebuilding large index with limited free space

ricardo_chicas (11/9/2015)
Thanks
I will do something similar, add a new file group and move those tables over there
What is the table used for? For example, is it an audit or...
--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)

November 17, 2015 at 7:17 pm

#1840514
RE: Querying Oracle via Linked Server crashes SQL Server

Gordon Feeney (11/17/2015)
Was just about to raise a call with MS support when I came across a possible solution on their support site. I tested the fix and it works....
--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)

November 17, 2015 at 7:11 pm

#1840513
RE: SSIS - CSV Row being dropped

Disclaimer: I am NOT an SSIS user. I do this type of stuff using T-SQL and I'm not even sure that I know how to even spell "SSIS"....
--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)

November 17, 2015 at 7:02 pm

#1840512
RE: Key Value Pair Table

yb751 (11/11/2015)
Well I just finished talking with our Dev team and I realized that the attributes do not need to be updated individually. Also any searches would be offloaded...
--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)

November 17, 2015 at 6:25 pm

#1840510
RE: Question for All DBAs (What can I learn to enahnce my career?)

MadAdmin (11/10/2015)
Favorite Quotes:
"Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014
Yes.
Because the DB was then able to successfully...
--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)

November 17, 2015 at 5:32 pm

#1840508
RE: SQL Credentials password reset

If it's an AD account, you shouldn't have to do anything with "SQL Credentials" that already exist. If by "SQL Credentials", you mean an SQL Login rather than 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)

November 17, 2015 at 5:29 pm

#1840506
RE: Adding ndf files to tempdb and shrinking the mdf

S_Kumar_S (11/17/2015)
Hi
I have a tempdb with 130 GB mdf and 6 GB ldf file size. Now because of PAGEIOLATCH_XX wait types, I have to a make the number of...
--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)

November 17, 2015 at 5:23 pm

#1840505
RE: Performance impact of self-referencing Linked Server

keymoo (11/17/2015)
I am going through a consolidation exercise where I want to put databases from one instance into another existing instance. Currently the instances are on separate hardware.
So SERVER1\INSTANCE_A has...
--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)

November 17, 2015 at 5:19 pm

#1840504
RE: A Case FOR Cursors...

Hugo Kornelis (11/17/2015)
I have never found or seen a method for computing running (pre SQL Server 2012) that has comparable performance to a well-programmed cursor solution, except for the methods...
--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)

November 17, 2015 at 4:39 pm

#1840502
RE: Are the posted questions getting worse?

Lynn Pettis (11/17/2015)
OMG
Unfortunately, WTC (Way Too Common). Gail has got to be getting tired of suppressing a literal "Dear Stupid" response.
--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)

November 17, 2015 at 4:34 pm

#1840501

Viewing 15 posts - 19,141 through 19,155 (of 59,072 total)