Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,136 through 15,150 (of 59,101 total)

RE: Backup database to disk for insufficient disk space

Check for old backups (according to your DR plan) that can be deleted, as well.
--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)

April 20, 2017 at 3:20 pm

#1939208
RE: Split out a field of comma separated values based on a unique code in the same row.

Trawler - Thursday, April 20, 2017 2:13 AM
Koen Verbeeck - Tuesday, October 21, 2014 4:02 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)

April 20, 2017 at 3:11 pm

#1939206
RE: Byte Me: Functional Fashion

Heh... to coin a phrase...
"It's no longer a matter of how many sticks I have in the fire... It's now a matter of how many fires I have sticks...
--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)

April 19, 2017 at 6:33 pm

#1938996
RE: Replace string

sgmunson - Wednesday, April 19, 2017 2:22 PM
Luis Cazares - Wednesday, April 19, 2017 1:05 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)

April 19, 2017 at 6:26 pm

#1938995
RE: Today's Random Word!

Revenant - Wednesday, April 19, 2017 2:58 PM
ManicStar - Wednesday, April 19, 2017 2:25 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)

April 19, 2017 at 4:27 pm

#1938991
RE: tempdb curiosity

TheSQLGuru - Wednesday, April 19, 2017 8:59 AM
Jeff Moden - Wednesday, April 19, 2017 8:38 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)

April 19, 2017 at 4:09 pm

#1938984
RE: Deadlocks on Clustered Index

Eric M Russell - Wednesday, April 19, 2017 2:16 PM
DesNorton - Wednesday, April 19, 2017 1:45...
--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)

April 19, 2017 at 3:32 pm

#1938975
RE: SQL help - Need to know the first date of previous month and last date of previous month...

mw112009 - Wednesday, April 19, 2017 10:06 AM
Did I pass the test then ?
"It Depends" on the next time you need to...
--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)

April 19, 2017 at 2:35 pm

#1938964
RE: tempdb curiosity

fizzleme - Tuesday, April 18, 2017 4:34 PM
I maintain a sql server 2012 server with 4 tempdb files. The first one 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)

April 19, 2017 at 8:38 am

#1938837
RE: Table size and indexes

Eric M Russell - Wednesday, April 19, 2017 7:02 AM
SQLRNNR - Tuesday, April 18, 2017 1:36 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)

April 19, 2017 at 7:49 am

#1938816
RE: SQL help - Need to know the first date of previous month and last date of previous month...

mw112009 - Wednesday, April 19, 2017 7:10 AM
Phil Parkin - Wednesday, April 19, 2017 6:55 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)

April 19, 2017 at 7:40 am

#1938810
RE: Are the posted questions getting worse?

SQLRNNR - Tuesday, April 18, 2017 1:29 PM
jasona.work - Tuesday, April 18, 2017 1:18 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)

April 18, 2017 at 9:01 pm

#1938712
RE: SQL help - Need to know the first date of previous month and last date of previous month...

SQLRNNR - Tuesday, April 18, 2017 1:14 PM
This thread has gone quite a ways sideway, imo.
Let's try to get this thing turned...
--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)

April 18, 2017 at 8:31 pm

#1938709
RE: Window Function defaults

TomThomson - Tuesday, April 18, 2017 5:29 PM
Jeff Moden - Monday, April 17, 2017 3:37 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)

April 18, 2017 at 8:12 pm

#1938707
RE: SQL Server Telemetry

Eric M Russell - Tuesday, April 18, 2017 7:57 AM
When Microsoft says that they're collecting data just for quality of service purposes...
--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)

April 18, 2017 at 8:06 am

#1938525

Viewing 15 posts - 15,136 through 15,150 (of 59,101 total)