Jeff Moden

Forum Replies Created

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

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

Eric M Russell - Tuesday, June 26, 2018 8:11 AM
Sean Lange - Monday, June 25, 2018 7:26...
--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 26, 2018 at 9:56 am

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

Chris Harshman - Monday, June 25, 2018 9:53 AM
alex.sqldba - Friday, June 22, 2018 4:57 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 26, 2018 at 8:53 am

#1995307
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?

Since things worked fine after rebuilding the table, in this case, I'm thinking that it has nothing to do with the change in the cardinality estimator.
--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 26, 2018 at 7:37 am

#1995287
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

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