Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,771 through 13,785 (of 59,101 total)

RE: Are the posted questions getting worse?

Speaking of stupid people, my Debbie stopped at the store on the way home for a couple of things. There was no bottled water, no bread, and a lot of...
--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 9, 2017 at 7:05 pm

#1967479
RE: Should We Move to Azure?

xsevensinzx - Thursday, November 9, 2017 3:31 PM
Jeff Moden - Thursday, November 9, 2017 8:26 AM
--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 9, 2017 at 6:30 pm

#1967478
RE: Importing Variable length text files into SQL

steve.alston - Thursday, November 9, 2017 5:51 PM
Thanks to everyone who helped me.
brad.mason 's answer works great. I don't know why 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)

November 9, 2017 at 6:24 pm

#1967477
RE: Using Extended Events to alert on long running queries

Anchelin - Thursday, November 9, 2017 8:23 AM
Hi
Is there a way with Extended Events, where I can set up something; should 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)

November 9, 2017 at 2:39 pm

#1967462
RE: Does Anyone know how you can copy values from a previous row into a null column in SSIS

sgmunson - Thursday, November 9, 2017 1:22 PM
Not that a high velocity pork-chop wouldn't cause any pain, but it would have...
--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 9, 2017 at 1:42 pm

#1967456
RE: Name Value Pairs Table Handling

jcboyer-1091017 - Thursday, November 9, 2017 12:03 AM
Matt Miller (4) - Wednesday, November 8, 2017 6:59 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)

November 9, 2017 at 9:02 am

#1967410
RE: TransactionLog. VLF Fragmentation.

If you actually have a need for a 90GB log file, you're might be doing something wrong even for large systems.
--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 9, 2017 at 8:45 am

#1967401
RE: What is use of pre-defined Schemas in SQL SERVER ?

Arsh - Thursday, November 9, 2017 7:36 AM
In other words...Roles are named set of privileges that can be assigned to other...
--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 9, 2017 at 8:28 am

#1967395
RE: Should We Move to Azure?

Still keeping an open mind about it all (you have to, in this business), does anyone know of a publically available "Before'n'After" cost analysis of "On Premise" vs "Cloud" 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 9, 2017 at 8:26 am

#1967394
RE: Create Table with appropriate Data Types based on flat file

andrew.jones 69458 - Thursday, November 9, 2017 8:02 AM
I have been asked to help another team load some data into a new...
--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 9, 2017 at 8:14 am

#1967389
RE: How Large is a Table?

George Vobr - Thursday, November 9, 2017 7:45 AM
Thanks for this question. I also learned how SQL Server 2016 memory-optimized tables support...
--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 9, 2017 at 7:52 am

#1967385
RE: The Importance of Clear Data Displays

kevaburg - Thursday, November 9, 2017 6:58 AM
Jeff Moden - Monday, November 6, 2017 5:38 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)

November 9, 2017 at 7:50 am

#1967383
RE: Is it a duplicate Index?

By the same token, there is a type of duplicate index that can provide huge performance increases. They usually (but not always) are considered to be
"Covering Indexes". 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 9, 2017 at 7:41 am

#1967373
RE: How Large is a Table?

Insufficient info given on the explanation of the answer. You need to tell the people what those 7 bytes 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)

November 8, 2017 at 10:32 pm

#1967293
RE: Trying to speed up this 'GetWorkingDays' function.

By the way... for those interested in batch runs, the inline code I wrote avoids the Cartesian Product altogether and only reads what necessary from the Calendar table.
--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 8, 2017 at 10:27 pm

#1967292

Viewing 15 posts - 13,771 through 13,785 (of 59,101 total)