Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,141 through 13,155 (of 59,095 total)

RE: LOGIN TRANSPORT OPERATION SQL SERVER

While I agree that people need to review any and all code they get from the internet, I have to tell you that if you drop someone's version of sp_help_revlogin,...
--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)

January 16, 2018 at 7:50 am

#1975988
RE: Smart UPDATE STATS Script

Thanks for posting a script but, when you make claims like a script being "smart" or that it will "make your work easier", you really need to include some more...
--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)

January 16, 2018 at 7:40 am

#1975987
RE: Unable to shrink Database

jjimenez-1040959 - Tuesday, January 16, 2018 5:10 AM
In SSMS
-Right click / properties on the database
-In files section check the initial size 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)

January 16, 2018 at 7:32 am

#1975986
RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

Shifting gears a bit, it's amazing to me how much junk Windows Updates leaves behind that you can't actually delete.
--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)

January 16, 2018 at 7:29 am

#1975984
RE: When is too many columns too many columns?

Sorry... posted to wrong thread on this post and moved 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)

January 16, 2018 at 7:25 am

#1975982
RE: How do I code a three-level table name in SSDT that will honour environment settings in deployed job?

Scott In Sydney - Sunday, January 14, 2018 3:25 PM
@jeff: I've used synonyms occasionally, didn't think of using them here. If 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)

January 16, 2018 at 7:24 am

#1975981
RE: When is too many columns too many columns?

Grant Fritchey - Tuesday, January 16, 2018 6:13 AM
If you really only need a flat file, use a flat file storage system...
--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)

January 16, 2018 at 7:20 am

#1975980
RE: SQL Agent job - Power shell script error

itsvenkyyy - Monday, January 15, 2018 4:35 PM
I have created a sql agent job to execute powershell script.
this is to stop SSAS...
--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)

January 15, 2018 at 10:22 pm

#1975952
RE: best practice recommendations requested after data purge

SQLJay - Monday, January 15, 2018 3:02 PM
All,
We are in the process of purging large amounts (20+ millions each) data from various...
--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)

January 15, 2018 at 10:01 pm

#1975951
RE: best practice recommendations requested after data purge

Sue_H - Monday, January 15, 2018 4:03 PM
SQLJay - Monday, January 15, 2018 3:02 PM
--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)

January 15, 2018 at 9:54 pm

#1975950
RE: Cursor with Temp Table & Update

mansour.bozorgmehr - Monday, January 15, 2018 6:22 AM
I had this problem. I added a PRIMARY KEY and IDENTITY (1, 1) to my Temp...
--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)

January 15, 2018 at 10:22 am

#1975918
RE: How to find who has changed the SQL Server service account

RandomStream - Thursday, January 4, 2018 4:54 PM
An ounce of prevention is worth (I forgot the rest).
We have security cameras in...
--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)

January 14, 2018 at 7:33 pm

#1975858
RE: SQL Server All View Refresh

So, what happens when the view is in a schema other than the default schema of the user using the script? 😉
--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)

January 14, 2018 at 7:25 pm

#1975856
RE: What exactly are window functions and partitions?

You can think of some of the Windowing Aggregates as a "per row GROUP BY". The object of the PARTITION BY is like the list of GROUP BY column(s).
--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)

January 14, 2018 at 5:16 pm

#1975853
RE: When is too many columns too many columns?

Kevlarmpowered - Friday, January 12, 2018 3:25 PM
I know you can have some insane number of columns in SQL server... but just...
--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)

January 12, 2018 at 6:29 pm

#1975820

Viewing 15 posts - 13,141 through 13,155 (of 59,095 total)