Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,391 through 18,405 (of 59,102 total)

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

ben.brugman (2/18/2016)
This is a very sensible remark, but why not use 9000-01-01. This contains more 'zero's' so to me it is more logical :-).
Only because SQL Server implicitly converts 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)

February 18, 2016 at 1:23 pm

#1859681
RE: Using Parameters in a Query is Killing Performance

Loner (2/18/2016)
We purchase the software for our company and we cannot just update the database and create index.
I'll ask again...
Jeff Moden (2/17/2016)
Loner (2/17/2016)
Ok, I give up, someone please help! We...
--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)

February 18, 2016 at 9:03 am

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

ben.brugman (2/18/2016)
Jeff Moden (2/16/2016)
ben.brugman (2/16/2016)
Still working on situations where we want to select a specific period and subscribers at that moment.
Please see the following article for that...
Did read your article....
--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)

February 18, 2016 at 9:00 am

#1859608
RE: How to query a Denormalised table

sushantkatte (2/16/2016)
I am a newbie in sql. recently i came across a set of questions specific to query a denormalised table. Can someone help me how to answer these questions
Customer_id...
--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)

February 17, 2016 at 8:11 pm

#1859448
RE: Using Parameters in a Query is Killing Performance

Loner (2/17/2016)
Ok, I give up, someone please help! We have a query that runs just fine with hard coded values but once we swap them out for parameters the 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)

February 17, 2016 at 7:49 pm

#1859447
RE: Converting Rows into columns issue

adhikari707 (2/17/2016)
Thanks for providing the solution.
will keep in mind next time how to post questions on a forum to get the best help.
You bet. Thank you for...
--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)

February 17, 2016 at 4:35 pm

#1859415
RE: SQL Performance Elevenses

Gary Varga (2/17/2016)
Jeff Moden (2/16/2016)
Gary Varga (2/16/2016)
Always run regular automated performance tests
This is the one I find the hardest sell in development. It takes both time and resources but though...
--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)

February 17, 2016 at 6:37 am

#1859237
RE: Database design to merge many different product databases into a single database

@Muhanned,
I agree with Ed. I ran you through the whole gambit and you've not only stuck to your guns but you clarified what you did to try to make...
--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)

February 16, 2016 at 11:57 pm

#1859182
RE: Converting Rows into columns issue

adhikari707 (2/16/2016)
Hi ,
I need help in a scenario that i am working on where i have to convert rows to columns , i tried using pivot function...
--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)

February 16, 2016 at 10:03 pm

#1859170
RE: Reports taking too much time from application

EasyBoy (2/16/2016)
We have few (2-3) reports which are run by users through application everyday in the morning.
Through SQL profiler i found those queries (dynamic SQL), which are running through SQL...
--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)

February 16, 2016 at 8:52 pm

#1859162
RE: SQL Performance Elevenses

Gary Varga (2/16/2016)
Always run regular automated performance tests
This is the one I find the hardest sell in development. It takes both time and resources but though it can highlight killer...
--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)

February 16, 2016 at 8:47 pm

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

ben.brugman (2/16/2016)
Still working on situations where we want to select a specific period and subscribers at that moment.
Please see the following article for that...
http://www.sqlservercentral.com/articles/T-SQL/105968/
You can easily warp it to make...
--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)

February 16, 2016 at 8:36 pm

#1859158
RE: DBA -tasks and solutions

ramana3327 (2/16/2016)
Hallengren script rebuild/reorg the indexes based on the Index fragmentation %. It has to run everyday
For standard edition doesn't have the option to rebuild the indexes online. So we...
--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)

February 16, 2016 at 5:35 pm

#1859153
RE: SQL Query to Extract after 2nd - in a field

trvlbabie (2/16/2016)
I'm new to this so I wasn't sure - appreciate that you were so patient and helpful...not.
You must like pork chops. 🙂
The following will help. http://bfy.tw/4IPS
--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)

February 16, 2016 at 4:13 pm

#1859145
RE: stored procedure for disabling then enabling indexes

Yes. Just because an index is of the non-Clustered variety, doesn't mean it can simply be disabled without other considerations. For example, if the non-Clustered index is 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)

February 16, 2016 at 8:19 am

#1858991

Viewing 15 posts - 18,391 through 18,405 (of 59,102 total)