Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,306 through 19,320 (of 59,098 total)

RE: Leave Developers Alone

Wayne West (11/2/2015)
ArmenStein (10/29/2015)
I wrote an article called The Cone of Silence. We use it at our company, and it really helps to get stuff done.
Excellent article and idea,...
--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)

November 2, 2015 at 1:23 pm

#1837198
RE: A Tale of Partition Schemes and Disappearing Dragons

g.britton (11/2/2015)
nicolas_johnson 52979 (11/2/2015)
Another approach is to use views to alternate source tables by updating the view at the end of the load procedure to point at the last updated...
--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)

November 2, 2015 at 11:35 am

#1837162
RE: A Tale of Partition Schemes and Disappearing Dragons

I loved the implications of being "fired". 🙂
Great article that explains one of the better reasons to partition a table and well done on saving yourself by keeping 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)

November 2, 2015 at 6:50 am

#1837058
RE: Need help to built Insert statement into Table

I agree with Serg. The rCTE method seems appropriate here. I'd lose the DISTINCT, though. Ostensibly, the child ID's are unique already.
Shifting gears a bit, if 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)

November 2, 2015 at 6:32 am

#1837041
RE: Are the posted questions getting worse?

spaghettidba (11/2/2015)
SQLRNNR (10/31/2015)
For thread posterity: [/snip]
Great picture!
It was fantastic meeting you guys!
BTW, Wayne is as tall as me, so he's the giant 🙂
Yeah but he's 6 inches taller than...
--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)

November 2, 2015 at 5:57 am

#1837035
RE: Query on a large database

It's a funny and sometimes stupid thing at work. Everyone is required to NOT keep emails over a year and so they setup automatic deletions. It almost killed...
--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)

November 1, 2015 at 9:10 pm

#1836974
RE: Ways to improve record deletion speed

Mike Good (10/16/2015)
FWIW - We have successfully used same method proposed by Kristen-173977 for many years, for both batched DELETEs and UPDATEs. The only difference is we explicitly CREATE...
--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)

November 1, 2015 at 7:54 pm

#1836968
RE: Best Practice use of Synonyms to reference Other-Database Tables

Kristen-173977 (10/31/2015)
I'd still like MSSQL to have a Database Synonym/Alias feature ...
In the APP code I had to change
CREATE VIEW MyView
AS
SELECT Col1, Col2, ...
FROM [highlight="#ffff11"]VendorName.dbo.[/highlight]SomeTable
to
CREATE VIEW MyView
AS
SELECT Col1, Col2, ...
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)

November 1, 2015 at 7:46 pm

#1836966
RE: secondary DB for reporting , which is the best solution ?

Duplicate post. Please see the following original post to post your answers so we can keep them all together.
http://www.sqlservercentral.com/Forums/Topic1732694-2799-1.aspx
--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)

November 1, 2015 at 7:37 pm

#1836964
RE: Query on a large database

GilaMonster (11/1/2015)
Jeff Moden (11/1/2015)
The only reason to partition is to reduce index maintenance and, possibly (it worked great for me at work), to reduce backup times on temporally based tables...
--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)

November 1, 2015 at 7:31 pm

#1836963
RE: Query on a large database

Sergiy (11/1/2015)
GilaMonster (11/1/2015)
Also fast data loads, fast deletes, aka the sliding window.
The thing is - correct cluster index eliminates the necessity for a sliding window altogether.
I'll have to say "It...
--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)

November 1, 2015 at 7:29 pm

#1836962
RE: Best solution for reporting on a secondary server

I can't implement transactional replication since it works only for tables with primary keys .
That's not just a problem with transaction replication. That's one of those basic "code smells"...
--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)

November 1, 2015 at 5:47 pm

#1836956
RE: Need help to built Insert statement into Table

If you'll never have more than two levels, the following SQL will do as you ask (GREAT JOB on providing test tables and data... thanks)...
INSERT INTO dbo.myInsertedMenu
...
--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)

November 1, 2015 at 5:36 pm

#1836955
RE: Query on a large database

Sergiy (11/1/2015)
Not to mention another "little" problem with partitioning:
Msg 7736, Level 16, State 1, Line 2
Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition...
--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)

November 1, 2015 at 2:30 pm

#1836947
RE: Query on a large database

Thanks he confirmation, Sergiy,
Just to put a wrapper on this, I ran the following code to test for writes with the understanding that I've only got one disk on my...
--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)

November 1, 2015 at 1:58 pm

#1836944

Viewing 15 posts - 19,306 through 19,320 (of 59,098 total)