Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,081 through 16,095 (of 59,101 total)

RE: Parsing paired relationships.

richard.gardner 6009 (12/22/2016)
Hi Jeff,
Here's a sample dataset, my bad, 89,000 is a different number, it's just 50,000 pairs of internal keys.
@chris-2 - Thanks for the offer, appreciated, I'll have...
--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)

December 22, 2016 at 1:56 pm

#1919426
RE: GROUP BY in SQL Server 2014

patrickmcginnis59 10839 (12/22/2016)
Jeff Moden (12/21/2016)
CELKO (12/14/2016)
The order by clause converts the set into a cursor. A cursor is a sequential file structure, which does have an ordering.
No, Sir. 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)

December 22, 2016 at 1:48 pm

#1919425
RE: GROUP BY in SQL Server 2014

Sergiy (12/21/2016)
The source of the error is here:
EXEC sys.sp_spaceused @objname = N'dbo.Tally'
3.6 kb - single page.
Which means there is no actual Index seek, it's full table scan for any query...
--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)

December 22, 2016 at 7:36 am

#1919331
RE: GROUP BY in SQL Server 2014

CELKO (12/14/2016)
The order by clause converts the set into a cursor. A cursor is a sequential file structure, which does have an ordering.
No, Sir. I know what you're trying...
--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)

December 21, 2016 at 8:44 pm

#1919259
RE: SQL 2012: how to parse a text datatype column into many different columns

I know you didn't design this so I'm not mad at you personally but this is yet another bloody application with PII and SSN information in clear text. People...
--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)

December 21, 2016 at 6:43 pm

#1919255
RE: Today's Random Word!

Manic Star (12/21/2016)
drew.allen (12/21/2016)
Manic Star (12/21/2016)
jasona.work (12/21/2016)
Ed Wagner (12/21/2016)
jasona.work (12/21/2016)
Ed Wagner (12/21/2016)
Revenant (12/21/2016)
Gulf
Fishing
Ice
Lake
Huron
Bird
Archeopteryx
Dinochicken
Mmmmm... Lunch!
--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)

December 21, 2016 at 5:50 pm

#1919253
RE: I am very new to SQL

Whether you go for certifications or not, I'd definitely go for being an expert in T-SQL, Table Design, and Index Design before anything else.
--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)

December 21, 2016 at 4:35 pm

#1919250
RE: Reindex DB on regular basis

JasonClark (12/20/2016)
Run an index maintenance process regularly. However, your index maintenance process only rebuild/reorganize the indexes that specifically require it:
http://dba.stackexchange.com/questions/4283/when-should-i-rebuild-indexes
this may help you.
The key here is that most of them...
--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)

December 21, 2016 at 3:29 pm

#1919247
RE: Parsing paired relationships.

richard.gardner 6009 (12/21/2016)
Hey, Jeff Moden, you've taught me a lot over the years (you might not believe it looking at my code :-))...
Thank you for the kind feedback, Richard.
OK, so...
--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)

December 21, 2016 at 11:22 am

#1919211
RE: Why Shouldn't I use Linked server?

SQL Learner - VKG (12/21/2016)
In the nutshell, it is well said above that using Replication or other option is better to be used in place of linked server. Just adding...
--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)

December 21, 2016 at 9:09 am

#1919180
RE: CPU Spikes Caused by Periodic Scheduled Jobs

Igor Micev (12/21/2016)
Jeff Moden (12/20/2016)
Spreading out jobs to avoid spikes is a good idea BUT... the real fact is that even after all you did, you're still taking spikes 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)

December 21, 2016 at 9:05 am

#1919179
RE: CPU Spikes Caused by Periodic Scheduled Jobs

gfish@teamnorthwoods.com (12/21/2016)
Simply combine them into one job, with the contents of all of the current job converted to steps in the single job.
That does make it much more difficult 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)

December 21, 2016 at 9:04 am

#1919177
RE: Why Shouldn't I use Linked server?

Eric M Russell (12/20/2016)
If your application needs to join Customers with PurchaseOrders, and your Customer table on ServerA, and your PurchaseOrder table on ServerB, then that architectural decision itself has...
--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)

December 21, 2016 at 7:42 am

#1919153
RE: Date dimension showing times

richardmgreen1 (12/21/2016)
Thanks Jeff, I'll have a look at that little lot.
There will be a couple of columns I can't make deterministic due to their nature (i.e. the "Is" flags) but...
--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)

December 21, 2016 at 7:39 am

#1919149
RE: How to extract overlapping date ranges from a table of date ranges

High Jason...
Yes. The old article is what I was talking about. Hadn't seen the new one. Unfortunately, I'm like a lot of humans in that if 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)

December 21, 2016 at 7:36 am

#1919148

Viewing 15 posts - 16,081 through 16,095 (of 59,101 total)