Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,016 through 12,030 (of 59,099 total)

RE: How to read list of files in folder using T-SQL?

Sergiy - Monday, June 25, 2018 6:35 PM
May be awesome, but still adding no value to the product.
It's may appear useful...
--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)

June 25, 2018 at 10:12 pm

#1995225
RE: Warning: No Join Predicate (Nested Loop)

heb1014 - Monday, June 25, 2018 7:34 AM
It's a recruiting/staffing application. I know the schema 😉
Got it. Thanks.
--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)

June 25, 2018 at 8:32 am

#1995163
RE: When it comes to salaries, I'm not average

Sean Lange - Monday, June 25, 2018 7:26 AM
We require our developers to do almost all of their own t-sql. The...
--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)

June 25, 2018 at 8:27 am

#1995161
Reply To: How to read list of files in folder using T-SQL?

ThomasRushton - Monday, June 25, 2018 7:20 AM
I know this was a followup to an old SQL2008 question, but, if you're running SQL 2017, check...
--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)

June 25, 2018 at 8:08 am

#1995157
RE: Warning: No Join Predicate (Nested Loop)

heb1014 - Monday, June 25, 2018 6:33 AM
How do you like working with Adapt?
What is "Adapt" and how do you know 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)

June 25, 2018 at 7:31 am

#1995147
RE: SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time)

sirkinghorse - Monday, June 25, 2018 6:32 AM
Batches of 50k, that's the requirements. if I have 200k in the table, they want...
--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)

June 25, 2018 at 6:43 am

#1995136
RE: Warning: No Join Predicate (Nested Loop)

alex.sqldba - Friday, June 22, 2018 4:57 PM
Morning Guys,
The following query is complaining about having no join predicate on a nested loop
EDIT:...
--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)

June 25, 2018 at 6:39 am

#1995134
RE: How to read list of files in folder using T-SQL?

Charles Bilodeau-369032 - Monday, June 25, 2018 6:09 AM
That is all good but is it possible to do it without using CMDSHELL?
Other...
--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)

June 25, 2018 at 6:34 am

#1995133
RE: SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time)

sirkinghorse - Monday, June 25, 2018 5:20 AM
Hi,
I have a table with 200 000 records, I need to send a file with...
--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)

June 25, 2018 at 6:26 am

#1995130
RE: After Insert trigger

Arsh - Monday, June 25, 2018 1:27 AM
Hi All,
I'm trying to create an After Insert in SQL Server 2008 R2 with the...
--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)

June 25, 2018 at 6:24 am

#1995129
RE: Are the posted questions getting worse?

BrainDonor - Monday, June 25, 2018 2:05 AM
Sean Lange - Friday, June 22, 2018 3:08 PM
--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)

June 25, 2018 at 6:22 am

#1995127
RE: Best method to reorganize sql server database

Lj Burrows - Sunday, June 24, 2018 10:41 PM
Here is the best way to reorganize the SQL Server Database. Go through it:
--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)

June 25, 2018 at 6:00 am

#1995122
RE: Restored database from 2012 to 2017 - a table was slow as a snail to query, until I recreated it with another name - what gives?

Possibly...
If the indexes suffered a decent amount of logical fragmentation, it's possible that the read-aheads on the new server got your during the initial load into memory. 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)

June 24, 2018 at 10:45 pm

#1995088
RE: Are the posted questions getting worse?

Sergiy - Sunday, June 24, 2018 6:23 PM
jasona.work - Friday, June 22, 2018 11:03 AM
--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)

June 24, 2018 at 10:34 pm

#1995086
RE: When it comes to salaries, I'm not average

xsevensinzx - Saturday, June 23, 2018 8:52 PM
Jeff Moden - Saturday, June 23, 2018 6:07 PM
--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)

June 23, 2018 at 10:26 pm

#1995072

Viewing 15 posts - 12,016 through 12,030 (of 59,099 total)