Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,261 through 4,275 (of 59,069 total)

Reply To: SQL Query Help on Time based query

This is so wrong. Your company is trying to have you fix the wrong problem. The real problem is the source of the data and THAT's what actually needs 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)

December 5, 2021 at 5:18 pm

#3960595
Reply To: Deadlock occurred while trying to perform multiple inserts into the same table

aey wrote:
We wrote the script to split inserting data the same table.
We probably need to see that script.
I also cringe a bit when I see that people wrote 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)

December 5, 2021 at 4:45 pm

#3960588
Reply To: How to increase performance to load a factless date-date-interval table

Or this? (Pipe is being used to indicate a separate column for each date)
2021-01-01 | 2021-01-02 | 2021-01-03 ...
--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)

December 5, 2021 at 4:17 pm

#3960586
Reply To: how to identify BottleNeck by using the data of sys.dm_os_performance_counters

If you do a search for "sys.dm_os_performance_counters", you'll find a ton of some pretty good articles on what to look for. The trouble is, the counters are just reporting symptoms. ...
--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)

December 5, 2021 at 2:35 am

#3960353
Reply To: best way to extract name and number

Jeff Moden wrote:
So... wha'cha wanna do with a name like "Jill St. John" or "James van Allen" or a name with a hyphen in it???
Seems like there's a pretty good chance...
--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)

December 5, 2021 at 12:35 am

#3960344
Reply To: best way to extract name and number

So... wha'cha wanna do with a name like "Jill St. John" or "James van Allen" or a name with a hyphen in it???
Seems like there's a pretty good chance 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)

December 3, 2021 at 7:44 am

#3959870
Reply To: Creating Markdown Formatted Text for Results from T-SQL

Looks a whole lot like good ol' fashioned HTML. Thanks for the link, Tomaz.
--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)

December 3, 2021 at 7:16 am

#3959865
Reply To: Loading x number of CSV files into x number of unique tables of a database

Understood there, as well. No worries. It's not difficult for me to cobble some example tables. I was just going "for the real stuff" just to be sure.

--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)

December 2, 2021 at 10:57 pm

#3959762
Reply To: Arithmetic overflow error converting expression to data type datetime when selec

There are several issues here and the most important of them all is an absolute show stopper for us and almost everyone that has posted has mentioned it in 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)

December 2, 2021 at 12:13 am

#3959344
Reply To: create index columnstore

abdalah.mehdoini wrote:
hello ,
Who has any idea please how to rebuild a clustered index to a clustered columnstore index
thanks
Documentation is your friend. This is an example specifically covered in the following...
--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)

December 1, 2021 at 8:53 pm

#3959289
Reply To: SQL Agent Driving Me Nuts

davidcb wrote:
Thanks for your speedy replies contacted sys administrator numerous group policies had been applied.
Server now same as other SQL instances no issues running various batch files & agent jobs...
--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)

December 1, 2021 at 7:05 pm

#3959254
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
The CSVs were created from Excel. I just save as CSV. I am guessing they are tabbed (they do appear in a table format)
The tables do contain confidential information...
--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)

December 1, 2021 at 7:02 pm

#3959239
Reply To: Loading x number of CSV files into x number of unique tables of a database

Ok. Understood on the column names and the table creation.
Is the data in the files separated by commas or tabs?
Also, is there any chance of attaching one of the files...
--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)

December 1, 2021 at 5:02 am

#3958940
Reply To: Creating Markdown Formatted Text for Results from T-SQL

That's kind of cool. Thanks for the article.
Do you have a link to some formal documentation for what the syntax and possible functionality is for this "markdown" language and how...
--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 30, 2021 at 2:24 am

#3958508
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
That would have been my preferred method as well. But the project has been going on for a few years and this is what has been followed historically, even...
--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 30, 2021 at 1:40 am

#3958500

Viewing 15 posts - 4,261 through 4,275 (of 59,069 total)