Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,856 through 9,870 (of 59,099 total)

RE: Level 1: The Basic SELECT Statement

Good lord. I clicked on the link and it took me to codeplex, which says that it "is still available" if you click on a certain link which takes 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)

February 6, 2019 at 11:28 pm

#2021342
RE: Tuning Query In Stored Procedure

Grant Fritchey - Wednesday, February 6, 2019 6:22 AM
jkramprakash - Wednesday, February 6, 2019 6:16 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)

February 6, 2019 at 11:06 pm

#2021341
RE: Backup and log

p.s. If you can take advantage of some of the tricks I talked about including using ONLINE = OFF, your 7.5GB index should take about 43 seconds per REBUILD (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)

February 6, 2019 at 10:25 pm

#2021340
RE: Backup and log

mdube 62615 - Tuesday, February 5, 2019 9:11 AM
Jeff Moden - Tuesday, February 5, 2019 8:50 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)

February 6, 2019 at 10:21 pm

#2021339
RE: Easy (I think) mdf file size question

Despite the apparent knee jerk reactions by some in the face of large MDFs, Eddie is spot on.
I'll also state that a whole lot of data is "W.O.R.M"...
--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)

February 6, 2019 at 9:49 pm

#2021338
RE: Level 1: The Basic SELECT Statement

imaaronacs - Wednesday, February 6, 2019 7:42 PM
Hello, I started working on this staircase and noticed the AdventureWorks database was used during...
--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)

February 6, 2019 at 8:53 pm

#2021335
RE: Best way to track "errors" in Stored Procedure

Matt Miller (4) - Wednesday, February 6, 2019 12:39 PM
Jeff Moden - Tuesday, February 5, 2019 6:08...
--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)

February 6, 2019 at 12:58 pm

#2021317
RE: A Tiny Trauma

BarneyL - Wednesday, February 6, 2019 7:27 AM
If space were an issue there's always row\page compression which would give you variable length...
--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)

February 6, 2019 at 11:53 am

#2021298
RE: Which years are similar.

I took a slightly different approach. While solving the original problem certainly has merit, I can also foresee people wanting to solve problems like "Show me all years that begin...
--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)

February 6, 2019 at 10:00 am

#2021284
RE: Sort already comma separated list

Almost forgot, Joe. If you want to see how what you're calling "God Numbers" are being used and why they're important, then just click on the following Microsoft article. Once...
--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)

February 5, 2019 at 7:39 pm

#2021232
RE: Best way to track "errors" in Stored Procedure

rocky_498 - Tuesday, February 5, 2019 8:50 AM
Hi Guys,
I need advice. I have almost 30 Update statements with different logic 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)

February 5, 2019 at 6:08 pm

#2021231
RE: Sort already comma separated list

jcelko212 32090 - Tuesday, February 5, 2019 2:53 PM
Jeff Moden - Monday, February 4, 2019 2:28 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)

February 5, 2019 at 6:05 pm

#2021230
RE: sql time attendance queries from access control db

markrj89 - Monday, February 4, 2019 1:04 PM
Good Day
I am very new to SQL and am looking for some help to get me...
--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)

February 5, 2019 at 8:55 am

#2021173
RE: Backup and log

mdube 62615 - Tuesday, February 5, 2019 5:51 AM
OK I have found what makes the log grow; it's our weekly index optimization...
--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)

February 5, 2019 at 8:50 am

#2021171
RE: MySQL

ben.brugman - Tuesday, February 5, 2019 1:49 AM
Hello Community,
It is my opinion that I have some SQL and SQLserver skills. Apart from...
--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)

February 5, 2019 at 8:48 am

#2021170

Viewing 15 posts - 9,856 through 9,870 (of 59,099 total)