Jeff Moden

Forum Replies Created

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

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
RE: CPU Spikes Caused by Periodic Scheduled Jobs

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 40% of ALL 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)

December 20, 2016 at 9:07 pm

#1919074
RE: SQL Reproting Failed to query

Since you can't provide us with the queries to even try to help, then there's only one option. Instead of going through all of this yourself, get a hold...
--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 20, 2016 at 8:52 pm

#1919073
RE: IF Exist Delete file and copy a Template File VB.NET Script Task

Welsh Corgi (12/20/2016)
Command Task?
No... sorry. I meant EXEC Task but, like it says on one of the other two posts on this subject, a File System Task is probably...
--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 20, 2016 at 2:14 pm

#1919033

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