Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,076 through 6,090 (of 59,089 total)

Reply To: IDENTITY only allowed on one table at a time?
thetubageek wrote:
OK, let me start by answering your questions/concerns:
- The Trigger methodology I am using is what wasa showed to me. I figured it would be good for a "first...
--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 22, 2020 at 6:36 pm

#3812757
Reply To: The Wide Impact of PASS

That's what I'm thinking, as well, but I just didn't want to assume.
--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 21, 2020 at 11:20 pm

#3812588
Reply To: IDENTITY only allowed on one table at a time?

Lordy... why are you using a homegrown temp table version of a cursor to do this? It requires you to materialize the DELETED logical table, has two forms of RBAR...
--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 21, 2020 at 4:59 pm

#3812521
Reply To: IDENTITY only allowed on one table at a time?

I have a question based on the error... do you have Replication running or did you have SET IDENTITY _INSERT ON turned on for a table? It's not easy 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 21, 2020 at 2:31 pm

#3812330
Reply To: The Wide Impact of PASS

My apologies, Grant. There's a bit of confusion on my part from your answer. Your article seemed to indicate that PASS was in a bit (probably an understatement) of financial...
--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 21, 2020 at 2:25 pm

#3812329
Reply To: The Wide Impact of PASS

Does that mean that the virtual summit didn't take in as much as was needed, Grant?
--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 21, 2020 at 4:54 am

#3812235
Reply To: Replaced deprecated types (text, ntext) with Varchar(max) and NVarchar(max) !

Yes... the deprecated types should be changed to the modern types... or at least according to MS. So here's how to fix some of the mistakes MS made when creating...
--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 21, 2020 at 3:40 am

#3812222
Reply To: Replaced deprecated types (text, ntext) with Varchar(max) and NVarchar(max) !

First, nothing has been attached that I can see.
Second, if you did this without the understanding that now all the stuff that might fit "in-row" is now "in-row", which greatly...
--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 20, 2020 at 8:22 pm

#3812144
Reply To: NOT able to backup database

Ant-Green wrote:
SQL can only backup to drives which are local to the SQL server not remote drives unless you use UNC paths etc to provide backups to network locations.
IIRC, you...
--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 20, 2020 at 8:12 pm

#3812140
Reply To: Using hierarchyID

Personally, I don't care for the use of HierarchyID nor it's particular form of positional notation. It's also a bugger to fix if something goes wrong with it.
Perhaps the following...
--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 20, 2020 at 7:44 pm

#3812129
Reply To: How to reduce physical size of database

To be sure, you don't need to rebuild ALL indexes... just the ones that became seriously fragmented because of the index-inversion the shrink.
I also recommend temporarily moving your largest indexes...
--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 20, 2020 at 4:44 pm

#3812069
Reply To: Table Alerts
ScottPletcher wrote:
```
WHERE 
    D >= DATEADD(MINUTE, DATEDIFF(MINUTE, 0, GETDATE()) / 15 * 15, 0) AND
    D <  DATEADD(MINUTE, DATEDIFF(MINUTE, 0,...
```
--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 20, 2020 at 2:52 am

#3811799
Reply To: Using If exists trying to assign the value to a variable when it exists.

Mond wrote:
it worked thank you!
What was it that worked for you?
--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 19, 2020 at 2:15 am

#3809451
Reply To: Table Alerts

mtz676 wrote:
...send reminder text messages...
You need to figure out a couple of things before you go off half-cocked doing something like that. People need to "opt-in" and be informed 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)

November 18, 2020 at 7:33 pm

#3809347
Reply To: How do you convert a timestamp into a date

sterling3721 wrote:
no matter whether you like it or not, 1)application developers write managed code more; 2)application developers implemented the functions, including FORMAT, CONVERT, CAST, LTRIM, RTRIM, TRIM, LEFT, RIGHT; 3)FORMAT...
--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 18, 2020 at 3:37 pm

#3809262

Viewing 15 posts - 6,076 through 6,090 (of 59,089 total)