Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,696 through 22,710 (of 59,067 total)

RE: Need help in Generating Weekly Trading Report for each trader

ramineni.suresh661 (9/23/2014)
Hi Jack ,
Thank you very much for your response , your example solved my issue
Do you understand how it works so you can support it in the future?
--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)

September 23, 2014 at 8:48 pm

#1747708
RE: Select Parent and Child with HiearchyID

udaaf (9/8/2014)
@Eirikur Eiriksson,
Thanks for your respond. It's work :-).
Could you tell me the great article or book for learn HierarchyID. Because I found some query for solved my problem. 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)

September 23, 2014 at 8:27 pm

#1747703
RE: Export to CSV and email

Frank Cazabon (9/18/2014)
Jeff Moden (9/17/2014)
If you don't mind using SSIS, here's one way... just "skip the zip"...
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/
Thanks Jeff,
maybe I should have mentioned the client only has SQL Express 2012....
--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)

September 23, 2014 at 8:21 pm

#1747702
RE: Export to CSV and email

jacksonandrew321 (9/17/2014)
Hi Jeff,
What should I do if we have to deal with Multi-part MIME messages?
To be honest, I have no idea on that. I've never tried such a thing.
--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)

September 23, 2014 at 8:18 pm

#1747701
RE: Another Way to Look at Trees

kevriley (9/16/2014)
I'm glad Jeff Moden has pitched in here.
I've been using a lot of hierarchical data in a current project, and Jeff's articles have helped immensely. I really do...
--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)

September 23, 2014 at 7:46 pm

#1747698
RE: Another Way to Look at Trees

fregatepllada (9/16/2014)
Jeff Moden (9/15/2014)
fregatepllada (9/14/2014)
Larry - are you aware that since SQL Server 2008 R2 there is a data type HierarchyID?
If you using anything older than that version there 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)

September 23, 2014 at 7:43 pm

#1747697
RE: Can we run index rebuild in standard edition

naga.rohitkumar (9/22/2014)
suppose if we need to Rebuld or Reorg index how will we come to know which one to select and at which sitiuation can you please ellobarate
As with 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)

September 22, 2014 at 8:26 pm

#1747278
RE: how will you come to know which index is missing in a table of sqlserver 2005

Rather than me regurgitating what has already been written, open up "Books Online" (the Help system for SQL Server) and lookup "Missing Indexes". Make sure that you understand 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)

September 22, 2014 at 8:21 pm

#1747277
RE: Premature Optimisation

Outstanding article, Gail. I especially appreciate the section of the article on what pre-optimization is not. Very well done and thanks for taking the time to write 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)

September 22, 2014 at 8:26 am

#1747104
RE: Performance tuning it so critical can any one plz figure it out urgent

Open the Object Explorer, connect to the instance, right click on the instance, select "reports", follow your nose. If the server is so locked up that doesn't work, then...
--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)

September 19, 2014 at 4:58 pm

#1746843
RE: Nvarchar Time Calculation

The problem with DATEDIFF is that it's sensitive to temporal borders. For example, the following two times are only 3 milliseconds apart but the DATEDIFF for hours between 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)

September 19, 2014 at 4:20 pm

#1746838
RE: No Compelling Reason

From the article:
We often install the latest version for new instances, often because that's the only version we can buy at the time. However we don't seem to upgrade older...
--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)

September 19, 2014 at 4:00 pm

#1746837
RE: Daily CSV import to SQL - How ?

P Jones (9/19/2014)
Jeff Moden (9/17/2014)
P Jones (9/17/2014)
...and wait until it is fully available ....
I'm curious. What are you using to determine that a file is done being written 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)

September 19, 2014 at 8:35 am

#1746737
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

gorr-688214 (9/19/2014)
Jeff,
This was timely as we are working on a tree just like this. I'm curious what you think about replacing the SortPath with a hierarchyid data type?
Glenn
Hi Glenn,
Thanks...
--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)

September 19, 2014 at 8:32 am

#1746736
RE: Importance of RAM for SQL Server 2008 (does bus speed matter?)

ScottPletcher (9/18/2014)
Jeff Moden (9/18/2014)
ScottPletcher (9/18/2014)
CPU is typically not the bottleneck nowadays, I/O is. More RAM = bigger buffers = less I/O. Thus, RAM will typically be much more...
--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)

September 18, 2014 at 9:08 pm

#1746581

Viewing 15 posts - 22,696 through 22,710 (of 59,067 total)