Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,151 through 6,165 (of 59,098 total)

Reply To: I/O Statistics by file per database?

Why not just use sp_WhoIsActive for that stuff? It's free.
Like I said before, knowing which files are the most active won't tell you a thing about what your problems are...
--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 3, 2020 at 9:14 pm

#3804032
Reply To: I/O Statistics by file per database?

My question would be... What do you expect to actually do with such information? It qualifies which files are the busiest but not why or whether or not being 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 3, 2020 at 6:23 pm

#3803986
Reply To: The Separation of Tools

Eric M Russell wrote:
I can see why keeping SSMS and ADS separate, both in functionality and as an installation, would make sense at this point, because it's on-prem versus Azure.
However, I have...
--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 3, 2020 at 4:52 pm

#3803952
Reply To: Large objects data type issues

Michael L John wrote:
Yeah. My bad. My brain and my fingers were not in sync. Thanks for correcting me.
Heh... NP. At least it wasn't me for a change. 😀 😀 😀
--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 3, 2020 at 4:34 pm

#3803947
Reply To: Large objects data type issues

bobrooney.81 wrote:
As per my understanding, LOB data will also get stored inside the page. However , if the row data is exceeding 8000 bytes, then the data is stored off...
--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 3, 2020 at 1:10 pm

#3803868
Reply To: Large objects data type issues

Michael L John wrote:
Jo Pattyn wrote:
7) Why are you still on 2017 RTM
Same question from me. As well as why are you still using an ntext data type? That was deprecated with SQL...
--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 3, 2020 at 7:56 am

#3803794
Reply To: wildcard query of optimization

Lordy... some designer needs a serious pork chop lesson on the first rule of the First Normal Form. <facepalm>.
The only way you're going to be able to fix this for...
--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 3, 2020 at 7:52 am

#3803793
Reply To: merge data

You're also running 2008, which is more than a decade old and hasn't been supported for years. I strongly recommend that you develop an upgrade plan.
--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 3, 2020 at 3:42 am

#3803731
Reply To: A Getting Started PostgreSQL Tutorial

S. Kusen wrote:
What a time to be alive, Jeff! We all need to start branching out, I feel.
Heh... what a lot of people consider to be "branching out" is a bit...
--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, 2020 at 9:40 pm

#3803660
Reply To: The Separation of Tools

D_ wrote:
Didn't the DOJ ding Microsoft for these "bundling" practices back in the 90s?
Dunno but I'm thinking they might need another "ding" in multiple areas. They gotten way to arrogant...
--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, 2020 at 9:34 pm

#3803659
Reply To: The Separation of Tools

Let's hope they keep them separate forever and realize that not everyone is ever even going to go near Azure and that SSMS needs to be maintained.
--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, 2020 at 2:35 pm

#3803550
Reply To: How to minimize the SQL Server log growth

You're welcome and thank you for the feedback.
--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, 2020 at 2:31 pm

#3803548
Reply To: How do i find who has connected to my SQL Instance in Past 6 Months.

Unless you have some form of auditing turned on or you have setup the SQL Server log setup to report all successful logins AND you've kept all rollover logs from...
--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, 2020 at 2:29 pm

#3803547
Reply To: Importing Files in Parallel with SSIS

udayashantha wrote:
Is there any possibility to execute a deployed SSIS package ?
Way too little information here. From where do you want to deploy the SSIS package?
--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, 2020 at 1:59 pm

#3803536
Reply To: Importing Files in Parallel with SSIS

mattias wrote:
Unfortunately this doesn't work for me. I am following all the steps and the C# script is able to execute without error but it does not actually run 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 2, 2020 at 1:53 pm

#3803535

Viewing 15 posts - 6,151 through 6,165 (of 59,098 total)