Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,106 through 3,120 (of 59,098 total)

Reply To: Missing Data(finding the root problem)

Step 1 would be to query just the view to see if the date range returns anything. Then add a piece of your query for one of the joins 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)

August 1, 2022 at 6:46 pm

#4071065
Reply To: Index created in the last few days

If your system is like mine, the data in the default trace lasts about 6 seconds. 😉
--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 1, 2022 at 6:33 pm

#4071050
Reply To: How to Get Data Using Python in Power BI

With the understanding that I've never used Power BI, are you suggesting that Power BI cannot get data directly from SQL Server without having to use a language like Python?
If...
--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 1, 2022 at 4:55 am

#4070727
Reply To: Send Mail Task Failed Using SSIS Package

I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security??? 😉
--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)

July 31, 2022 at 7:24 pm

#4070655
Reply To: Intermittent "nesting level exceeded" error

I just checked the MS documentation... Here's the link of the document section I'm looking at.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql#recursive-triggers
It's amazing to me that this is still only a server level option 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)

July 31, 2022 at 7:10 pm

#4070654
Reply To: Intermittent "nesting level exceeded" error

michio42 wrote:
That other table has a trigger, but no write operations, other than to itself.
Just at a quick glance, I'm thinking the above from your original post is the source...
--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)

July 31, 2022 at 6:54 pm

#4070652
Reply To: Count a new field in SQL statement

The use of COUNT() OVER will make light work of this. It basically does what Phil says... provides a combination of COUNT with GROUP BY. You would use the PARTITION...
--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)

July 31, 2022 at 6:36 pm

#4070650
Reply To: Best approach for column data type alters for a large table?

jchapman wrote:
PS... my version of money and happiness...
"Money can't buy happiness, but it can buy you a sailboat big enough that you can sail right up next to it."
Old 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)

July 31, 2022 at 6:30 pm

#4070641
Reply To: Best approach for column data type alters for a large table?

@jchapman ,
Have you already started on this? I'm asking because I see some red flags in some of the posts above but don't want to waste my time advising if...
--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)

July 31, 2022 at 6:22 pm

#4070640
Reply To: Log backup job running long time

ramana3327 wrote:
Hi,
We have log backup job running daily 5 times. One time run is taking 4-5 times longer than the other runs daily. The backup size is same for all...
--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)

July 31, 2022 at 6:16 pm

#4070639
Reply To: Archiving big table

The best way to do this is monthly partitioning using either Partitioned TABLE or Partitioned VIEW technology. Not intending to sound the part of an iconoclast ,...
--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)

July 31, 2022 at 6:04 pm

#4070638
Reply To: Create a Tally Function (fnTally)

I've found that changing datatypes in a Tally function really isn't necessary but that's a personal observation. Implicit conversions usually work just fine here. I've not personally ever run into...
--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)

July 31, 2022 at 4:34 pm

#4070625
Reply To: Create a Tally Function (fnTally)

Thanks, Jonathan.
A long time ago, it used to make quite a difference performance wise. Not so much on singleton big stuff like so many people test with but on 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)

July 31, 2022 at 4:46 am

#4070504
Reply To: SQL Query Best Approach Recommendations

Thanks, Scott. I appreciate 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)

July 31, 2022 at 4:37 am

#4070503
Reply To: SQL Query Best Approach Recommendations

WHY did you delete your original post? That's not very friendly.
--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)

July 30, 2022 at 1:58 am

#4070204

Viewing 15 posts - 3,106 through 3,120 (of 59,098 total)