Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,241 through 51,255 (of 59,098 total)

RE: Back door on Information_Schema

Matt Miller (4/7/2008)
That level of detail ain't going to help you much.
Matt... thanks for the help. You're right, though... not a big fan of CLRs but could be convinced...
--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)

April 7, 2008 at 6:07 pm

#799486
RE: Back door on Information_Schema

Matija Lah (4/7/2008)
Almost. If there's a view of the same name in the current database then the local view will be used.
Thanks Matija Lah... I agree... that's why it's never...
--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)

April 7, 2008 at 2:49 pm

#799442
RE: Back door on Information_Schema

Matt Miller (4/7/2008)
I know this is a REALLY ugly trick.... put "SP_" as the prefix. by doing that - it will go try to find the view in MASTER....
--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)

April 7, 2008 at 2:47 pm

#799440
RE: How to split cells in table format?

meghna.bhargav (4/7/2008)
In sql , how it can be done?
thanks
Like I said in my previous post, I don't think spreading a single header over 3 columns can be done. I...
--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)

April 7, 2008 at 7:38 am

#799123
RE: How to split cells in table format?

I don't know if it can be done in reporting services... header "cells" would need to be "merged" as if on a spreadsheet. I'm sure it can't be done...
--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)

April 7, 2008 at 7:15 am

#799097
RE: How to split cells in table format?

Sorry... I'm still not getting it and I want to make sure... you posted the following...
for item : A B
...
--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)

April 7, 2008 at 7:00 am

#799085
RE: join problem

Sergiy (4/6/2008)
I once improved responce time of the query from 10 s to under 1 s just by replacing NOT IN with NOT EXISTS.
Don't remember exactly how many rows were...
--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)

April 7, 2008 at 6:52 am

#799079
RE: join problem

rbarryyoung (4/7/2008)
Well, NOT IN has had some bugs in SQL Server 2000, so that is certainly possible. They are mostly cleared up in Sql2005.
What kind of bugs, Barry?
--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)

April 7, 2008 at 6:51 am

#799078
RE: Indexed View Sql Server 2005

You will never get an INDEX SEEK using SELECT *... only index scans.
My most sincere apologies... the comment above does NOT apply to INDEXED VIEWs.
What matters is what you...
--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)

April 7, 2008 at 6:36 am

#799062
RE: What kind of DBA are you?

rbarryyoung (4/6/2008)
Jeff Moden (4/6/2008)
Heh... I handed Babbage gears 😉
Good one. 🙂
I was serious about my Uncle though, he really did do all of that stuff.
I have 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)

April 7, 2008 at 5:57 am

#799044
RE: What kind of DBA are you?

Either way, you're going to annoy someone!
Not to worry... Anyone who actually takes the time to get upset at either isn't someone you have to worry about offending because, although...
--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)

April 7, 2008 at 5:51 am

#799043
RE: Check Identity-Specification- 'No'

If it's temporary... (from Books Online)
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF }
If it's permanent removal you want, you'll need to define...
--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)

April 6, 2008 at 11:42 pm

#798949
RE: Two part parameter

My apologies... see the following URL for how to make a Tally table...
http://www.sqlservercentral.com/scripts/Advanced+SQL/62486/
--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)

April 6, 2008 at 11:27 pm

#798947
RE: How to update the Created Date on a table in SQL 2005 ?

This is the second time this same question has been asked... and just like I said on that identical post, directly updating system tables is a form of "Death by...
--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)

April 6, 2008 at 11:23 pm

#798945
RE: How to split cells in table format?

We're getting there... in the example you just gave, should 1 2 3 be in a single column or 3 columns? If 3 columns, what shall be their names?
--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)

April 6, 2008 at 11:19 pm

#798944

Viewing 15 posts - 51,241 through 51,255 (of 59,098 total)