Viewing 15 posts - 46,456 through 46,470 (of 49,571 total)
Slawek (5/21/2008)
May 22, 2008 at 12:02 am
Matt Miller (5/21/2008)
If you want to see some REALLY interesting things - throw in the MAX() OVER () into your testing.
Max () OVER ()???? :blink:
< wanders off in...
May 21, 2008 at 2:49 pm
In SQL 2005, only objects that a user has rights on can be seen from the system views. So, if your web site user has no access to the base...
May 21, 2008 at 2:36 pm
You may be able to remove the inner cursor. The outer one, no.
WHILE @@FETCH_STATUS = 0
BEGIN
--Find the number of days before ESCALATION
...
May 21, 2008 at 2:00 pm
Gordon (5/21/2008)
Gila Monster, do you use multiple backup files, and if so how many?
Not at the moment, though we are considering it. Right now we only have a single...
May 21, 2008 at 1:46 pm
Grant Fritchey (5/21/2008)
Yeah. I'm actually working on comparing MAX, TOP and ROW_NUMBER. I was hoping to outline which might be better when.
A worthy investigation. I look forward to your results.
May 21, 2008 at 1:30 pm
If you can post the query and the definitions of the tables involved, we may be able to help.
May 21, 2008 at 1:28 pm
From the sound of things, the inner cursor may be removable. Can you post just that bit please?
May 21, 2008 at 1:27 pm
Jack Corbett (5/21/2008)
The only reason I put things in a trigger instead of a proc is to protect me from me. Most triggers I use are "audit" or change...
May 21, 2008 at 11:34 am
Grab one of the 3rd party backup solutions that offer compression. Most of the time of the backup is writing the backup out to disk/tape. I use LiteSpeed. There are...
May 21, 2008 at 11:27 am
Just on account should be fine. The clustering key is always present in all nonclustered indexes as the rows 'address'. Queries that filter on both, or just on country can...
May 21, 2008 at 10:36 am
Steve Jones - Editor (5/21/2008)
May 21, 2008 at 10:24 am
knowlton (5/21/2008)
May 21, 2008 at 10:09 am
Could the server be in single user mode? Check the SQL error log.
May 21, 2008 at 7:52 am
Viewing 15 posts - 46,456 through 46,470 (of 49,571 total)