Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,626 through 38,640 (of 59,072 total)

RE: Index on Date Time Column Not Getting Used

uppal.kunal (5/3/2010)
Same query in oracle does refer to index.. so there is something which Sql server does differently
Yes, it IS different. It's been a long time since I've worked...
--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)

May 3, 2010 at 6:50 am

#1161220
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Thanks for the feedback Jason and Peter.
Rumor has it that Steve is working on making a couple of training "movies" for the two articles in this series. He's pretty...
--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)

May 3, 2010 at 6:42 am

#1161217
RE: Are the posted questions getting worse?

Steve Jones - Editor (5/2/2010)
I've seen a couple incidents of plagiarism lately on different sites. Not all from this site, but a few places that have copied info from MSDN/Technet,...
--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)

May 2, 2010 at 11:21 pm

#1161086
RE: The Cost of Data Loss

Heh... I read 1984, "Enemy of the State" is one of my favorite movies, and I can certainly understand Tom's sentiment on this. I also have a grand appreciation...
--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)

May 2, 2010 at 6:29 pm

#1161054
RE: String splitter to table weird result

Digs (5/2/2010)
.."As we've seen on dozens of posts, an XML splitter would not have performed so well."..
Jeff you have seen the yahoo .csv link I posted in this thread.
I too...
--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)

May 2, 2010 at 6:00 pm

#1161051
RE: how to improve qurey perpormace

pradeepmsbi (5/2/2010)
how to improve the query performance in sql server 2005
It depends... what do you know about SQL Server and T-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)

May 2, 2010 at 5:40 pm

#1161048
RE: query is too slow

Since you have WHERE 1=1 in this code, that's a pretty good indication that this is embedded SQL and not a stored procedure. The code is pretty poorly written...
--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)

May 2, 2010 at 5:27 pm

#1161046
RE: please tell what is wrong with this cursor

anshu84onnet (5/2/2010)
Hi i am new to new cursor...
As others have already stated, you should stay "new to new cursor". Unless you're studying for an exam on SQL Server, 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)

May 2, 2010 at 4:33 pm

#1161038
RE: how to update a table from another table in differents db

Depending on your needs, you can use replication for this or you can use a trigger. I will also state that unless the tables/DB's are on different servers or...
--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)

May 2, 2010 at 4:24 pm

#1161037
RE: Model

You can simply change the size of the MODEL database and all new databases will be created according to the MODEL. That will certainly be a waste of space...
--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)

May 2, 2010 at 4:18 pm

#1161036
RE: String splitter to table weird result

Jeffrey Williams-493691 (5/2/2010)
WayneS (5/2/2010)
Digs (5/1/2010)
Jeff,
All works fine: And Fast !
I will keep your name on my list when I need to spend $$$ on my project .
Minutes have gone...
--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)

May 2, 2010 at 4:13 pm

#1161034
RE: String splitter to table weird result

Heh... I have to say that no one can knock on you about getting back with a response fast enough. Thanks for the feedback, Digs.
I'll also say that most...
--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)

May 1, 2010 at 10:41 pm

#1160960
RE: String splitter to table weird result

Ah... understood. Here's code to take your very long "parameter" and twist it into what I believe you really want for a final table... "we doan nid 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)

May 1, 2010 at 10:31 pm

#1160956
RE: Quick question about len

Matt Miller (#4) (5/1/2010)
As to len - I was just trying to make sure i didn't miss something.
Nope... you didn't miss a thing except for the short nap that 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)

May 1, 2010 at 9:13 pm

#1160952
RE: String splitter to table weird result

I got something about the use of an illegal operand in a TOP clause when I used Lynn's code. And, I'm sorry, I don't have the time to troubleshoot...
--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)

May 1, 2010 at 9:01 pm

#1160950

Viewing 15 posts - 38,626 through 38,640 (of 59,072 total)