Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,611 through 26,625 (of 59,099 total)

RE: which is better performance wise

To add to Mike's reply, if you have a lot of fixed length columns that frequently contain a NULL value, you might want to consider putting those columns in 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 17, 2013 at 4:43 am

#1624528
RE: Delete records without logging

Lokesh Vij (6/17/2013)
There is nothing called "No Logging" in SQL Server...there is something called "Minimal Logging". This can be achieved by using table locking hints.
DELETE FROM TableName with (TABLOCK)...
--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 17, 2013 at 4:28 am

#1624525
RE: Will shrinking the DB improve time taken by index rebuild process ?

GilaMonster (6/17/2013)
Joy Smith San (6/17/2013)
What are thr things that we need to do to speed up the index rebuild process ?..... in brief...
Better IO subsystem.
More memory (maybe)
Reduce the need 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)

June 17, 2013 at 4:13 am

#1624520
RE: Are the posted questions getting worse?

Lynn Pettis (6/14/2013)
***************************************************
I am officially going to Afghanistan!
I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving 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 16, 2013 at 10:44 am

#1624451
RE: Display all the days in a months in a matrix

An alternative to all of that, especially if you have to work with dates a lot, would be to build a nice, narrow, Calendar Table that contains only the 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)

June 16, 2013 at 10:38 am

#1624450
RE: How to prevent ANY use of xp_CmdShell?

opc.three (6/15/2013)
Jeff Moden (6/15/2013)
opc.three (6/15/2013)
One good turn deserves another Jeff. You started this one.
Absolute rubbish, Orlando. I've not called you any names nor used the kind of language you've...
--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 16, 2013 at 10:06 am

#1624448
RE: ?? on xp_cmdshell not writing to file

I like the idea of not having to concatenate lines or use long unreadable lines so I do thigs like the following...
DECLARE @Cmd VARCHAR(8000);
SELECT @Cmd = '
echo This is
line...
--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 15, 2013 at 11:08 am

#1624372
RE: How to prevent ANY use of xp_CmdShell?

opc.three (6/15/2013)
One good turn deserves another Jeff. You started this one.
Absolute rubbish, Orlando. I've not called you any names nor used the kind of language you've used in 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)

June 15, 2013 at 10:48 am

#1624370
RE: BCP Utility to output contents into CSV

Apologies for the delayed reply...
I guess I'd need to see what one of the SP's that takes user input to be used with xp_cmdShell looks like. I'd also need...
--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 15, 2013 at 10:29 am

#1624366
RE: SSIS - What is the best practice for creating a fixed length flat file.

MWise (6/5/2013)
LOL! Jeff have you been listening in to my meetings? None of our SQL people would choose SSIS. Which is exactly how I felt when I first...
--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 15, 2013 at 10:15 am

#1624363
RE: The Importance of Reading Comments

SPAM reported.
--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 15, 2013 at 10:10 am

#1624361
RE: How to prevent ANY use of xp_CmdShell?

My reference to "More costly" is because, if you install it on a different box, you have the cost of the different box and licensing changes (IIRC). If 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 15, 2013 at 10:02 am

#1624358
RE: How to get results from an SP into a table.

ben.brugman (6/14/2013)
g_demetriou (6/14/2013)
This might be of help to you if you are searching within a database for an sp or view that contains a certain table name, field name, 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)

June 15, 2013 at 9:33 am

#1624352
RE: Insert dummy records

To add to Luis' good posts, the Tally Table does have the limit of whatever it contains. Most people make a Tally Table to contain 11,000 or fewer rows....
--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 15, 2013 at 8:23 am

#1624346
RE: Need some eyes on a SP I'm working on

Are you getting an error or just looking for a "peer review"?
--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 14, 2013 at 6:11 pm

#1624306

Viewing 15 posts - 26,611 through 26,625 (of 59,099 total)