Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,656 through 23,670 (of 59,102 total)

RE: xp_cmdshell works and then doesn't work

Ed Wagner (5/13/2014)
JustOffal - I'm incredibly curious about this one, too. Please post the command and the output.
Jeff - You know I'm thinking of your presentation that isn't ready...
--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)

May 13, 2014 at 5:03 pm

#1713273
RE: Create Clustered Index on a Very Large Table (500 GB)

Thanks, Kevin. Now THAT's an interesting bit of information. I can see it being a benefit to INSERT performance as well since a heap on a temporal audit...
--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)

May 13, 2014 at 9:02 am

#1713112
RE: Partitioned Heap

Thanks for the reply, Howard. That's pretty much my opinion, as well, and I've also constructed my temporal audit tables in the same manner that you have. 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)

May 13, 2014 at 8:40 am

#1713096
RE: Is there any way to improve statistics on a table like this?

It's more likely that the new index is quite a bit better than the others and, since it was just built, has a recently updated set of stats.
Thanks 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)

May 13, 2014 at 8:15 am

#1713077
RE: Create Clustered Index on a Very Large Table (500 GB)

-A (5/12/2014)
Jeff Moden (5/12/2014)
-A (5/7/2014)
Thanks for the replays.
--Here is the answers to the follow up questions:
1) I have to create this Index online since it is huge and I cannot...
--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)

May 13, 2014 at 12:23 am

#1712906
RE: New DMVs in 2014

Very cool. That'll make an awesome article. Thanks, Ed.
--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)

May 12, 2014 at 10:41 pm

#1712893
RE: Running totals for general ledger

haddoque2000 (5/12/2014)
Thanks,
I think I was a bit unclear in my post. I have managed to get that far. It's the update part that is still unsolved. That is, I want...
--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)

May 12, 2014 at 4:30 pm

#1712877
RE: Performance issue

While it's incredibly primative, I've found it to be very effective. You've already identified WHEN the high CPU usage occurs. Open TaskManager and find out WHAT is using...
--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)

May 12, 2014 at 4:18 pm

#1712876
RE: Create Clustered Index on a Very Large Table (500 GB)

-A (5/7/2014)
Thanks for the replays.
--Here is the answers to the follow up questions:
1) I have to create this Index online since it is huge and I cannot afford such 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)

May 12, 2014 at 4:14 pm

#1712875
RE: New DMVs in 2014

It would also be cool to identify any DMVs that have been deprecated or discontinued, if there are any. If there are none, that would be good to know,...
--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)

May 12, 2014 at 4:10 pm

#1712874
RE: Adding the Current Date to a SSIS Column

ganteng1 (5/12/2014)
Hi. I'm not really sure how to better demonstrate this. Basically, I need my field/column names to be dynamic.
Thanks
I know a lot of people will scoff at it but...
--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)

May 12, 2014 at 4:06 pm

#1712871
RE: Is there any way to improve statistics on a table like this?

It's odd how SQL Server sometimes recommends an index that already exists. :crazy:
If that's a very common set of queries, I'd drop the index that contains only the ParentID and...
--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)

May 12, 2014 at 3:55 pm

#1712869
RE: Enabling CDC for hundreds of databases on one instance, do or do not?

ScottPletcher (5/12/2014)
CDC should perform far better than hand-written triggers on all those tables.
Make sure you have sufficient pre-allocated log space to hold the changes until CDC can process them all.
Rumor...
--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)

May 12, 2014 at 3:29 pm

#1712861
RE: xp_cmdshell works and then doesn't work

JustOffal (5/12/2014)
Did you ever find out why xp_cmdshell only worked intermittently? I have a similar problem, but mine is running BCP and it just hangs. I have to...
--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)

May 12, 2014 at 3:16 pm

#1712860
RE: xp_cmdshell works and then doesn't work

Sorry... responded to an older post on this thread that had already been answered so removed my duplication.
--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)

May 12, 2014 at 3:13 pm

#1712856

Viewing 15 posts - 23,656 through 23,670 (of 59,102 total)