Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,501 through 22,515 (of 59,072 total)

RE: Are the posted questions getting worse?

Steve, I have an idea. Set it up so that when I report a post as spam and I include a secret word in the report, have the system...
--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 9, 2014 at 7:06 pm

#1757349
RE: how to import a series of files with different columns

There's one other difference depending on how it's coded. Performance. RBAR inserts tend to be incredibly slow compare to multi-row set-based inputs.
Which brings me to a subject...
Lot's 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 8, 2014 at 8:16 pm

#1757325
RE: Min valuee of column (ignoring blanks, Nulls, zero)

Would [font="Courier New"]WHERE somecolumn <> 0[/font] do it for 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)

November 7, 2014 at 10:06 pm

#1757292
RE: RAISERROR DOES NOT SHOW MESSAGE

shohelr2003 (11/4/2014)
Dear,
I have created a "After Insert" trigger in one of my tables. It will raise an error message if conditions are not met. When I click on "Save" button,...
--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 7, 2014 at 9:50 pm

#1757291
RE: Say I have 460 indexes that need to be rebuilt.... :w00t:

dndaughtery (11/7/2014)
I am running the following script to get the indexes that have fragmentation over 30%. The result set is returning some indexes that I don't see in Object exlorer...
--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 7, 2014 at 9:37 pm

#1757290
RE: Say I have 460 indexes that need to be rebuilt.... :w00t:

dndaughtery (11/7/2014)
At the present the fill factor on all indexes are 0
Then you should be good to go with Ola's proc.
--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 7, 2014 at 9:36 pm

#1757289
RE: Primary Key datatype Bigint vs uniqueidentifier:

CELKO (11/7/2012)
Can any one suggest me for each tables primary key should be Bigint as Primary Key or [uniqueidentifier] as PRIMARY KEY ?
This is a silly question and 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)

November 7, 2014 at 9:32 pm

#1757288
RE: What would cause index REORGANIZE to take longer than index REBUILD?

REORGANIZE is done within the confines of what is currently in the indexes insofar as pages goes. That means that it sometime has to contend with blocking because it's...
--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 7, 2014 at 9:07 pm

#1757287
RE: how to import a series of files with different columns

qinzhen (11/7/2014)
Eirikur Eiriksson (11/6/2014)
There are several ways of doing this, somewhat depends on the circumstances which fits best.
Quick questions:
1) Does each file have a single format (number of columns consistent...
--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 7, 2014 at 8:51 pm

#1757286
RE: Say I have 460 indexes that need to be rebuilt.... :w00t:

dndaughtery (11/7/2014)
After thinking on it I'm beginning to think that if I have Hallengren's index maintenance procedure running in a job then I can probably leave the Fill Factor...
--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 7, 2014 at 8:07 am

#1757227
RE: Max Length of AD Names for Security

SQLJocky (11/6/2014)
Perry Whittle (11/6/2014)
SQLJocky (11/6/2014)
.if you enter the entire login to the "Z" on the service account, it will fail.
Yes of course how silly of me, you make no reference...
--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 6, 2014 at 10:37 pm

#1757127
RE: Max Length of AD Names for Security

SQLJocky (11/6/2014)
Jeff Moden (11/6/2014)
SQLJocky (11/5/2014)
But it still causes an issue when trying to use them in their full 21+ character format when adding to SQL services and when adding 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)

November 6, 2014 at 9:35 pm

#1757118
RE: Max Length of AD Names for Security

SQLJocky (11/5/2014)
But it still causes an issue when trying to use them in their full 21+ character format when adding to SQL services and when adding to SQL security...right? That...
--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 6, 2014 at 6:51 am

#1756985
RE: Alternative to xp_cmdshell

Another possibility is to use a Cmd Exec step in a job to do this. Technically, it's not xp_CmdShell and makes most folks feel much better.
BTW, this is one...
--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 6, 2014 at 6:47 am

#1756983
RE: Are the posted questions getting worse?

Greg Edwards-268690 (11/6/2014)
Gazareth (11/6/2014)
Ed Wagner (11/4/2014)
Steve Jones - SSC Editor (11/4/2014)
We made a few forum changes today. If you notice something, let us know.
I don't want to condemn the updates...
--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 6, 2014 at 6:44 am

#1756981

Viewing 15 posts - 22,501 through 22,515 (of 59,072 total)