Jeff Moden

Forum Replies Created

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

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
Reply To: A Smarter Planet

Nicole Bowman wrote:
It is now entirely plausible to practically track our every movement using nano sized RFID chips or "nano dust", of the type developed by Hitachi, each of which contain...
--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, 2020 at 5:42 pm

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

892717952 wrote:
Yes, the target table has a identity column, the said "disable" identity column means I set the identity column No under the table's identity specification.
actually, the indentity column is...
--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, 2020 at 5:00 pm

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

There is no "Disable" for Identity columns. Either it exists or it does not. The best you can do if it exists is to SET IDENTITY_INSERT ON when trying to...
--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, 2020 at 2:41 am

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

You do realize that by setting your database to SIMPLE that you just broke your logfile chain if one existed, right?
Shifting gears back to the problem at hand.... what is...
--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, 2020 at 1:43 am

#3803218
Reply To: Are the posted questions getting worse?

I'm getting old so I have to stay away from open flame to avoid gaslighting. 😀
--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 30, 2020 at 9:11 pm

#3802962
Reply To: Are the posted questions getting worse?

Dammit... I made myself hungry typing that.
--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 30, 2020 at 4:02 pm

#3802872
Reply To: Are the posted questions getting worse?

Thom A wrote:
I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of a...
--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 30, 2020 at 4:00 pm

#3802871
Reply To: Are the posted questions getting worse?

Steve Collins wrote:
Someday maybe I'll revisit SO but for now I'm just sick of it.
It's funny... every once in a while, I go back for a look-see... I'm quickly reminded as...
--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 30, 2020 at 2:55 pm

#3802842
Reply To: Foglights

astrid 69000 wrote:
Hi,
We are looking into the monitoring software foglights? any thoughts?
In all seriousness, what is it that you think you want to monitor and what benefits do you think 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)

October 30, 2020 at 2:49 pm

#3802840

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