Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,276 through 19,290 (of 59,072 total)

RE: Selecting text between set characters

Ah... almost forgot. It's usually helpful to those trying to help if you provide readily consumable data and a little DDL. Please see the article at the first...
--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:20 pm

#1837245
RE: Selecting text between set characters

les.61 (11/2/2015)
I have a table of data with lines of various lengths. An example is
A Smith - Give #12345# Sydney City
B Jones and S Jones - Give #876543#...
--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:19 pm

#1837244
RE: Find All Items That Call a Stored Procedure

I'd do it the same way as Magoo did it above. Instead of sifting through a pile of manure to try to figure out what the horse was thinking,...
--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:10 pm

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

Constant Coder (11/2/2015)
We had a similar need to do a quick switch between a staging table and a production table, but simply used three table renames to accomplish this. 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 3:30 pm

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

Viewing 15 posts - 19,276 through 19,290 (of 59,072 total)