Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,531 through 22,545 (of 59,099 total)

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
RE: Alternative to xp_cmdshell

Gazareth (11/6/2014)
Powershell sounds good for this. You'll need to install SQLPS module, and then simply (NB - pseudocode):
Invoke-SqlCmd -ServerInstance servername -Database dbname -Query "EXEC proc" | Export-Csv filename.csv
or
Invoke-SqlCmd -ServerInstance servername...
--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:42 am

#1756979
RE: Serial Date conversion

cbrammer1219 (11/4/2014)
This is what I have done, then I take that and do a DATEDIFF on the 2 values to get the seconds.
CONVERT(varchar(8),CONVERT(datetime,case
...
--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 5, 2014 at 8:19 pm

#1756862
RE: Serial Date conversion

cbrammer1219 (11/4/2014)
Ok so no that I have that, I am looking to do a case so that if the value can be converted to minutes, hours or leave as seconds....
--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 5, 2014 at 7:07 pm

#1756858

Viewing 15 posts - 22,531 through 22,545 (of 59,099 total)