Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,886 through 24,900 (of 59,099 total)

RE: Budget for Training

I've been tackling the Powershell Challenge for a little over a month now,
Ok, so let me ask...
1. Is the book any good?
2. Is it any good WRT SQL Server/DBA...
--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)

January 4, 2014 at 12:13 pm

#1677542
RE: Get Previous month data based on condition

sql crazy kid (1/4/2014)
Hello Jeff,
Correct me if any performance hit if i rephrased code as like below .
select
*
from
@MyData
where
EndDate > (DATEADD(dd,-15,@CurrDate)-DAY(DATEADD(dd,-15,@CurrDate))) and
EndDate <= (DATEADD(mm,1,DATEADD(dd,-15,@CurrDate)-DAY(DATEADD(dd,-15,@CurrDate))))
That would be better performance wise but...
--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)

January 4, 2014 at 11:38 am

#1677539
RE: sort by serialcode

sayedkhalid99 (1/3/2014)
what change shall i bring in here so that if the serial don't have any decimal point say , it gives error in left function.
DECLARE @Result TABLE (Serial nvarchar(10),Title...
--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)

January 4, 2014 at 11:24 am

#1677538
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

Lynn Pettis (1/4/2014)
Okay, I was just curious as it is a pet peeve of mine. The semicolon is a statement terminator not a statement begininator.
BWAAA-HAAAA!!!! The use of semicolons...
--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)

January 4, 2014 at 11:04 am

#1677533
RE: Partitioned table

sys.Filegroups may be the simple key for you then. If the filegroup has been "recovered", it'll appear there. It also has a "read only" flag, just in case...
--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)

January 4, 2014 at 10:59 am

#1677531
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

Eirikur Eiriksson (1/4/2014)
Thank you Jeff for a good "filler", there are many cracks "float"ing around when it comes to math and numbers on the platform. It is also far 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)

January 4, 2014 at 10:53 am

#1677529
RE: Get Previous month data based on condition

sql crazy kid (1/4/2014)
Hello,
First i would thank to Michael ,i never known in date function by default 0 treat as beginning of the date[1900-01-01] which drives here to get 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)

January 4, 2014 at 10:40 am

#1677526
RE: Get Previous month data based on condition

born2achieve (1/4/2014)
Hi Jeff,
Thanks for asking this and i understand the concept. going forward i can help someone what i learned.
Excellent. I just wanted to be sure. Thank...
--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)

January 4, 2014 at 10:36 am

#1677525
RE: How to fetch PDF files from a folder and saving it in the database

To add to what Ed posted...
I went through this about a year ago with telephone call recordings. I, too, was well aware of storing larger files on disk instead...
--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)

January 3, 2014 at 11:25 pm

#1677491
RE: NULL value in column using bcp

A NULL value in a CSV file is two delimiters with nothing between them. You're not using the actual word 'NULL' in your file are you? Also, do...
--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)

January 3, 2014 at 11:15 pm

#1677490
RE: Partitioned table

NicHopper (1/3/2014)
Hi,
I have a table which is spread over a number of partitions.
Assuming a disaster happens I can quickly restore the most recent partition and everyone can get back 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)

January 3, 2014 at 11:05 pm

#1677489
RE: what performance metrics to show before and after optimization/tuning - to show improvement

VoldemarG (1/2/2014)
question: If I am optimizing performance of a few dozen of SPs that i identified via Profiler Trace as taking most time while being the ones most often executed,...
--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)

January 3, 2014 at 10:33 pm

#1677487
RE: what performance metrics to show before and after optimization/tuning - to show improvement

Ravid_ds (1/3/2014)
You can test by mentioning SET STATISTICS ON/OFF while executing the SP.
Oh be careful now. SET STATISTICS is a known liar when it comes to certain forms...
--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)

January 3, 2014 at 10:24 pm

#1677486
RE: Merry Christmas Everyone :)

bitbucket-25253 (12/24/2013)
For those that want to hear what I want for Christmas ....
http://www.songfacts.com/detail.php?id=9570
Speaking of Christmas, I got a nice present just before the holiday. One of my sessions was...
--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)

January 3, 2014 at 9:13 pm

#1677483
RE: Get Previous month data based on condition

born2achieve (1/3/2014)
Also i verified with my production data and it works perfectly.
Thanks a lot Michael. Appreciate your time on this post.
Now, for the really tough question. Do you understand...
--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)

January 3, 2014 at 8:47 pm

#1677481

Viewing 15 posts - 24,886 through 24,900 (of 59,099 total)