Viewing 15 posts - 1,246 through 1,260 (of 18,926 total)
There's no magic here. This needs to be rewritten to NOT use 1 trillion tables (if possible).
Performance is not magic, it's do as little work as possible (server work,...
November 14, 2011 at 9:16 am
Tom Brown (11/14/2011)
OK GSquared. Now you have me worried.But you seem to be implying we could get 2 rows where only 1 exists, or no row at all?
Yes.
If...
November 14, 2011 at 9:14 am
Got a mail reply :
Hi Remi,
Completion of this stairway has been delayed - we should know next week when it's likely to pick up again and what new articles...
November 14, 2011 at 9:12 am
Nothing to discuss here.
Join is not automatically a single = operation. What happens if you have a multiple keys PK?
also that query could be rewritten as such =>
JOIN RFT_TARGET_DIAGNOSES...
November 14, 2011 at 9:11 am
Rebuild index, update stats.
Then monitor the server for newly poor performing code.
Transfer logins obviously.
November 14, 2011 at 9:10 am
Tom Brown (11/14/2011)
Ninja's_RGR'us (11/14/2011)
If you want order in the subsequent selects, you HAVE TO specify ORDER...
November 14, 2011 at 9:06 am
raotor (11/14/2011)
GilaMonster (11/14/2011)
SELECTCOUNT(Price),Price
FROMTempSales
GROUP BY Price
ORDER BY Price;
That's a really, really weird query to run. Count the non-null values of price for each unique value or price, then order by the...
November 14, 2011 at 9:05 am
SQLRNNR (11/14/2011)
November 14, 2011 at 9:04 am
Steve Jones - SSC Editor (11/14/2011)
Done,with travel for the year. 14 events, I think 20 presentations, a long year.
Done for the year?
November 14, 2011 at 9:03 am
year - month
2011 - 1 - January
2011 - 2 - February
2011 - 3 - March
If you sort by column 1 & 2, the sequence will be correct in the month...
November 14, 2011 at 9:02 am
Jpotucek (11/14/2011)
SELECTDATEADD(D , 0 , DATEDIFF(D , 1 , GETDATE())) AS CreatedSince
, create_date AS CreatedOn
, *
FROM
sys.databases
WHERE
...
November 14, 2011 at 9:01 am
GSquared (11/14/2011)
He asked about the ID sequence. That should do what's needed. ID can then be used in later Order By clauses to insure sequence.
Clustered PK on ID...
November 14, 2011 at 8:59 am
Aside from identity, why does the order by of the insert matters?
If you want order in the subsequent selects, you HAVE TO specify ORDER BY in the select.
Tables...
November 14, 2011 at 8:52 am
I've helped as much as I could. I don't know anything about that error.
November 14, 2011 at 8:50 am
Viewing 15 posts - 1,246 through 1,260 (of 18,926 total)