Viewing 15 posts - 21,631 through 21,645 (of 26,490 total)
Jeff Moden (4/7/2009)
April 7, 2009 at 3:20 pm
If you are using SQL Server 2005, something like this may also work:
WITH StudentAddr (
RowNum,
StudentID,
Zip,
...
April 7, 2009 at 3:05 pm
1. What version of SQL Server are you using?
2. Please provide us with the DDL for the tables involved in the query. You can
...
April 7, 2009 at 2:43 pm
Robert Hermsen (4/7/2009)
Lynn, unfortunately i have no control over indexes. The showplan is the same for both. there are covering indexes.GSquared, Thanks. I will look into that.
That's...
April 7, 2009 at 2:05 pm
What are your indexes on these two tables?
MagicTSD._SMDBA_._TELMASTE_ tm
MagicTSD._SMDBA_._TELDETAI_ td
April 7, 2009 at 1:55 pm
Jeff Moden (4/7/2009)
Actually, there are a dozen or so good folks on this forum that I'd like to see get the MVP.
I did a little more reading, Jeff. As...
April 7, 2009 at 1:38 pm
Steve Jones - Editor (4/7/2009)
Arguably I haven't contributed anything substantial to the SQL knowledge base in quite some...
April 7, 2009 at 11:21 am
Using SELECT * is just lazy. Do all the queries that are being run need all the columns from all the rows everytime? that is the question I'd...
April 7, 2009 at 8:35 am
Bob Hovious (4/7/2009)
Yet the poster apparently has more control than you would think 😉
Actually, depending on what and how they are doing things, there are "ways" around the tools. ...
April 7, 2009 at 8:25 am
Bob Hovious (4/7/2009)
You can tell that from the table and column names, I suppose.
Yes. I provide SQL Server support for our PeopleSoft developers, so I have learned a bit...
April 7, 2009 at 8:05 am
Jeff Moden (4/7/2009)
Jeff Moden (4/6/2009)
Lynn Pettis (4/5/2009)
April 7, 2009 at 8:01 am
saranram_forum (4/7/2009)
Hi,I need T-SQL.Pls give the solution.
Solution to what? You haven't provided us with enough information do help you yet. Have you read...
April 7, 2009 at 7:51 am
Looks to me like that may be a third party or in-house routine. I'm not familiar with it and a search of the web on Google and Yahoo don't...
April 7, 2009 at 6:21 am
Not really sure, you haven't told us much. Are you getting an error of some sort? If so, what is the error you are receiving? That would...
April 6, 2009 at 11:38 pm
Roy Ernest (4/6/2009)
And it is no surprise that Lynn is dealing very patiently. He is THE SAINT.. 🙂Next I want to see Lynn being nominated as MVP...
I appreciate the sentiment,...
April 6, 2009 at 11:03 pm
Viewing 15 posts - 21,631 through 21,645 (of 26,490 total)