Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,961 through 9,975 (of 59,102 total)

RE: Move clustered index to a new filegroup

as1981 - Friday, January 25, 2019 7:29 AM
Hello,
Apologises. I should have posted code. It's just SSMS generated code altered to specify 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)

January 25, 2019 at 7:39 am

#2020113
RE: Move clustered index to a new filegroup

Hold on a minute... HOW are you trying to do the move? What code?
--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)

January 25, 2019 at 7:24 am

#2020110
RE: RPC:Completed in SQL Profile, but the data is not updated

Gamleur84 - Friday, January 25, 2019 12:10 AM
Hi
Thank you for all the input.
I know it seems that I am not looking...
--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)

January 25, 2019 at 6:20 am

#2020096
RE: DEV - Execution plan IF there were more CPUs

The trouble is that you can look at execution plans all day and still have problems because even actual execution plans are riddled with estimates. The only method to accurately...
--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)

January 25, 2019 at 6:09 am

#2020093
RE: How do I change a SELECT statement in a stored procedure based on the value of a variable?

Luis and I have both pointed to Gail Shaw's "Catch All Query" article. If you don't have time to do such a thing then you'll need to make time to...
--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)

January 25, 2019 at 6:03 am

#2020091
RE: pick random (shuffle by dept) employees from employees table and update main table with employee name

naveed.tuf - Thursday, January 24, 2019 8:54 AM
Hi,
I have a task which I have been working on but 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)

January 25, 2019 at 5:55 am

#2020090
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, January 25, 2019 5:24 AM
That is my new favorite code snippet. I have to save that in...
--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)

January 25, 2019 at 5:36 am

#2020087
RE: Different Index size value for Indexed View

Mahesh Bote - Wednesday, January 23, 2019 8:00 AM
Hi,
I have one indexed view. when I checked it through SP_SPACEUSED and DMVs, 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)

January 25, 2019 at 5:09 am

#2020084
RE: Try Catch Best Practice for Large Stored Procedure

tim.stutzman - Wednesday, January 23, 2019 2:31 PM
Hi,
I have inherited a 1600+ line stored procedure at my work that imports sales orders...
--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)

January 24, 2019 at 7:19 pm

#2020060
RE: RPC:Completed in SQL Profile, but the data is not updated

A couple of things come to mind as "possibilities".
1. You've verified that the database that you're looking at is the database the code is executing in, correct?
2. ...
--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)

January 24, 2019 at 7:16 pm

#2020059
RE: sys.dm_db_index_physical_stats

sarahmp - Thursday, January 24, 2019 6:19 AM
Hello,
I'm trying to run the following query in Microsoft SQL Server Management Studio 17. But...
--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)

January 24, 2019 at 7:01 pm

#2020055
RE: TempDB

sqlfriends - Thursday, January 24, 2019 9:26 AM
Our situation is some that adhoc queries and BI self service tools usage from users...
--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)

January 24, 2019 at 6:47 pm

#2020053
RE: pick random (shuffle by dept) employees from employees table and update main table with employee name

I'm pretty sure that no matter what happens, there's going to be a table or index scan involved and that there will also be a SORT involved. Borrowing heavily 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)

January 24, 2019 at 6:30 pm

#2020051
RE: Fast Enough

Eric M Russell - Thursday, January 24, 2019 12:25 PM
Jeff Moden - Thursday, January 24, 2019 9:34...
--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)

January 24, 2019 at 4:39 pm

#2020044
RE: Fast Enough

miapjp - Thursday, January 24, 2019 11:37 AM
I had a similar thing happen. Web accessed database, took forever for customers to upload...
--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)

January 24, 2019 at 4:26 pm

#2020042

Viewing 15 posts - 9,961 through 9,975 (of 59,102 total)