Viewing 15 posts - 436 through 450 (of 621 total)
Greg Snidow (8/4/2008)
I thought PK's were nonclustered indexes.
Ok, now I have found something in BOL that seems to imply PK's are clustered, at least that's what I think its telling...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 4, 2008 at 2:02 pm
So I gotta ask, since performance tuning is not one of my strong suits, in fact, I don't even really have that suit at all, what are some ways to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 4, 2008 at 1:51 pm
So does that mean it worked for you?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 30, 2008 at 12:01 pm
GilaMonster (7/29/2008)
Rename the table and see who complains? 😀
Took out my comment. It was a joke, but could easily have been misconstrued as bad advice.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 29, 2008 at 1:53 pm
Not tested, but I think this will work. You might want to put a trigger on one of the fields that are required to be updated in order to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 29, 2008 at 1:49 pm
Learning Tree has a pretty comprehensive schedule of SQL classes. My company sent me to two of them, and I found the instructors to be very knowledgable and helpful....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 24, 2008 at 2:01 pm
Try this. The RTRIM is in there only because the species field is CHAR. You could omit it if you changed species to VARCHAR. Anyhow, just create...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 24, 2008 at 1:19 pm
I think this fixes your original question, which was the CASE in the WHERE clause.
select distinct
pl1.locationId as FromId,
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 24, 2008 at 12:19 pm
smunson (7/23/2008)
Wouldn't you want to present the notes in reverse order of occurrence, with the most recent note at the top, and the date/time of each note showing?
Thats a good...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 24, 2008 at 8:37 am
Ok, without having any more input, I got bored at work, and saw in this a good opportunity to try my limited skills. As always, the caveats are many,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 23, 2008 at 4:36 pm
trk225, can you tell me *exactly* which characters you are trying to replace? XML is greek to me, so I don't know what you are trying to do.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 23, 2008 at 1:34 pm
SELECT DATENAME(dw,YourDate). Look up DATENAME and DATEPART in BOL.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 23, 2008 at 6:46 am
Sounds like my company. We have so many people who absolutely refuse to make all our jobs easier by using the great tools we've been given, like a database.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 22, 2008 at 12:18 pm
Rodney
You can open your table in enterprize manager, make your changes, but instead of hitting the save button, there is another button that looks like a scroll, that will show...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 22, 2008 at 12:10 pm
Ron, I'm not sure exactly what you are looking for, but based on the four queries you provided, and I fixed the last one based on my assumptions, you get...
select...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 18, 2008 at 9:35 am
Viewing 15 posts - 436 through 450 (of 621 total)