Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,896 through 20,910 (of 59,072 total)

RE: Is it worth to pursue a C# cert for a SQL Dev focused career path?

Actually, the latest "fad" is extreme PowerShell knowledge. Throw in some AD and WMI knowledge on top of that an you'll be unstoppable.
BI is in demand, as well, 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)

April 28, 2015 at 10:06 pm

#1794172
RE: Include row values as columns in select query

Thanks for the kudo, Steve.
Here's the link.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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 28, 2015 at 3:12 pm

#1794123
RE: Your Role Is Changing

Eric M Russell (4/27/2015)
OK, I'm sorry for the remark about some users wanting access to the 'SA' account just to feel important.
I wouldn't be. I'm glad that someone 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)

April 28, 2015 at 8:55 am

#1793964
RE: SQL optimization

Luis Cazares (4/27/2015)
As that's a local temp table, couldn't you avoid inserting those rows in the first place? You would save time inserting and deleting.
+1000
--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 28, 2015 at 8:36 am

#1793956
RE: Is it worth to pursue a C# cert for a SQL Dev focused career path?

dominic cloud (4/27/2015)
I have the option to pursue a C# certification through my employer. My intended career path is to primarily focus on being a SQL Developer. 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 28, 2015 at 8:33 am

#1793955
RE: Top expensive queries

Gary Harding (4/28/2015)
...and then there's always SSMS' built-in reports (right-click on the database instance in Object Explorer).
Presumably they do something very similar to Eirikur's query under the hood, but with...
--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 28, 2015 at 8:22 am

#1793948
RE: SQL Send Email - Best solution.

ShuaibV (4/27/2015)
Hello
I wanted to implement the feature to send the email in HTML format from SQL. Which option will be more easy and less resource consumption? Like
sp_send_dbmail...
--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 28, 2015 at 8:15 am

#1793946
RE: What is a "set-based loop?"

You should see what happens when Halloween protection fails on an incorrectly written UPDATE when all of the conditions are just right. It's fairly unpredictable so nearly impossible 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 28, 2015 at 7:40 am

#1793934
RE: What is a "set-based loop?"

Eric M Russell (4/27/2015)
Jeff Moden (4/26/2015)
...
The other type is probably not what most people would expect. R. Barry Young coined the phrase for these "set based loops" (which is...
--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 27, 2015 at 11:08 am

#1793770
RE: Running Balance Updation

vikramchander90 (4/26/2015)
Row_no will be unique if u do group by acct_id otherwise it will not be unique. I have a sno column which will be unique overall. Yes there are...
--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 27, 2015 at 10:44 am

#1793740
RE: What is a "set-based loop?"

Gary Harding (4/27/2015)
Jeff Moden (4/26/2015)
You're seriously aware of one of the more famous Pseudo-Cursors there is... a SELECT that uses a Tally Table.
When I first saw this type of usage...
--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 27, 2015 at 5:37 am

#1793617
RE: Reducing Index Fragmentaion during Inserts

kevaburg (4/26/2015)
Hi Folks,
This is my problem.
We have a database with a table that contains around 180m records. Each day a further 70k are inserted. No records are...
--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 26, 2015 at 10:19 pm

#1793561
RE: Microsoft Exercise

If it weren't so true, it actually would be funny. "Upgrade Tuesdays" seems to occur on the 1st Tuesday of each month. That Thursday after, the folks in...
--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 26, 2015 at 10:16 pm

#1793558
RE: Running Balance Updation

vikramchander90 (4/26/2015)
Hi,
Currently i do not have Primary key defined for table. But i created an index for row_no and account_id column.
Does the Row_No column have only unique...
--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 26, 2015 at 10:05 pm

#1793557
RE: Hi, first post! Interested in "Calls"

rourrourlogan (4/26/2015)
I want to find out the sum of the total new insurance policies quickly, I dont want to have to navigate an entire long list of querys to find...
--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 26, 2015 at 7:21 pm

#1793553

Viewing 15 posts - 20,896 through 20,910 (of 59,072 total)