Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,731 through 8,745 (of 59,067 total)

Reply To: A DateRange Table Valued function

Aaron N. Cutshall wrote:
Jeff Moden wrote:
IMHO, the closest thing to a CROSS APPLY is a "Correlated Sub-Query" with an implicit join, which can return more than one row per input row if you're...
--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)

August 30, 2019 at 1:29 pm

#3675723
Reply To: update query help

It would appear that the OP has flown the coop instead of answering the question I posed.
--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)

August 30, 2019 at 4:19 am

#3675613
Reply To: A DateRange Table Valued function

IMHO, the closest thing to a CROSS APPLY is a "Correlated Sub-Query" with an implicit join, which can return more than one row per input row if you're not careful...
--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)

August 30, 2019 at 4:14 am

#3675611
Reply To: Should Salary Information Be Confidential?

Eric M Russell wrote:
When job hunting, I'm point blank with potential employers or recruiters about what my current salary is. The way I see it, if either party can't match the expectations...
--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)

August 29, 2019 at 1:44 pm

#3675432
Reply To: Should Salary Information Be Confidential?

x wrote:
There are awesome people on this site. There are also some not so awesome people on this site, and heck maybe I'm not one of the awesome people 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)

August 29, 2019 at 12:59 pm

#3675402
Reply To: Cumilative update

It will vary depending on what the CU is and does. If the documentation for the CU doesn't contain that information, then there's no way to predetermine 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)

August 29, 2019 at 12:40 pm

#3675395
Reply To: SQL Server Triggers.

My first recommendation would be to stop using such homegrown methods. Temporal tables work a fantastic treat and the audit table they leave behind is pretty much immutable with virtually...
--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)

August 29, 2019 at 12:01 pm

#3675382
Reply To: sql server installation

Yes, but I wouldn't. I'd do the migration between the servers.
--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)

August 29, 2019 at 11:51 am

#3675377
Reply To: SQL 2017 post migration memory issues

Grant Fritchey wrote:
Jeff Moden wrote:
Ahhh... I've got to disagree a bit. Instead of changing to comparability level, SQL Server 2017 does have the ability to use the old cardinality estimator at at...
--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)

August 29, 2019 at 11:46 am

#3675375
Reply To: Index and fragmentation

... and read the following to answer most of your other questions...
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-2017
--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)

August 29, 2019 at 2:19 am

#3675269
Reply To: update query help

Guras wrote:
I have a table with the following data . Some rows have col2 as null
col1 col2 col3
1 203 1232
2 null 2343
3 502 15566
4 null 4566
5 null 4545
6 601 4545
7...
--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)

August 29, 2019 at 2:08 am

#3675262
Reply To: SQL 2017 post migration memory issues

Ahhh... I've got to disagree a bit. Instead of changing to comparability level, SQL Server 2017 does have the ability to use the old cardinality estimator at at least 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)

August 28, 2019 at 9:54 pm

#3675222
Reply To: Should Salary Information Be Confidential?

x wrote:
Jeff Moden wrote:
x wrote:
Jeff Moden wrote:
x wrote:
Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and 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)

August 28, 2019 at 9:42 pm

#3675221
Reply To: Tempdb Datafile initial space increasing.

Be careful now... if you do any work with SET IDENTITY_INSERT ON, you might want to reconsider especially on later versions where they essentially made Trace Flag 1117 ALWAYS active...
--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)

August 28, 2019 at 9:38 pm

#3675219
Reply To: Index and fragmentation

Here's a presentation by Paul Randal on the subject. He's the guy that wrote most of the fragmentation related stuff.
https://www.youtube.com/watch?v=p3SXxclj_vg
--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)

August 28, 2019 at 9:03 pm

#3675204

Viewing 15 posts - 8,731 through 8,745 (of 59,067 total)