Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,441 through 7,455 (of 59,091 total)

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
Reply To: extract all data with week

Here's something funny (not really)... I don't know how to run the PowerShell examples from the command prompt. I've done it plenty of times building a string in T-SQL and...
--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 30, 2020 at 11:37 pm

#3739135
Reply To: extract all data with week

Thanks, Frederico. I aware of AWK but, pun intended, I've never used it before so I'm a bit AWKward there. 😀

--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 30, 2020 at 11:34 pm

#3739134
Reply To: extract all data with week

GaryV wrote:
Phil Parkin wrote:
Jeff Moden wrote:
GaryV wrote:
If you don't understand these steps, I'd suggest finding a tutorial on SSIS that includes setting variables, ForEach and Connection Managers.
That's why I'm asking people 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)

March 30, 2020 at 11:13 pm

#3739131

Reply To: extract all data with week

The JBMTest table code is on the first page of this thread a little more than half way down but here it is again just to make things easy.

--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 30, 2020 at 10:48 pm

#3739128

Reply To: extract all data with week

Awesome. Thank you both.

--Jeff Moden

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 30, 2020 at 10:34 pm

#3739127

Reply To: extract all data with week

My question would be... has anyone run the PowerShell code to make sure it works (with replacements for the table name, etc, of course)? I ask because I'm no PowerShell...

--Jeff Moden

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 30, 2020 at 9:00 pm

#3739096

Reply To: Index Optimize

That would be correct.

--Jeff Moden

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 30, 2020 at 8:56 pm

#3739095

Reply To: Reaping the benefits of the Window functions in T-SQL

BWAAAA-HAAAA!!!! There's enough bad code out there for me to be really peeved about that I just don't care where the semi-colon is so long as it's there. In fact,...

--Jeff Moden