Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,411 through 7,425 (of 59,072 total)

Reply To: Cursors Without Performance Penalties

Whew!!! Nice one, Steve!! You had me going there! I was thinking that I should plan on retiring sooner than I really wanted because even the cursors in Oracle 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)

April 1, 2020 at 1:19 am

#3739483
Reply To: Calculating Easter in SQL

Very nice collection of algorithms, Jeffrey. I've got one more for you to add to your collection.
Peter "Peso" Larsson came up with the following basic method quite a while back. ...
--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)

April 1, 2020 at 1:05 am

#3739481
Reply To: Need some help getting info of people logged in, but from the POV of NON-Sysadm

We have no clue by what you mean by "unexpected results".
--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)

March 31, 2020 at 8:38 pm

#3739425
Reply To: extract all data with week

For me, it was the initial run of having an extra 90 million rows. 😀
--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)

March 31, 2020 at 8:35 pm

#3739423
Reply To: Collections: Computed gaps for continuous numbers
David Burrows wrote:
Never used geometry by I suppose some this like this
```
SELECT N, 
GEOMETRY::STGeomFromText('POLYGON(('+CAST(N as varchar(10))+' 0, 1 1, 0 1, 0 0, 1 0))', 0) 
FROM (VALUES(1))...
```
--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)
March 31, 2020 at 4:59 pm

#3739358
Reply To: Collections: Computed gaps for continuous numbers

Anyone?
--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)

March 31, 2020 at 4:01 pm

#3739334
Reply To: Result of sp_WhoIsActive is periodically saved. But what can we use it for?

Use your imagination. 😀 You can use it to figure out what causes the most blocking at certain times of the day not to mention that if you fix such...
--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)

March 31, 2020 at 3:59 pm

#3739333
Reply To: extract all data with week

Jeffrey Williams wrote:
Open Windows Powershell ISE - this is the development tool for Powershell included with Windows 10.
You will need to include 2 variables that I excluded from the post. Those...
--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)

March 31, 2020 at 3:27 pm

#3739322
Reply To: When Will Privacy Matter?

It's a shame that Brent didn't subscribe to this thread because I think he's pretty much spot 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)

March 31, 2020 at 1:24 pm

#3739274
Reply To: Grant user to create schemas

I recommend that f you have more than one app, use more than one service login. Each app should have it's own so you can more easily trace things like...
--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)

March 31, 2020 at 3:27 am

#3739190
Reply To: search the value of a field as a substring of another field.

Just plan on such a thing doing full table scans because the JOIN criteria will become non-SARGable.

--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)

March 31, 2020 at 2:19 am

#3739183
Reply To: Grant user to create schemas

Siten0308 wrote:
Hey Jeff,
sadly not my choice, but they are deploying an application, and the application is requesting to create some schemas, so, I hoped they would give me the scripts...
--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)

March 31, 2020 at 2:09 am

#3739182
Reply To: Collections: Computed gaps for continuous numbers
Ok... so we have the following test code from the article...
```
DECLARE @tab TABLE(Col1 GEOMETRY);
INSERT @tab(Col1)
SELECT GEOMETRY::STGeomFromText('POLYGON((1 0, 1 1, 0 1, 0 0, 1 0))', 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)
March 31, 2020 at 1:35 am

#3739177
Reply To: When Will Privacy Matter?

Privacy has always mattered. We just gave the up the first time we opened a bank account or bought a house or bought a car or applied for/used a credit...
--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)

March 31, 2020 at 1:10 am

#3739175
Reply To: Grant user to create schemas

The next question would be.... why are you giving users privs to create schemas?
--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)

March 31, 2020 at 12:59 am

#3739172

Viewing 15 posts - 7,411 through 7,425 (of 59,072 total)