Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,826 through 51,840 (of 59,091 total)

RE: Help with Year calculations

alorenzini (3/13/2008)
Well it came down that I need to have up to the minute:
02/29/2008 11:59:59 PM
So when I run this:
SET @MonthStartDt = DATEADD(month, DATEDIFF(month, 0, @StartDate), 0)
Set @MonthEndDt = DATEADD(month,...
--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 13, 2008 at 9:55 am

#789173
RE: Combining Columns into one output field?

Heh... it's 'cause I copied directly from your 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)

March 13, 2008 at 9:51 am

#789169
RE: I got burned today at a SQL Server Interview!

Oh boy! Someone said "Pork chop"! Let me get my magic sling... 😀
--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 13, 2008 at 9:50 am

#789168
RE: how to recover deleted database objects

Heh... it's what separates all these "Hi, I'm new to DBA" people from the real DBA's.
--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 13, 2008 at 9:48 am

#789166
RE: TempDB - very large

The real users will show up at your desk in a panic... have the porkchops ready... 😀
--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 13, 2008 at 9:46 am

#789162
RE: create temp view

Folks, just to be clear, you might be able to create a permanent view on the fly and drop it at the end of the proc, but there is no...
--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 13, 2008 at 9:43 am

#789159
RE: create temp view

John Mitchell (3/13/2008)
Jeff Moden (3/13/2008)
No... no way to create a temp view. Creating a TempTable to hold what the TempView would have contained is the next best thing 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 13, 2008 at 9:38 am

#789155
RE: TempDB - very large

Matt Miller (3/13/2008)
the process requiring that space would have aborted.
That would also make it easier to find... dummy that did it would scream out loud 😀
--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 13, 2008 at 8:09 am

#789075
RE: Combining Columns into one output field?

... or, you can just use the power of UNION...
SELECT customer1
from yourtable
where customer1 like 'sm%' UNION
SELECT customer2
from yourtable
where customer2 like 'sm%' UNION
SELECT customer3
from yourtable
where customer3 like 'sm%'
Real key...
--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 13, 2008 at 8:05 am

#789067
RE: Batch Cost & Actual Time

Lynn Pettis (3/13/2008)
Again, the cost is relative to the batch its self, and it is quite possible that the cost of the query (relative to the batch) is higher.
I've found...
--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 13, 2008 at 8:01 am

#789057
RE: Can a temporary table created with an execute statement survive that statement?

Matt Miller (3/12/2008)
Jeff Moden (3/10/2008)
Giving away a fine "secret" here, but no one's ever heard of temporary stored procedures? Build it using dynamic SQL... execute it... it's all in...
--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 13, 2008 at 7:58 am

#789052
RE: Can a temporary table created with an execute statement survive that statement?

Yes... same problem as with Global Temp Tables... if same job runs more than once, BOOM on table creation or YECH on what happens to the data because 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)

March 13, 2008 at 7:54 am

#789046
RE: Renaming all tables in a Database

Do a Google search for sp_MSForEachTable...
--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 13, 2008 at 7:39 am

#789032
RE: Linking to the Previous Row

Jack Corbett (3/13/2008)
Nice article. I like the fact that is clearly takes you from start to finish and offers a solution to a commonly encountered problem.
Agreed... and test data...
--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 13, 2008 at 7:35 am

#789029
RE: Batch Cost & Actual Time

I have sp2 installed and I noticed the same thing an a good number of queries that end up using a loop join...
I've never trusted % if batch, anyway......
--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 13, 2008 at 7:31 am

#789026

Viewing 15 posts - 51,826 through 51,840 (of 59,091 total)