Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,411 through 19,425 (of 59,098 total)

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
RE: need to convert string to datetime datatype in DFT

Not sure about SSIS but it's mostly a breeze in T-SQL.
SELECT CAST(CAST(20151020 AS CHAR(8)) AS DATETIME)
--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 21, 2015 at 4:15 pm

#1834791
RE: Query on a large database

Jayanth_Kurup (10/20/2015)
with 100 million rows your better off using a Columnstore index or moving the table to SSAS. If the report requires data on a monthly basis partitioning it by...
--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 21, 2015 at 10:13 am

#1834722
RE: The Poor Soul

From the article
"So Steve, what would you recommend then for those poor souls? As being one of them it drives me nuts to constantly be told I can't get...
--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 21, 2015 at 8:24 am

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

Jayanth_Kurup (10/20/2015)
It doesnt 🙂 i figured the random data is generated row by row and not from a set
Even then, the set based method will work for a single...
--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 21, 2015 at 7:58 am

#1834677

Viewing 15 posts - 19,411 through 19,425 (of 59,098 total)