Viewing 15 posts - 37,936 through 37,950 (of 49,571 total)
Can you run CheckDB on all databases that procedure touches?
July 2, 2009 at 2:03 pm
WayneS (7/2/2009)
Is there a way to tell when / how often a file has grown in the past?
Default trace, for as far back as it goes.
July 2, 2009 at 1:53 pm
Aaahhhh!!!!
I've spend several evenings over the last two weeks trying to figure out why the BDI agent I was working on was ignoring a belief change.
I checked and rechecked...
July 2, 2009 at 1:51 pm
ALZDBA (7/2/2009)
Keep prod and dev data on separate instances !
Keep prod and dev on different servers!
July 2, 2009 at 12:54 pm
Florian Reischl (7/2/2009)
Lynn Pettis (7/2/2009)
I realize the OP didn't really provide everything that we really need to help, but this actually answers the OP's question?? :sick:Smells like a cross post:
http://www.sqlservercentral.com/Forums/Topic746129-338-1.aspx
Except...
July 2, 2009 at 12:10 pm
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 2, 2009 at 11:55 am
All we're asking for is the definitions of all tables involved (as CREATE TABLE statements), sample data for those tables (as insert statements), an example of the results you want,...
July 2, 2009 at 11:23 am
WayneS (7/2/2009)
July 2, 2009 at 11:05 am
SpyCraft (7/2/2009)
We were displaying error message in such cases. But user ignored the error and continued using the application ..sounds very odd but true..
Hardly unusual. Especially if the error was...
July 2, 2009 at 10:55 am
ifila, we want to help, really. But the sample data doesn't match the table definition. The desired output doesn't match the table definition. Based on that, I cannot write a...
July 2, 2009 at 10:51 am
Does this help? http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Were the indexes actually fragmented? If not, if may be stale statistics. If that's the case then am update statistics should fix the problem next time
July 2, 2009 at 10:49 am
You should have some form of error handling (and logging) in either the procedure or in the front end app.
July 2, 2009 at 10:45 am
ifila (7/2/2009)
I will grab the first record - in this case 'livelink, java'
The one with the lowest ID?
July 2, 2009 at 10:43 am
river (7/2/2009)
The first question is :Do i realy need to update statistics in the script? my database as the option auto_update statistics ON.
Yes. If it wasn't necessary I wouldn't...
July 2, 2009 at 10:40 am
Your sample data doesn't fit in the table specified. Do you mean this as sample data, or should the table have more columns?
Insert into resumein (OriginalResume, OriginalEmail)
Values ('java',' jsmith@gmail.com')
Insert...
July 2, 2009 at 10:13 am
Viewing 15 posts - 37,936 through 37,950 (of 49,571 total)