Jeff Moden

Forum Replies Created

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

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
RE: Most important DBA Skill?

This subject has come up again on another thread. It seems that a lot of people want the skill when it comes to a DBA. Others want a people person...
--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 9:47 pm

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

xsevensinzx - Saturday, June 23, 2018 5:50 AM
Jeff Moden - Saturday, June 23, 2018 4:37 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 23, 2018 at 6:07 pm

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

xsevensinzx - Friday, June 22, 2018 10:24 PM
Jeff Moden - Friday, June 22, 2018 5:50 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 4:37 am

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

Andy Warren - Friday, June 22, 2018 6:11 PM
Jeff now I get your point!
It's a tough point to "get". Thanks for 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 22, 2018 at 7:31 pm

#1995047

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