Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,151 through 12,165 (of 59,095 total)

RE: xp_fileexist undocumented store procedure

I'm at work and don't have the time to test right now nor the code that I used previously but you don't actually need a certificate for this type 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)

June 8, 2018 at 11:32 am

#1993425
RE: xp_fileexist undocumented store procedure

Lynn Pettis - Friday, June 8, 2018 10:53 AM
jasona.work - Friday, June 8, 2018 10:14 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)

June 8, 2018 at 11:00 am

#1993420
RE: xp_fileexist undocumented store procedure

Crud. Sorry Lynn... I got busy last night and forgot.
--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)

June 8, 2018 at 10:45 am

#1993417
RE: Using HTML files as resources in SSRS no longer works after SP2

I'd still call MS.
--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)

June 8, 2018 at 8:54 am

#1993387
RE: CPU Pegged at 100%

dropsa999 - Friday, June 8, 2018 4:15 AM
Hello,
We are planning to move from SQL 2012 to 2017 for the "Perfomance Improvement", on our...
--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)

June 8, 2018 at 8:31 am

#1993380
RE: Using HTML files as resources in SSRS no longer works after SP2

I guess I'd hum a rock at MS and see what they have to say.
--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)

June 8, 2018 at 8:26 am

#1993379
RE: Get Index Fragmentation Cheaply

I don't know if cutting down on the number of joined tables will help but it can't hurt. Here's an example of what I use pared down to what you...
--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)

June 7, 2018 at 6:22 pm

#1993318
RE: High lazywrites - what other counters to look for

I think people spend way too much time looking at counters. Right click on the instance in the Explorer Window, click on reports, and follow your nose for the real...
--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)

June 7, 2018 at 5:00 pm

#1993316
RE: update table: PK or unique idx?

sgmunson - Thursday, June 7, 2018 9:02 AM
Perhaps even more specifically, why would an update of a single row be 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)

June 7, 2018 at 9:10 am

#1993241
RE: xp_create_subdir for non-sysadmins

And DO understand the security ramifications of using SET TRUSTWORTHY ON. It may not be a problem or... it may. "It Depends" but you won't know until you read about...
--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)

June 7, 2018 at 8:26 am

#1993227
RE: Regulary delete and rebuild of table influences perfomance?

ktflash - Thursday, June 7, 2018 5:56 AM
Not on a regular basis, i had to recreate it for different testing reasons. 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)

June 7, 2018 at 8:22 am

#1993225
RE: detect if previous record is higher or lower ?

Eirikur Eiriksson - Wednesday, June 6, 2018 6:56 AM
Jeff Moden - Wednesday, June 6, 2018 6:17 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)

June 7, 2018 at 6:50 am

#1993203
RE: Regulary delete and rebuild of table influences perfomance?

ktflash - Wednesday, June 6, 2018 2:27 AM
Not sure if you just wanted the results itself or a execution plan again so...
--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)

June 6, 2018 at 12:00 pm

#1993134
RE: The SQL Saturday Thread

timwell - Wednesday, June 6, 2018 8:59 AM
Hello Jeff, Is anything happening with the Detroit PASS group? I attended a couple...
--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)

June 6, 2018 at 11:19 am

#1993126
RE: detect if previous record is higher or lower ?

The only problem with using date in such a fashion is that it must be certain and continuous without any gaps or duplication. Of course, there are rabbit holes for...
--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)

June 6, 2018 at 6:17 am

#1993071

Viewing 15 posts - 12,151 through 12,165 (of 59,095 total)