Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,596 through 14,610 (of 59,097 total)

RE: Query performance tuning - Slow execution time

Jonathan AC Roberts - Tuesday, August 15, 2017 11:52 AM
With these type of query you can sometimes get a lot of success...
--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)

August 16, 2017 at 6:04 pm

#1955592
RE: Can I restore a single file .mdf to multiple files spread across disks

Arsh - Wednesday, August 16, 2017 1:56 PM
See how much free space you have in the database. If it's huge and if...
--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)

August 16, 2017 at 5:54 pm

#1955591
RE: Stairway to Test Automation and Continuous Integration for Databases Level 1: Why You Need TDD

Duncan A. McRae - Monday, February 29, 2016 12:41 PM
Much time has elapsed. Is this series dead?
Must've been outsourced. 😉
--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)

August 16, 2017 at 7:47 am

#1955484
RE: Hiring Heterogeneously

Nancy.Balcer - Wednesday, July 24, 2013 4:52 PM
Companies run lean, and it seems to me it's more often than not--difficult for analysts...
--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)

August 15, 2017 at 10:08 pm

#1955391
RE: Hiring Guitarists

Andrew..Peterson - Tuesday, August 15, 2017 1:53 PM
Jeff Moden - Monday, August 14, 2017 1:22 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)

August 15, 2017 at 9:38 pm

#1955388
RE: Query performance tuning - taking more than 9 minutes

ffarouqi - Monday, August 14, 2017 10:52 PM
Jonathan AC Roberts - Monday, August 14, 2017 8:42 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)

August 15, 2017 at 7:43 pm

#1955382
RE: Subroutines in TSQL

dmeissner - Monday, August 14, 2017 5:48 PM
Not sure exactly what you are getting at. This is an ad-hoc process that can be used for any schema with minimal tweaking. Schema is relative. The user has asked for an example of how the functionality...
--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)

August 15, 2017 at 7:47 am

#1955290
RE: Microsoft SQL Server Utilities and Tools

robert.sterbal 56890 - Thursday, July 20, 2017 12:31 PM
Jeff Moden - Thursday, July 20, 2017 12:16 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)

August 14, 2017 at 1:49 pm

#1955217
RE: Hiring Guitarists

I still think it's horrible that 20 out of 22 "guitarist" applicants we had don't know what a fret is or where the neck of the guitar actually is.
--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)

August 14, 2017 at 1:22 pm

#1955214
RE: Subroutines in TSQL

dmeissner - Monday, August 14, 2017 7:57 AM
Wow, triggered again.
Heh... nah... just responding to that chip you're carrying. 😉 When you drop it, I'll...
--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)

August 14, 2017 at 1:15 pm

#1955211
RE: Subroutines in TSQL

dmeissner - Monday, August 14, 2017 12:19 PM
I already did.
"I did run across the thread searching for the same thing for an old mssql...
--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)

August 14, 2017 at 1:14 pm

#1955210
RE: Query Plan...

Arsh - Monday, August 14, 2017 3:05 AM
Hi Everybody,
In some query plans we see some iterators have a non-zero cost even when...
--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)

August 14, 2017 at 7:19 am

#1955139
RE: Query performance tuning - taking more than 9 minutes

Ed Wagner - Saturday, August 12, 2017 3:17 PM
ffarouqi - Friday, August 11, 2017 4:43 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)

August 14, 2017 at 6:41 am

#1955130
RE: SQL trigger not firing after moving to new server

rhondamoeller - Sunday, August 13, 2017 8:18 PM
Lost a bit of data, as it was stored in the wrong database, but...
--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)

August 14, 2017 at 6:18 am

#1955128
RE: Hiring Guitarists

seebert42 - Monday, August 14, 2017 5:17 AM
Wow, a four year old rerun. I now understand an interview I had two years...
--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)

August 14, 2017 at 6:12 am

#1955127

Viewing 15 posts - 14,596 through 14,610 (of 59,097 total)