Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,381 through 19,395 (of 59,072 total)

RE: Query on a large database

Jayanth_Kurup (10/23/2015)
Hi Sergiy
Here is a screen shot with clustered index on the monolithic table on REF_AGE column as requested. Notice that it took 17 sec , just the same...
--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)

October 23, 2015 at 8:19 am

#1835192
RE: Query on a large database

Jayanth_Kurup (10/23/2015)
Here are the scripts , I usually create the video to show the steps to reproduce the issue, mostly for those cases where it more important...
--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)

October 23, 2015 at 8:13 am

#1835186
RE: Query on a large database

Jayanth_Kurup (10/23/2015)
Hi Sergiy
I can demonstrate what I am explaining in my video , no gimmicks just plain tables and rows.If you have a few minutes , please add me on...
--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)

October 23, 2015 at 8:06 am

#1835182
RE: A Simple Formula to Calculate the ISO Week Number

robert.sterbal 56890 (10/23/2015)
Now what happens when a government decides to skip a day...
Then it's no longer "ISO". 😉
What's your real question?
--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)

October 23, 2015 at 8:04 am

#1835180
RE: Export 3 different data records to a flat file

I have no idea how to do this in SSIS because I do these types of things using T-SQL. Hopefully, it might give you an idea.
I would do a...
--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)

October 22, 2015 at 7:49 pm

#1835054
RE: Problem with ALTER TABLE ... SWITCH

Hans Lindgren (10/22/2015)
In SQL Server 2014 (maybe also in earlier versions) SWITCHing unpartitioned tables is easy.
Example:
(Summary: SWITCHing between T1 and T2)
--Table/Index creation
CREATE TABLE [dbo].[T1] ( [A] [INT] PRIMARY KEY);
CREATE TABLE...
--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)

October 22, 2015 at 7:37 pm

#1835053
RE: Query on a large database

Jayanth_Kurup (10/22/2015)
Horizontal table partitioning , link with performance characteristics document below
http://enabledbusinesssolutions.com/blog/does-partitioning-improve-performance/
I could be missing something on that link but it would appear that you've once again written an article about...
--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)

October 22, 2015 at 5:19 pm

#1835047
RE: Are the posted questions getting worse?

Alvin Ramard (10/19/2015)
Jeff Moden (10/18/2015)
I realize this post should probably be under "Jobs" but I thought I'd give the dedicated denizens of the thread first crack at it.
Any "hybrid" DBAs...
--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)

October 22, 2015 at 4:52 pm

#1835046
RE: Concatenate Random Date + Random Time = Error!

Jayanth_Kurup (10/22/2015)
One can always hope 🙂
I wonder if we should test OLTP performance using data sets instead of actual row by row operations that will be encountered in production.
Its one...
--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)

October 22, 2015 at 11:53 am

#1834995
RE: Description of a TempTables

I realize that this is a really old post that I'm answering but, hopefully, it will help make someone's life a bit easier in the future.
Here's the code 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)

October 22, 2015 at 8:37 am

#1834920
RE: Query on a large database

xsevensinzx (10/22/2015)
Only issue is while anything can be preaggregated ahead of time for rapid reporting. The end users in my case have to re-aggregate the data often to try different...
--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)

October 22, 2015 at 7:45 am

#1834896
RE: Query on a large database

xsevensinzx (10/22/2015)
J Livingston SQL (10/20/2015)
sreeya (10/20/2015)
The same Customer may purchase multiple times on the same day plus we have about 100 millions of active users. As I said facts table...
--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)

October 22, 2015 at 7:16 am

#1834881
RE: Contracting and International Travel Fees

Grant Fritchey (10/22/2015)
It has to be in the contract that negotiate with the company. I have three rates, a friend's rate, an at-home rate, and then a travel rate plus...
--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)

October 22, 2015 at 6:45 am

#1834876
RE: Query on a large database

SQLCurious (10/21/2015)
I store my dates as integers (in YYYYMMDD format) and have an index on them. I have another DimDate table that has YYYYMMDD as clustered PK, and the remaining...
--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)

October 22, 2015 at 6:09 am

#1834864
RE: Query on a large database

Jayanth_Kurup (10/22/2015)
Hi Sergiy
Clustered index only works when searching on the key column, it fails for all other DW use cases. A DW doesn't perform seeks it performs scans ( nobody...
--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)

October 22, 2015 at 6:07 am

#1834863

Viewing 15 posts - 19,381 through 19,395 (of 59,072 total)