Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,486 through 7,500 (of 59,091 total)

Reply To: Pivot Data based on the date range

It would help a whole lot if you explained the basis of the pivot. For example, what does the column labels of [xx-yy] equate to in the original data?
--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 25, 2020 at 8:21 pm

#3737028
Reply To: Deny connect to All databases for a login

I agree with you. That's too much power for what they do. And they shouldn't be creating linked servers for just anyone.
However, if that's the way it is and 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)

March 25, 2020 at 5:27 pm

#3736993
Reply To: Deny connect to All databases for a login

I actually hope that MS doesn't ever fix that. As the resident DBA for my company, I don't want a bunch of yahoooos building linked servers that could cause breaks...
--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 25, 2020 at 4:40 pm

#3736985
Reply To: would like to know more about identity_cache

jcelko212 32090 wrote:
I'm not sure this is still true, but at one point several countries required that invoice numbers and other commercial documents have sequential numbering. This was a legal problem,...
--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 25, 2020 at 12:38 pm

#3736885
Reply To: Table Partition in Sql server with compression

dastagiri16 wrote:
Thanks,got it
If you say so. 😉 Just trying to figure out what your goal is so that we can help someone new at 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)

March 25, 2020 at 12:32 pm

#3736884
Reply To: Deny connect to All databases for a login

John Mitchell-245523 wrote:
Jeff Moden wrote:
Why wouldn't you just disable the login?
Might still need server-level access, for example to create logins or linked servers.
John
If that's true, I wish the OP would state 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)

March 25, 2020 at 12:31 pm

#3736881
Reply To: Query optimizer : bad plan for simple select

wrote:
Tip for when you 'walk the second range', take the stories.id from your first query (i.e. add it to the result), and then in the second query add 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)

March 25, 2020 at 12:29 pm

#3736854
Reply To: Can't find my option to run my package in my toolbar

wrote:
That is extraordinary... what's more, it accomplishes work, yet I don't assume you realize how to get the toolbar like you have in the image? I might truly want...
--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 25, 2020 at 12:24 pm

#3736853
Reply To: Getting the Hex values

The correct answer (according to me :D) isn't available in the list of answers. The correct answer would be to do it in T-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)

March 25, 2020 at 12:19 pm

#3736851
Reply To: Converting nvarchar to date

cbrammer1219 wrote:
I got this to work, however if the month is 1-9 it sets the date to '01/01/1900' because of the month not having 2 digits.
CASE WHEN ISDATE(left([Due Date],2) +'/'+...
--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 24, 2020 at 7:37 pm

#3736752
Reply To: Extract Date Time from String as datetime format

Using an idea similar to Phil's good code, if the date and time notation and the extension will always be the same, you could do this just for a little...
--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 24, 2020 at 7:07 pm

#3736736
Reply To: Deny connect to All databases for a login

Why wouldn't you just disable the login?

--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 24, 2020 at 6:39 pm

#3736734
Reply To: Partitioning Limits in SQL Server 2019

Jacob Wilkins wrote:
I know. I'm not saying it makes the question or answer incorrect.
I was just providing a possible reason for the explanation's being inaccurate in the way JeremyE pointed out.
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)

March 24, 2020 at 5:13 pm

#3736695
Reply To: Partitioning Limits in SQL Server 2019

I'm not sure why such an omission matters. The title of the question specifically cited "Partitioning Limits in SQL Server 2019" and the link is to the official documentaion.

--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 24, 2020 at 5:07 pm

#3736693
Reply To: would like to know more about identity_cache

MVDBA (Mike Vessey) wrote:
an interesting point... using that feature to mask missing identity rows for audit … is that not unethical? just asking for opinions
Identity cache doesn't work that way. Identity cache...
--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 24, 2020 at 5:01 pm

#3736691

Viewing 15 posts - 7,486 through 7,500 (of 59,091 total)