Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 59,086 total)

Reply To: Very slow db detach

Manisha93 wrote:
@chris4600
I had same issues , the detach query executed for 4 hours but didn't completed.
The solution worked for me is very simple. I dont know the reason behind 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)

August 1, 2022 at 7:11 pm

#4071077
Reply To: Cloud path for beginners

ratbak wrote:
I suspect you meant "...relational databases are not going away."?
Absolutely correct. Can't believe I phat phingered that. Thank you for the catch.
--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:55 pm

#4071069
Reply To: SQL Using a PIVOT to Convert row data to column

Ok... so tell us how you got the numbers is the "after" graphic from the numbers in the "currently have" graphic. The don't add up.
--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:52 pm

#4071066
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

Viewing 15 posts - 3,091 through 3,105 (of 59,086 total)