Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,156 through 37,170 (of 59,072 total)

RE: tsql retrieve records on date

Ah... apologies. I see that Remi already posted such a comment. I've really got to learn to read a whole thread before posting.
--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)

August 22, 2010 at 7:49 pm

#1210194
RE: tsql retrieve records on date

Kingston Dhasian (8/22/2010)
One more solution to your problem
SELECT * FROM holidays WHERE DATEDIFF( DAY, freedate, GETDATE() ) = 0
The below mentioned article might be helpful to you
http://www.sqlservercentral.com/articles/T-SQL/65806/
Ummm... no. Sorry,...
--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)

August 22, 2010 at 7:48 pm

#1210193
RE: array & multilist

harshinderkaur (8/22/2010)
the syntax for using array & multilist as given in d dbms book korth does NOT 🙁 work in mysql or in msql 2000. anyone has any idea how...
--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)

August 22, 2010 at 7:41 pm

#1210192
RE: Disk configuration for TempDB

If TempDB is "used heavily" as you say, then a spindle per CPU would be really good but... the big thing is to get that log file off those disks...
--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)

August 22, 2010 at 7:38 pm

#1210191
RE: help needed in code tuning.

WayneS (8/22/2010)
And we know that Jeff doesn't want any pork chops aimed at him! :w00t:
Z'actly. I'm busy enough launching them. I don't have time to watch for incoming....
--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)

August 22, 2010 at 7:27 pm

#1210189
RE: Last Day of Month subscription for Shared SSRS schedule

SqlServerLover (8/22/2010)
Can't you just run on the 1st day of the month at 12 am?
This is how i have done as a solution of this problem .
In my company, there...
--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)

August 22, 2010 at 7:20 pm

#1210187
RE: help needed in code tuning.

Heh... I'm one of those people that hate the "just do what I say" line. That's a 6 pork chop offense in my book.
--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)

August 22, 2010 at 7:05 pm

#1210186
RE: help needed in code tuning.

GilaMonster (8/22/2010)
Jeffrey Williams-493691 (8/22/2010)
I recall the same thing - and I don't have the reference either. But, it is related to how you write your queries. In 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)

August 22, 2010 at 5:27 pm

#1210178
RE: help needed in code tuning.

Ninja's_RGR'us (8/22/2010)
I see your point. My own pers. favorite has always been to use table aliases and using it on the columns, even with only 1 table in 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)

August 22, 2010 at 5:20 pm

#1210177
RE: Do you advise to apply Recomendations given by DTA?

I'm pretty sure that statistics TIME and IO don't include SQLCLR and I believe they sometimes miss what's happening in UDF's that a query may contain. I'll have 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)

August 22, 2010 at 5:17 pm

#1210175
RE: help needed in code tuning.

Ninja's_RGR'us (8/22/2010)
Here's a weird idea, start worrying about it when you plan to move to sql 201? and having the upgrade advisor throwing errors and warnings.
In the mean...
--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)

August 22, 2010 at 1:49 pm

#1210146
RE: Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

wardster (8/21/2010)
Hi Jeff
Thanks for the quick reply.
The solution I'm in the middle of testing uses a permanent staging table rather than temp table or table variable. Does this mean...
--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)

August 22, 2010 at 1:36 pm

#1210145
RE: TSQL copy data in weekdays

zawhtway (8/21/2010)
Hi,
Here is the code I have done and tested and seems working.
Correct me if something is wrong. I'll have some more to do
use MobilePOD
Declare @chkHoliday int
Declare @chkTomorrow int
declare @DayName...
--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)

August 22, 2010 at 1:29 pm

#1210144
RE: Do you advise to apply Recomendations given by DTA?

GilaMonster (8/22/2010)
SqlServerLover (8/21/2010)
So do i have to apply those indexes in test and find out if performance has improved or not by running those specific query or stored proc 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)

August 22, 2010 at 12:57 pm

#1210142
RE: Do you advise to apply Recomendations given by DTA?

Ditto on Gails recommendation. It will many times recommend indexes that don't do anything for performance at all. Test for performance after any index addition/change.
--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)

August 21, 2010 at 1:26 pm

#1210064

Viewing 15 posts - 37,156 through 37,170 (of 59,072 total)