Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

Brandie Tarvin - Thursday, January 24, 2019 8:30 AM
Brandie Tarvin - Thursday, January 24, 2019 8:28 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 24, 2019 at 4:16 pm

#2020041
RE: very slow select

ScottPletcher - Thursday, January 24, 2019 10:28 AM
Jeff Moden - Wednesday, January 23, 2019 10:53 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)

January 24, 2019 at 1:32 pm

#2020029
RE: Fast Enough

I had an old boss that got angry with me even though we were great friends especially professionally. He had a Developer write code to download and import the data...
--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 9:34 am

#2019995
RE: Is sp_send_dbmail Asynchronous?

I think the following link may have the answers to all of this...
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail-log-and-audits?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)

January 23, 2019 at 11:15 pm

#2019904
RE: very slow select

ScottPletcher - Wednesday, January 23, 2019 11:15 AM
Jeff Moden - Wednesday, January 23, 2019 10:39 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 23, 2019 at 10:53 pm

#2019903
RE: very slow select

ScottPletcher - Wednesday, January 23, 2019 10:16 AM
No, I've looked for fragementation, and other page-size issues, and haven't seen it.
and...
--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 23, 2019 at 10:39 am

#2019847
RE: very slow select

ScottPletcher - Wednesday, January 23, 2019 7:53 AM
this is because the keys of the Clustered Index become a part of 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 23, 2019 at 9:46 am

#2019839
RE: Creating and using inline table-valued functions

kimani_m - Wednesday, January 23, 2019 7:36 AM
Thank you Jeff and also, thank you for pointing out that you can certainly call...
--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 23, 2019 at 8:00 am

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

Please see the following article. I consider it to be the "GO TO" article for such queries.
https://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
--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 23, 2019 at 7:39 am

#2019811

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