Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,631 through 6,645 (of 59,091 total)

Reply To: Desktop or Laptop for Remote Work

Aaron N. Cutshall wrote:
Jonathan Gennick wrote:
For the road I have a small-form-factor laptop that fits nicely on an airline tray table.
Yeah, until the yahoo in the seat in front of you decides 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)

August 13, 2020 at 4:28 pm

#3780307
Reply To: The Hidden Trigger

Chris Wooding wrote:
It would be nice if the object explorer in SSMS had a node under each database for triggers so that you could see them all in one place.
Agreed 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)

August 13, 2020 at 4:02 pm

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

Lynn Pettis wrote:
Phil Parkin wrote:
Lynn Pettis wrote:
IIRC, there is also a difference in the dates in Excel and SQL Server. Only problem is that I don't quite remember what the problem, had I...
--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 13, 2020 at 2:30 am

#3780068
Reply To: Change dbowner

ramyours2003 wrote:
As we renamed sa login to anothet name and want to change the dbowners of all databases but later versions like 2o12 onwards dbowner of sys databases are changed...
--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 12, 2020 at 4:06 pm

#3779315
Reply To: Change dbowner

ramyours2003 wrote:
Can we change the dbowner to system databses ? if yes how can we proceed?
First, see Grant's reply.
Second, I have to ask... why would you want to/need to do...
--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 12, 2020 at 1:57 pm

#3779264
Reply To: Desktop or Laptop for Remote Work

donald.parish wrote:
My main machine is my desktop. Fast connections to internet and databases. I use a laptop almost always to Remote Desktop Connection to my main desktop. Can use mouse,...
--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 12, 2020 at 1:36 pm

#3779260
Reply To: Desktop or Laptop for Remote Work

Interesting article, Steve. Thanks.
I finally bought a new laptop about 8 months ago (it's only my second one in more than a decade after my first one, which still works). ...
--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 12, 2020 at 4:21 am

#3779154
Reply To: slow query on a partitioned table

ghostman wrote:
I have a huge table with 3B of rows containing around 6 months of data running on Microsoft SQL server 2017 (RTM), which is partitioned day by day on...
--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 12, 2020 at 3:36 am

#3779150
Reply To: slow query on a partitioned table

Adi Cohn wrote:
Unfortunately there is an old bug that for some reason Microsoft is not fixing. When using top clause or min or max aggregation functions on a partitioned table, 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)

August 12, 2020 at 3:19 am

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

Robert Sterbal wrote:
I'm getting the impression that you think a product for hundreds of millions of users has to work the way you want it to. If it doesn't, the product...
--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 12, 2020 at 3:07 am

#3779144
Reply To: Simple query question

dan.bridgeman wrote:
Fair point. I was trying out my solution on a test database that didn't have a prepared Calendar table, so that was my quick hack. I should have cleaned...
--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 11, 2020 at 6:38 pm

#3779051
Reply To: Delete only one record takes 20 seconds and have to delete 11000

I've been through this one before... How many Foreign Keys are pointing at that table? You may have to add indexes to the columns in the other tables 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)

August 11, 2020 at 6:08 pm

#3779031
Reply To: Previous row where condition exists

Like I said, I didn't find the sorts to be obnoxious for the basic Windowing functions... it's the bloody partitioned COUNT(*) that was doing it and I found a work...
--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 11, 2020 at 4:02 am

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

Robert Sterbal wrote:
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
Heh... I look at it another way...
In more than 30...
--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 11, 2020 at 3:55 am

#3778830
Reply To: SQL Script Help

EMtwo wrote:
I am looking for a script that can return the following values for each of the databases in my instance: Object ID, Object Type, Database Name, Table Name, 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)

August 10, 2020 at 8:21 pm

#3778752

Viewing 15 posts - 6,631 through 6,645 (of 59,091 total)