Viewing 15 posts - 511 through 525 (of 686 total)
GSquared (6/10/2011)For example, in WoW, a priest is pretty much a healer, with very, very little DPS.
When was the last time you played WoW? All classes now have a super...
June 13, 2011 at 7:09 am
Gail,
So not even a clustered index determines the order of a result set sans order by?
(reliably, not guaranteed)
June 10, 2011 at 12:17 pm
Query would be helpful. DDL would be more helpful.
Without a sort, TOP 1 will return whatever record is first (random). However I do believe this is influenced by a clustered...
June 10, 2011 at 12:06 pm
Your Rockies, Mr. Jones, had a pretty nice rally yesterday. Down 7-0 to come back 9-7 FTW!
All week, the media makes a big deal about Ortiz not being hit by...
June 10, 2011 at 10:20 am
Not only would DDL scripts be good for table creation and sample data, it would help in determining what needs to be done to potentially increase performance.
Also, I have a...
June 10, 2011 at 9:21 am
You're heading into a database "normalization" discussion. If you're wanting to go down that road (which you should), make sure you do your research and normalize correctly. Understand Normal Forms...
June 10, 2011 at 7:55 am
it means you're trying to insert data into a field that isn't big enough to hold it.
for example, you're trying to insert 'this is a test string' into a varchar(10)...
June 10, 2011 at 7:49 am
mtassin, I believe Bob is quoting BOL in that paragraph.
Gail,
I had found that link earlier and figured BOL would be the authoratative source. Thanks for clearing that up for us.
Bob...
June 10, 2011 at 7:18 am
That error is pretty self explanatory.
How about posting the script you're trying to run?
June 10, 2011 at 6:23 am
Wow. I really had to dig for that one.
Pretty confusing stuff. I'd like to know if anyone here utilizes this feature of splitting physical CPUs for the purpose of...
June 10, 2011 at 6:21 am
min() and max() don't care if they are in order or not. The functions do some fancy behind the scenes tempdb sorting stuff which isn't super important (at this point)....
June 9, 2011 at 1:09 pm
It's in alphabetical order so min is nn001 and max is nn002.
June 9, 2011 at 12:44 pm
Took me a second to understand it too.
I believe the logic is, if there is one and only one entity for the RU, then show it. (adhering to your 1...
June 9, 2011 at 12:28 pm
I was going more along the lines of
select cartesisRU
From #Cartesis_to_hfm
group by cartesisru,hfmentity
June 9, 2011 at 11:56 am
Viewing 15 posts - 511 through 525 (of 686 total)