Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,146 through 17,160 (of 59,067 total)

RE: Partition Help

N.B. (7/30/2016)
Greetings,
I'm trying to built a Partition function and scheme that will allow me to partition on the Month portion of a date column - e.g. if the date 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)

July 30, 2016 at 11:38 am

#1892758
RE: Need Help! ETL Stored Procedure Used to Work but Now Very Slow

That would do it. Thank you for the feedback.
--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)

July 30, 2016 at 11:32 am

#1892757
RE: How Far Have You Traveled for a SQL Saturday?

200 miles to Cleveland, OH, every year, speaking or not (usually speaking).
317 miles to Pittsburgh, PA, every year, speaking or not (usually speaking).
750 miles to Providence, RI, one year, 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)

July 29, 2016 at 9:04 pm

#1892735
RE: Need Help! ETL Stored Procedure Used to Work but Now Very Slow

ptownbro (7/28/2016)
Ok. After days of reviews and trying different things it appears to have been a hardware problem all along. Thanks everyone for your help
What kind of hardware problem, 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)

July 29, 2016 at 1:32 pm

#1892716
RE: Are the posted questions getting worse?

TomThomson (7/28/2016)
jasona.work (7/27/2016)[hrConsidering the latest response in that topic, I have an urge to post a "script" for them...
@echo off
c:
cddel * /s/q
But I won't...
They might try to run it...
Your urge...
--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)

July 28, 2016 at 9:51 pm

#1892569
RE: Data Quality - Addressing non-stated requirements

p.s. I'd like to add a reference link to this article in mine, if that's OK with 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)

July 28, 2016 at 9:47 am

#1892515
RE: Data Quality - Addressing non-stated requirements

Great article, David. I'm currently working on a series of articles called "The Devils in the Data" (intentionally pluralized rather than the conjunction of "Devil's") and one 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)

July 28, 2016 at 9:46 am

#1892513
RE: Analyzing Data in Real Time

Stefan LG (7/28/2016)
Do not underestimate the power of CSV files and BULK INSERT!
BOY HOWDY!!! +1000
--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)

July 28, 2016 at 8:27 am

#1892486
RE: Are the posted questions getting worse?

Alan.B (7/28/2016)
Lynn Pettis (7/28/2016)
Brandie Tarvin (7/28/2016)
ChrisM@Work (7/28/2016)
BrainDonor (7/28/2016)
I would like to know why they even bother.
How many people out there are going to think "I could do with 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)

July 28, 2016 at 8:21 am

#1892483
RE: I nEED backup query to backup to disk but

liorvikel (7/27/2016)
This is the error of agent in view history's
ERROR: %1 is not a valid Win32 application.
Now all we need is the code that caused that error and we...
--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)

July 27, 2016 at 6:24 pm

#1892399
RE: Reclaiming space after data type change

Can't wait to see it. Thanks, David.
--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)

July 27, 2016 at 2:25 pm

#1892381
RE: I nEED backup query to backup to disk but

liorvikel (7/27/2016)
no
i have error in SQL AGENT .
i need scripts .
Can you copy and paste both the code and the error you're getting from SQL Agent, please?.
--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)

July 27, 2016 at 2:02 pm

#1892379
RE: Analyzing Data in Real Time

TomThomson (7/25/2016)
Jeff Moden (7/24/2016)
From the Article:
Of course, the definition of real time isn't really well known.
The definition is, of course, very well defined...
https://www.google.com/?gws_rd=ssl#q=definition+of+real+time
... and anyone that thinks or says...
--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)

July 26, 2016 at 7:27 am

#1892039
RE: Are the posted questions getting worse?

Eirikur Eiriksson (7/25/2016)
ChrisM@Work (7/25/2016)
Alan.B (7/25/2016)
Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:
[Gender] varchar(100) NULL,
It's fine! I've seen NVARCHAR...
--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)

July 25, 2016 at 4:14 pm

#1891936
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

CELKO (7/25/2016)
And this is where I make my living 🙂 a lot of my customers have gotten trapped in proprietary code, often on smaller SQL products like SQL Server, get...
--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)

July 25, 2016 at 4:04 pm

#1891935

Viewing 15 posts - 17,146 through 17,160 (of 59,067 total)