Viewing 15 posts - 5,011 through 5,025 (of 7,429 total)
Are you saying you are trying to backup a databse that is marked down. I don't believe you can perform a backup until you issue a recover on the database.
"Don't...
August 28, 2002 at 2:30 pm
I simple use notepad or QA depending on which is handy. QA of course has color coding for SQL Server but I just don't care to pay for something I...
August 28, 2002 at 2:27 pm
Not sure, was the query running and completed with no returned records. Would it not start or did it start and just clocked. If other than the clocking you could...
August 28, 2002 at 4:31 am
Depends on how you setup checking permissions. Personally when the users app connects I get their security permissions and store them to avoid eaxtra table reads. Then when I connect...
August 28, 2002 at 4:13 am
Slow deletes can also be a sign of to many indexes as well.
Also, check to see if you have "truncate log on checkpoint" or "auto shrink" on. Both of these...
August 28, 2002 at 4:08 am
I am confused by what you are doing. However, try this.
Reset the system time, 7 syncs within a few seconds and 2000 seems instantaneous.
Next use sp_update_jobschedule to disable the jobs...
August 28, 2002 at 4:05 am
That I think would work just fine. There client thou has to have a listening port open to accept this new incoming connection. There are many ways to do what...
August 28, 2002 at 3:46 am
Result in text will not affect the "Maximum Characters per column" which is in effect on the column output. You will still be limited in that column unless you change...
August 28, 2002 at 3:37 am
quote:
So where a trace flag is not available I assume you create either a profile definition in profiler or you set up...
August 28, 2002 at 3:35 am
Have you looked at the error log that was generated? They may contain clues.
quote:
An error log isbeing created.
August 27, 2002 at 5:02 pm
SQL Profiler is similar to xp_trace
Stored Proc xp_trace this is what all the extended stored procedures start with.
Stored Proc xp_trace_addnewqueue - Adds a new trace queue and sets trace queue...
August 27, 2002 at 4:58 pm
Yes, that solutions is denormalized for the reason you stated. Basically if a lot of data can repeat with NULLs then normalize further. Unless for performance reasons with doing the...
August 27, 2002 at 4:32 pm
Install 7 and use the database upgrade wizard is probably the easiest. Just make sure you have a backup of the old databases and are sure on how to restore...
August 27, 2002 at 4:20 pm
Onced, if I remember correctly DBCC UPDATEUSAGE may correct this. Also,I'd run DBCC CHECKDB from QA (using NO_INFOMSGS etc). Record all errors. Search
KB etc. Possibly restore latest backup. Or, if...
August 27, 2002 at 4:14 pm
Correct. When talking about Client Side and Server Side cursors yes, it is based on the application design and the underlying client library used to create the connection (OLE, ODBC,...
August 27, 2002 at 4:04 pm
Viewing 15 posts - 5,011 through 5,025 (of 7,429 total)