Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,896 through 23,910 (of 59,099 total)

RE: Write for SQLServerCentral

I'll also add that if you've never written an article before or if you want some good examples of articles, click on "Articles" on the left side of your screen...
--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 10, 2014 at 11:20 am

#1704992
RE: How to optimize correctly 20 indexes ?

Working from the bottom up on your response...
Understood on the "Divide by one" thing. Parameterising that and using "1" for that particlular situation makes your code a lot easier...
--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 10, 2014 at 9:54 am

#1704960
RE: Format results as HTML table w/ powershell

Thanks, Alan.
Correct me if I'm wrong... on the SQL Agent side of the house that you mentioned, if the PoSH code connects to the SQL server, wouldn't 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)

April 10, 2014 at 9:17 am

#1704945
RE: Does anyone care that I passed 70-461?

j.b.shteyn (4/9/2014)
lptech (4/9/2014)
So I gave them a quick spiel about creating clustered indexes on the column they join on most frequently and non-clustered on columns in where clause, looking at...
--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 10, 2014 at 9:07 am

#1704940
RE: Format results as HTML table w/ powershell

That's awesome but my question still remains. What are you good folks using to schedule the runs?
--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 10, 2014 at 8:33 am

#1704918
RE: Does anyone care that I passed 70-461?

j.b.shteyn (4/9/2014)
Hey all,
I decided to do a serious career turn about and get back into Comp Sci (which I started in undergrad 15 years go, but switched to Soc Sci).
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)

April 9, 2014 at 9:30 pm

#1704742
RE: If or When?

Added "security" is a mixed blessing. I've found that instead taking the time and expense of hardening features, some folks sometimes just make them go away.
--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 9, 2014 at 9:00 pm

#1704738
RE: Are majority of the developers still using printed books for study and learning or they shifted to e-books

I voted "other" because I don't just use books to learn from. I write code and try new things out.
As for the books themselves, I love 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 9, 2014 at 8:56 pm

#1704737
RE: Lobbying for Change

Eric M Russell (4/9/2014)
In Washington D.C., lobbyists use money, sex, and three martini lunches to promote their cause and grease the skids. Can we do that with Microsoft? 🙂
BWAAA-HAAA!!!! I'd...
--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 9, 2014 at 8:44 pm

#1704733
RE: How to optimize correctly 20 indexes ?

If you want to keep the table as the same denormalized structure, change the clustered index to be on CellX, CellZ, and YPID. Notice I didn't say change the...
--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 9, 2014 at 8:35 pm

#1704732
RE: Stopping a check integrity DB job what will happen?

Grant Fritchey (4/9/2014)
Rebuilding an index online means it will absolutely be accessible. An index rebuild without the online option will block access while the rebuild occurs. It's a bit 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)

April 9, 2014 at 5:35 pm

#1704720
RE: CSV file to table

herladygeekedness (4/8/2014)
I have often had a user adamant that what they provide is "good enough" so if you meet with resistance ...
Heh... I love users like that. They're...
--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 9, 2014 at 5:26 pm

#1704718
RE: Import Excel Data into SQL Table - Fails because of CR/LF

Thomas Ashby (4/9/2014)
I need to import several Excel Worksheets into SQL tables for processing, after which I will need to export to CSV files to load back into the Excel...
--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 9, 2014 at 5:13 pm

#1704717
RE: Restrict Implicit Conversion.

All good suggestions. My favorite, though, is to put the hammer on the 3rd party providing the data and get them to clean up their act.
--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 9, 2014 at 4:59 pm

#1704715
RE: Find and Replace Injection String in Server 2005

allaspects (4/9/2014)
Lynn is obviously trolling. Sad that on a resource such as this website, someone is out to troll and not help.
That's why the world can't have nice things.
From where...
--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 9, 2014 at 3:47 pm

#1704709

Viewing 15 posts - 23,896 through 23,910 (of 59,099 total)