Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,516 through 16,530 (of 59,067 total)

RE: Splitting Text Field into individual Columns

rlevy 18902 (10/25/2016)
I have a table with a Notes Field Called NOTES with the following content "C1 User Unable to Log in C2 User did not set password Correctly...
--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)

October 25, 2016 at 7:17 pm

#1908790
RE: Looking for way to dynamically replace street suffix with abbreviation based on tables

Just a reminder that the OP doesn't need to build a "correct" address formatter that follows CASS certification rules. He needed something that would standardize typical spellings of address...
--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)

October 25, 2016 at 6:55 pm

#1908789
RE: Can I do this?

Sterling Ostin (10/24/2016)
Jeff - Look at the fourth and sixth small paragraph of my original post. I did exactly what you are suggesting I did not do. I...
--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)

October 25, 2016 at 6:46 pm

#1908788
RE: Delete massive records and still can't shrink db

WhiteLotus (10/24/2016)
Thanks for the reply . Much appreciated
No message because when I right click on that db and choose Shrink -> data file . It shows up a shrink...
--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)

October 25, 2016 at 12:14 am

#1908508
RE: database features

Phil Parkin (10/24/2016)
sqlserverDBA2016 (10/24/2016)
Is adding the features later same as when installing SQL server
And it's not more xomplicated
I think that Jeff's point of view is that it's safer to reconfigure...
--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)

October 24, 2016 at 6:23 pm

#1908500
RE: Stop query if it is taking too long

Eirikur Eiriksson (10/24/2016)
you will need this index on the dbo.Transaction
CREATE UNIQUE NONCLUSTERED INDEX [INDEX_NAME] ON [dbo].[Transaction]
(
[InvoiceUID] ASC,
[IsSuccess] ASC,
[TransKind] ASC,
[TransactionDate] ASC
)
INCLUDE ( [CardNumber],[ReferenceNumber],[SeqCounter],[UnqReferenceNumber]);
I came up with similar but was really...
--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)

October 24, 2016 at 3:36 pm

#1908489
RE: Very bad performance on a good HP DL380 Gen9 Server

Dird (10/24/2016)
TheSQLGuru (10/6/2016)
I also note that 32GB on a server is just silly these days
??
He means that it's an insufficient amount of ram. They've got USB memory sticks larger...
--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)

October 24, 2016 at 3:28 pm

#1908488
RE: Clownpocalypse and DR

Rod at work (10/24/2016)
I'm old enough to have been working in the IT field during the whole Y2K "event". Major decisions were put off because of it. A lot 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)

October 24, 2016 at 3:23 pm

#1908487
RE: Best Date Dimension Table

krypto69 (10/24/2016)
Thanks.
I think I found one that is pretty good - has fiscal dates (Quarters/Year end, etc)
Can you post the link, please?
--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)

October 24, 2016 at 3:15 pm

#1908485
RE: Big data: transfer x-number of rows per batch?

Another thing to strongly consider when transferring such large amounts of data is "Minimal Logging" and the proper use of Trace Flag 610, which has been available since 2008 R2....
--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)

October 24, 2016 at 3:14 pm

#1908484
RE: Compare two columns before insert

komal145 (10/24/2016)
TABLE ATABLEB
STATUS STATUS
ABCD ABCD If the value are same No insert
BCDG ...
--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)

October 24, 2016 at 2:56 pm

#1908481
RE: Potential presentation idea: The magic of checklists

Hi, Ray...
I'm not sure that you're interested but, for me, check lists are uber important when writing code. I'll take a requirements document, draw a process chart of what...
--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)

October 24, 2016 at 2:48 pm

#1908477
RE: Archiving Filegroups

If you set such file groups to "Read Only", they not only won't need index maintenance but they also won't need to be backed up on every full backup.
--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)

October 24, 2016 at 2:41 pm

#1908475
RE: Best Date Dimension Table

krypto69 (10/24/2016)
Having trouble finding the best date dimension table for financial data.
Any recommendations?
(I thought there was one posted here recently - but I can't find it)
Yes. Tell us what...
--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)

October 24, 2016 at 12:18 pm

#1908442
RE: database features

BrainDonor (10/24/2016)
sqlserverDBA2016 (10/24/2016)
is it always better to add database features like analysis services and integration tools and reporting services
when installing sql server instance, and it wont complicate and cause issues...
--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)

October 24, 2016 at 8:31 am

#1908383

Viewing 15 posts - 16,516 through 16,530 (of 59,067 total)