Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,686 through 23,700 (of 59,102 total)

RE: First SQl job were you nervous?

thomashohner (5/9/2014)
Well I finished my Interview with the Director of Programing. He said no further interviews were necessary and that he would be drafting a proposal for employment. 😀 I'm...
--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)

May 10, 2014 at 8:15 pm

#1712429
RE: Is a SQL View the fastest way to manage multiple count fields, or does SQL 2014 have something better ?

If you want real performance, I'd recommend that you stop counting altogether. Indexed views have an overhead on inserts in that they have to recalculate the totals for 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)

May 10, 2014 at 8:10 pm

#1712427
RE: Is a SQL View the fastest way to manage multiple count fields, or does SQL 2014 have something better ?

[font="Arial Black"]WHY[/font] are you returning 600K rows to begin with???:blink: And [font="Arial Black"]WHERE [/font]are you returning them to? :unsure:
--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)

May 10, 2014 at 10:36 am

#1712397
RE: Is there any way to improve statistics on a table like this?

First, please don't post a thousand rows in a code window. It drove even my 4 processor 6GB ram laptop a little nuts because of the "prettifier" that 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)

May 10, 2014 at 9:54 am

#1712394
RE: need Guidence for SQL DBA Certification

To add to what Luis suggested, buy a copy of the SQL Server Developer Edition and try everything in the book... literally.
--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)

May 9, 2014 at 5:33 pm

#1712354
RE: partitioning a large dimension?

Except for the dr_sk column, I don't see any other unique indexes on this table and that's a good thing for paritioning-sake.
What's the nature of the dr_frdatetime_hq column?
1. Is it...
--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)

May 9, 2014 at 10:24 am

#1712264
RE: partitioning a large dimension?

Can you post the CREATE TABLE statement (including indexes, keys, FKs)? That might help a bit here.
Just so you know, partitioning a table that has other tables pointing 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)

May 9, 2014 at 8:36 am

#1712209
RE: partitioning a large dimension?

GavD (5/9/2014)
The SQL CAT team's recommendation is to [font="Arial Black"]avoid partitioning dimension tables[/font]: http://blogs.msdn.com/b/sqlcat/archive/2013/09/16/top-10-best-practices-for-building-a-large-scale-relational-data-warehous.aspx
I have inherited a dimension table that has almost 3 billion rows and is 1TB and been...
--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)

May 9, 2014 at 8:14 am

#1712196
RE: Cursor from variable

Just remember that if you use a GLOBAL cursor, there could be a serious amount of contention between concurrent runs.
p.s. I love the tagline in your signature! 🙂
--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)

May 9, 2014 at 8:06 am

#1712191
RE: Please help me to write trigger for update on single column

@Bals.Prasanna,
Howdy.
I'm not sure that I remember how to write Oracle triggers (they're single row based and then powered by a FOR EACH ROW for sets of rows) but I can...
--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)

May 9, 2014 at 7:59 am

#1712186
RE: Please help me to write trigger for update on single column

Sean Lange (5/9/2014)
Despite the fact that you are working with Oracle I would highly recommend you read up on normalization. The structures you presented need some serious help with normalization....
--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)

May 9, 2014 at 7:56 am

#1712182
RE: t-sql load values from stored procedure into a temp table

wendy elizabeth (5/8/2014)
I would like to know if the following sql can be used to obtain specific columns from calling a stored procedure with parameters:
/* Create TempTable */
CREATE TABLE #tempTable...
--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)

May 8, 2014 at 3:38 pm

#1712023
RE: correpted mdf file

spaghettidba (5/8/2014)
I hope you noticed that this thread is 5 years old.
So was that post. 🙂
--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)

May 8, 2014 at 9:01 am

#1711903
RE: Deleting records from a large table

Is there a column that could be used as a PK on the 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)

May 8, 2014 at 8:55 am

#1711902
RE: trigger to audit

J Livingston SQL (4/6/2014)
/*possible proof of concept when applied to wide tables*/
/*response to Jeff's comments
"Also, because you have to make a copy of both the INSERTED and DELETED logical trigger...
--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)

May 7, 2014 at 9:30 pm

#1711740

Viewing 15 posts - 23,686 through 23,700 (of 59,102 total)