Jeff Moden

Forum Replies Created

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

Reply To: extended events not showing events

robh0502 wrote:
thanks all. Seems to be working now.
What did you change to make it so?
--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)

November 4, 2023 at 9:47 pm

#4321314
Reply To: A rose by any other name would not be a rose

Heh... what? You don't like using D1, D2, D3, D4, etc, for the names of cascading CTEs? 😛 Or, how about table aliases named T1, T2, T3, T4, etc?
I've seen...
--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)

November 4, 2023 at 4:24 am

#4320869
Reply To: Trigger to track changes

sqlguy80 wrote:
I need to track changes when a column is updated on two tables.
Is there a way to do it. please send code for that.
Yes... there's a super easy way...
--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)

November 2, 2023 at 11:40 pm

#4320062
Reply To: Need help with the logic

Not that the code is unreadable or anything like that but consider documenting your production code so people don't have to try to figure out what the intent 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)

November 1, 2023 at 7:02 pm

#4319190
Reply To: stats get updated even when query is trivial

robh0502 wrote:
hi Jeff, I think the problem was that I didn't restart the server after messing with the auto update stats and auto update stats async values. Without restarting 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)

October 31, 2023 at 11:17 pm

#4318588
Reply To: Batch Execution Mode on a Rowstore in SQL Server 2022

It would have been nice if you would have provided some links to the MS Documentation so people could easily find it to learn more.

--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)

October 31, 2023 at 7:41 pm

#4318496
Reply To: Extract file in zip format

André Silveira wrote:
So, I tried converting to "nvarchar(max)" and "varbinary(max)," but without success. Therefore, I had to resort to a more radical approach, which involved extracting data from the client's portal....
--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)

October 31, 2023 at 7:36 pm

#4318495
Reply To: How do I add files to the server?

mjdemaris wrote:
So Jeff,
this sounds like a dumb question, but how do I insert a blob (image/pdf/doc) into the table via the SSMS? Do I need a CAST statement or an...
--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)

October 31, 2023 at 6:42 pm

#4318460
Reply To: stats get updated even when query is trivial
Using the following code (your code with some stats measurements added), I'm not seeing any updates to the stats on the 600 row run.
```
--SELECT 500 + (0.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)
October 31, 2023 at 4:19 am

#4317997
Reply To: SQL Service is not starting after upgrade...

us26 wrote:
This fixed the issue: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-15151 Thanks. I wonder would it be possible to use SQL Profiler (or XE) to find out this kind of issues? To detect the batch...
--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)

October 29, 2023 at 6:14 pm

#4317126
Reply To: SQL Service is not starting after upgrade...

If doing what the error text you posted (checking the logs) brings no joy, I can think of no other recovery than to do restores from the backups 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)

October 28, 2023 at 6:49 pm

#4316700
Reply To: Can trigger execution be excluded only for a particular login?

I believe the latter that you mention is the only way.
I also want to warn than none of what has done (according to what you've described) will hold up 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)

October 28, 2023 at 6:41 pm

#4316698
Reply To: Query related issue

Grant Fritchey wrote:
I'd need to see the execution plans to understand what's going on. Further, two different databases means, possibly, two different sets of data, two different sets of statistics, two...
--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)

October 28, 2023 at 6:33 pm

#4316697
Reply To: Query related issue

Jeffrey Williams wrote:
Compatibility mode?
Sidebar: stop using DB..Table - specify the schema instead of expecting SQL Server to find the correct schema for the table. That is dependent on the default schema...
--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)

October 28, 2023 at 3:08 am

#4316367
Reply To: How do I add files to the server?

Just a post to expose page 2 because of the forum fault in that area.

--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)

October 27, 2023 at 9:10 pm

#4316216

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