Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,196 through 24,210 (of 59,099 total)

RE: Copy file to folder with current date

If you want to avoid PoSH altogether...
http://technet.microsoft.com/en-us/library/cc753551.aspx
--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)

March 11, 2014 at 9:04 am

#1696026
RE: Are the posted questions getting worse?

Luis Cazares (3/10/2014)
Good Monday everyone,
I've been away for a week and seems a lot to me. I moved to a different area in my company and I've been adapting and...
--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)

March 11, 2014 at 12:20 am

#1695814
RE: Are the posted questions getting worse?

Greg Edwards-268690 (3/10/2014)
Luis Cazares (3/10/2014)
Lynn Pettis (3/10/2014)
If any one has some free time this person could use some help. I don't have the free time at the moment.
http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
I've wasted...
--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)

March 11, 2014 at 12:08 am

#1695812
RE: Are the posted questions getting worse?

Sean Lange (3/10/2014)
SQLRNNR (3/10/2014)
Greg Edwards-268690 (3/10/2014)
Koen Verbeeck (3/10/2014)
SQLRNNR (3/10/2014)
errrmmm
http://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
Whoops. Maybe I should send him a consulting offer. 😎
Pretty sad when they want someone to just do their homework.
Almost...
--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)

March 10, 2014 at 11:57 pm

#1695810
RE: Table Partitioning for 500gb in size

aaa121 (3/6/2014)
Hi All,
Really interesting thread. I happen to have just inherited a database which has been thrown together with no filegroups or partitioning and this has a table or 500GB...
--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)

March 10, 2014 at 11:52 pm

#1695809
RE: Table Partitioning for 500gb in size

My apologies. I lost track of this thread.
I'll try to answer both sets of questions that you good folks have answered.
First, FK's that point to the partitioned table require...
--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)

March 10, 2014 at 11:50 pm

#1695808
RE: Index Creation and included columns

GilaMonster (3/10/2014)
Jack Corbett (3/10/2014)
The only benefit to actually listing orderNo in the included list is that, if you ever change the clustered index, you still have 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)

March 10, 2014 at 5:48 pm

#1695790
RE: Displaying Reports by Productname and Region

nandu.chowdary412 (3/10/2014)
Thank you 4r reply..I got the answer now..I have did same thing before but i have used top in my query..
the reason for using top query is i want...
--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)

March 10, 2014 at 5:41 pm

#1695788
RE: Help with hierarchical structure without hierarchical relation field...

PiMané (3/10/2014)
Sean Lange (3/10/2014)
Luis Cazares (3/10/2014)
What happens if a parent needs to have more than 10 children?
Or 99 roots?
I'm with Jeff. If you can't actually properly normalize this data 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)

March 10, 2014 at 5:27 pm

#1695785
RE: Pls let me know how to add image..thanks

koti.raavi (3/10/2014)
Thank your reply..if you can some tips that really helpful to me..thanks anyway for your reply.
You have to at least try. Grab the "report specs" that you're instructor...
--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)

March 10, 2014 at 12:54 pm

#1695710
RE: Help with hierarchical structure without hierarchical relation field...

So, what's going to happen when you have an account number of, say, 112? BOOM!!!
My recommendation would be to correctly split the parent/child relationships into parent/child columns. That...
--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)

March 10, 2014 at 12:51 pm

#1695708
RE: Disk Usage by Top Tables

smthembu (3/10/2014)
Hi All
I have a query to resolve/understand how it all works. I have a table with 363 287 records, with Reserved(KB) 228 652 048, Data(KB) 228 592 480, Indexes(KB)...
--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)

March 10, 2014 at 8:24 am

#1695545
RE: outragous query duration during load

aviadavi (3/6/2014)
Hi,
I'm performing a load test on my SQL server.
I start a load of one main stored procedure in our SQL and after 7 minutes (when it gets to ~2500...
--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)

March 10, 2014 at 8:02 am

#1695532
RE: Sudden PLE Drop Possible Without Memory Pressure?

timothy.lazarus (3/9/2014)
Okay, after reading through everything I could get my hands on regarding SQL memory, I think I've identified the culprit. Per VMware's recommendation, I had enabled large page allocation....
--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)

March 10, 2014 at 7:54 am

#1695526
RE: How to influence others?

The only way to influence those that can be influenced is to be right and to be able to prove it without question. As the old saying goes, 1...
--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)

March 9, 2014 at 11:26 am

#1695382

Viewing 15 posts - 24,196 through 24,210 (of 59,099 total)