Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,186 through 37,200 (of 59,098 total)

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
RE: Sql tables for all countries States and Cities

RBarryYoung (3/8/2010)
You should be aware that although no City in the U.S. that I know of crosses state lines, some may effectively cross county lines, and many cover more than...
--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:22 pm

#1210063
RE: TSQL copy data in weekdays

zawhtway (8/21/2010)
Hi,
I am very new and never write a TSQL code before. I started learning from yesterday.
I have those tables.
Holiday
- HolidayDate
All...
--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:18 pm

#1210062
RE: Dates from Calendar control

veera.1255 (8/21/2010)
HOW MANY ACCOUNTS CAN U CREATE IN SSRS
My recommendation is that you start a new thread for that question. More people will see 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)

August 21, 2010 at 1:16 pm

#1210061
RE: if Tempdb is full? what we have to do

Interview question? Homework?
--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:15 pm

#1210060

Viewing 15 posts - 37,186 through 37,200 (of 59,098 total)