Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,571 through 9,585 (of 59,091 total)

RE: Speedy Table Variables

Stewart "Arturius" Campbell - Wednesday, March 27, 2019 11:35 PM
Jeff Moden - Wednesday, March 27, 2019 11:20...
--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)

March 28, 2019 at 8:05 am

#2034093
RE: Speedy Table Variables

The correct answer should be "It Depends" on which version of SQL Server you have. IIRC, this is a 2019 feature and it hasn't yet been RTM'd yet, has 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)

March 27, 2019 at 11:20 pm

#2034048
RE: Horrible performance using sys.dm_os_performance_counters

At this point, I'm going to suggest that you ask the 3rd party vendor that uses the query.
Also, change the WHERE clause to NOT use "<>". Instead, use...
--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)

March 27, 2019 at 9:43 pm

#2034042
RE: Recursive CTE Duplication

danielfountain - Wednesday, March 27, 2019 8:21 AM
Hi all,
I am working on a system that has Business units and a Parent\Child relationship.
I...
--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)

March 27, 2019 at 2:52 pm

#2034024
RE: Horrible performance using sys.dm_os_performance_counters

PatLap - Wednesday, March 27, 2019 7:32 AM
Hi,
We are in process of buying a third party application (NewRelic) that does a query...
--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)

March 27, 2019 at 2:50 pm

#2034023
RE: TempDB File Size Per TempDB FIle

trent.adams0201 - Wednesday, March 27, 2019 11:33 AM
I've answered my own question. I do need to change the *.mdf file as well...
--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)

March 27, 2019 at 1:36 pm

#2034017
RE: SA account

Admingod - Wednesday, March 27, 2019 10:50 AM
I know it's not a good practice to share SA account password with developers. However,...
--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)

March 27, 2019 at 1:33 pm

#2034016
RE: The SQL Saturday Thread

Michael L John - Wednesday, March 27, 2019 12:40 PM
Make sure you have plenty of fresh air available afterwards.
You get much...
--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)

March 27, 2019 at 1:31 pm

#2034015
RE: Insert to Clustered Index

btw... the execution plan isn't showing "100K" rows... it's show 1.2 MILLION rows! Are you sure that you don't have an accidental many-to-many join going on here in the form...
--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)

March 27, 2019 at 1:28 pm

#2034014
RE: The SQL Saturday Thread

I'm also going to be in Colorado Springs for the SQLSaturday on April 6th. It's been on my bucket list but couldn't afford the flight money or time-wise. Figured out...
--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)

March 27, 2019 at 11:49 am

#2033985
RE: The SQL Saturday Thread

Ed Wagner - Wednesday, March 27, 2019 11:42 AM
Ray K - Wednesday, March 27, 2019 10:58 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)

March 27, 2019 at 11:45 am

#2033983
RE: Indexing and trimming options for very large heap table

I'm thinking that there's no need to change this table despite the angst that some folks have with a heap this size. As was stated, this is an "insert only"...
--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)

March 26, 2019 at 5:53 pm

#2031845
RE: Creating a non-unique index

michael.leach2015 - Tuesday, March 26, 2019 5:01 PM
If you don't specify Unique, then by default a non-unique index is...
--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)

March 26, 2019 at 5:34 pm

#2031844
RE: Limit Size of Tables

I agree that even if you could easily limit the size of tables, you shouldn't. And looking for things after the event won't necessarily help a thing and manually monitoring...
--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)

March 26, 2019 at 4:45 pm

#2031841
RE: TSQL: Grouping continuous timeslots together

drew.allen - Tuesday, March 26, 2019 2:49 PM
This is based on an update that Itzik made
--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)

March 26, 2019 at 4:26 pm

#2031840

Viewing 15 posts - 9,571 through 9,585 (of 59,091 total)