Viewing 15 posts - 1,651 through 1,665 (of 6,486 total)
...a HAVING clause that has nothing to justify filtering AFTER aggregations?
October 16, 2009 at 3:24 pm
Each of your @variables inside of the CTE need to be labeled.
so, for example:
SELECT
...
October 16, 2009 at 9:28 am
a composite index with company Id, employeeId and start_trip in it should speed it up quite a bit.
October 15, 2009 at 10:36 pm
I would also be curious how much faster that gets if you were to make that whole statement dynamic, using the CASE statement to plop the column name directly into...
October 15, 2009 at 8:23 pm
was his laptop 64-bit by any chance? Because that would allow him to use twice as much RAM for SQL (since SQL could use 4, and the OS could...
October 15, 2009 at 8:12 pm
If time permitted, I would do "in place" version compares. As in - install Express, run various perf tests, then purchase Dev Edition (essentially an Ent. Edition without the...
October 15, 2009 at 3:00 pm
quadrant.systems (10/14/2009)
Thanks! That did the trick for me. I don't know why I couldn't figure out the ceiling/floor deal...but this is exactly what I needed.
Do...
October 14, 2009 at 3:30 pm
GSquared (10/14/2009)
October 14, 2009 at 12:43 pm
Other than the confusion - I can't help but think we've got a normalization disaster going on with is making this problem much harder to handle. Whe're the relationship...
October 13, 2009 at 10:18 pm
Keep in mind this may not catch errors buried in various IF statements, especially if they happen to be buried several layers deep.
October 12, 2009 at 9:18 pm
Lowell (10/11/2009)
you can add favourodily25 to the list of spam accounts; i just re-enabled PM's from t= he forum, and got a couple from that log in.
I got mine today...
October 11, 2009 at 9:16 pm
The most common error 1222 is the infamous "lockout time exceeded message". This is not so much a SQL error as a "connection-type" error, meaning - it will pop...
October 11, 2009 at 2:05 pm
Sounds like that's being caused by auto-growth. Look at a. making the files big enough that they don't need to auto-grow a lot, and b. making your auto-growth factor...
October 9, 2009 at 11:55 am
I don't know if this helps, but every dump in my area has a hardware recycling day, where you can bring hardware and just leave it, so as to be...
October 9, 2009 at 11:40 am
What is happening to tempDB when you start seeing your bad behavior? You're creating an wful lot of temporary objects.
Also since you don't know where the problem is -...
October 9, 2009 at 8:58 am
Viewing 15 posts - 1,651 through 1,665 (of 6,486 total)