Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,051 through 7,065 (of 59,072 total)

Reply To: How do we tune a huge DB with ~2TB with huge tables , where do we start ?

Setting a Fill Factor of 80% across the board is a huge and totally unnecessary waste of memory and disk space especially if you have ever increasing index keys 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)

May 20, 2020 at 4:54 am

#3753141
Reply To: Getting blank XML file using BCP with queryout

Brian Pastre wrote:
Yes, the Select runs fine but the BCP doesn't. I'm running the BCP in Query Analyzer in SSMS on the server and database the Select is run on. So...
--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 20, 2020 at 4:47 am

#3753140
Reply To: Convert Sting value to DateTime2

Nope... you've got it. The 2nd operand tells what character position to start working with. The 3rd operand identified how many characters to replace. It can be "0" which means...
--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 20, 2020 at 4:44 am

#3753139
Reply To: How to find multiple repeated occurrences with regular expression using like?

jagus wrote:
All the values in the this field are up to three digit numbers separated by decimal points, but there are up to nine (maybe slightly more) such octets. Some...
--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 20, 2020 at 3:03 am

#3753129
Reply To: Convert Sting value to DateTime2

Thank you for the feedback, Sabarish (I hope I split your name correctly). Just to be sure, though, do you understand what STUFF does? I ask only because a whole...
--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 20, 2020 at 12:09 am

#3753116
Reply To: Getting blank XML file using BCP with queryout

Brian Pastre wrote:
I'm trying to export a query to an XML file. The file gets created fine but it's empty so it's my Select query. I've tried setting quoted_identifiers to on...
--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 19, 2020 at 10:15 pm

#3753090
Reply To: How do we tune a huge DB with ~2TB with huge tables , where do we start ?

JSB_89 wrote:
Forum,
How do we tune a huge DB with ~2TB with huge tables most of them are heaps and some have cluster and non clustered indexes, this is not about...
--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 19, 2020 at 9:47 pm

#3753079
Reply To: Convert Sting value to DateTime2

sabarishbabu wrote:
Thank you !! Working as expected
You're welcome but which 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)

May 19, 2020 at 9:28 pm

#3753067
Reply To: How to find multiple repeated occurrences with regular expression using like?

jagus wrote:
Seems SQL Server doesn't have a regular expression function.
I am trying to query for records in which a varchar field contains values 123.x.5, where x is a integer 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)

May 19, 2020 at 9:05 pm

#3753061
Reply To: Convert Sting value to DateTime2
```
 SELECT CONVERT(DATETIME2(7), STUFF(REPLACE(STUFF('2020-04-29-14.41.26.686978',11,1,'T'),'.',':'),20,1,'.'));
```
--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 19, 2020 at 8:45 pm

#3753056
Reply To: Rolling Back One Bug for Another

roger.plowman wrote:
Steve Jones - SSC Editor wrote:
DevOps isn't related to cadance or QA/testing. It is related to learning to become better. Plenty of companies conflated the two and drove speed over quality (many still...
--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 19, 2020 at 2:39 pm

#3752905
Reply To: Error when copying pasting in Excel data to empty table

You do realize that your dates that you're copying from aren't dates, right? They probably the number of days since 1900-01-01 but they're not actually dates. I believe that's your...
--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 19, 2020 at 2:32 am

#3752771
Reply To: Rolling Back One Bug for Another

The big thing missing here is that there was no investigation as to why any of the bugs were released. There's something very wrong when this type of thing happens...
--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 19, 2020 at 2:09 am

#3752767
Reply To: Displaying Hierarchical Data

Heh... and the graphics I posted in a previous post certainly went south when they did the "improvements" for this site. Lordy.
--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 19, 2020 at 2:04 am

#3752766
Reply To: More Binary CASTing

Heh... one does have to wonder though, why anyone would use a max data type (LOB) for such a thing. 🙂
--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 19, 2020 at 1:37 am

#3752765

Viewing 15 posts - 7,051 through 7,065 (of 59,072 total)