Jeff Moden

Forum Replies Created

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

RE: How to create a temp table in a procedure rather than usinh INTO #temptable

asita (4/10/2014)
Could somebody please help me, any ideas please...
First, there's no way that I know of to do this and any even educated guess at calculated column widths could easily...
--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 11, 2014 at 8:11 am

#1705312
RE: Why would you create a foreign key and then disable it?

souLTower (4/11/2014)
I have an application that has been around for a long time. Most of the FKs are disabled. referential integrity is being handled through triggers. Why...
--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 11, 2014 at 7:07 am

#1705257
RE: SQL Server 2014 Developer Edition - availability for download ?

Koen Verbeeck (4/2/2014)
Jeff Moden (4/2/2014)
Heh... waiting for SP1. 😉
Good grief, there may be 25 CUs released before they even think about an SP 😉
Heh... gotta give 'em time to 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)

April 10, 2014 at 7:27 pm

#1705091
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

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