Viewing 15 posts - 31,051 through 31,065 (of 39,754 total)
I agree with Andras that it looks ok from a code perspective, but I'd format it to make it read a little better.
I'd do it like this:
CREATE TRIGGER [Prorogation] ON...
October 8, 2007 at 9:01 am
I think my generalist mistake in sticking this in the author discussion and not the editorials messed up some of the discussion 😛
How many people know how to redirect output...
October 8, 2007 at 8:52 am
Actually, CHECKDB should include CHECKCATALOG and CHECKALLOC.
NEWALLOC is included for backwards compatability and is the same as CHECKALLOC.
http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa258809(SQL.80).aspx
October 8, 2007 at 8:23 am
You can open the Structured Storage file in Notepad Or Visual Studio. It's just text, VB code. Look through it and you should figure it out.
However, if it only fails...
October 8, 2007 at 8:21 am
Don't forget to send a video in 🙂
We'll use Popcorn in the editorial one morning! Don't worry Popcorn, it's painless!
October 8, 2007 at 8:16 am
Building in formatting, like carriage returns, is a horrible use of SQL Server resources. You're asking for a lot of work from a limited, shared resource. As mentioned above, whatever...
October 8, 2007 at 8:03 am
I'd really check the values in the Structured Storage file. There were issues in the past where something wouldn't show up in the designer, but still existed in the VB...
October 8, 2007 at 8:02 am
I assume you're reading from Performance Monitor. If not let us know.
I don't think I've ever seen this counter die, but as Colin mentioned, usually all the SQL counters will...
October 8, 2007 at 7:54 am
BTW, both of these create recovery issues since you have to install something on a new server in a DR situation. Make sure you update documentation and keep copies of...
October 8, 2007 at 7:51 am
I know I've seen the green arrow, but can't remember what trick to use.
There are issues with sending mail SMTP via Outlook. For some reason they "stick" in the outbox...
October 8, 2007 at 7:51 am
Be careful backing up to drives not local to the machine. Network backups sometimes cause issues.
October 7, 2007 at 9:42 pm
Depends 😉
If you have heavy tempdb or log usage (based on transactions), then you might get a performance improvement. Keep in mind that data files usually have lots of random...
October 7, 2007 at 9:35 pm
(possibly) stupid question. Users have run queries on this, right?
As soon as something is read into the buffer, I'd assume the next query should get some type of hit.
The...
October 7, 2007 at 9:33 pm
The only difference I'm aware of is when the connection is made. After that, things should run the same.
Can you provide more details on what seems slow? I wouldn't think...
October 7, 2007 at 9:31 pm
From what I've heard from the PSS guys at Microsoft, don't change the worker threads unless they help you determine this. You can get unexpected results.
That's not really a place...
October 7, 2007 at 9:30 pm
Viewing 15 posts - 31,051 through 31,065 (of 39,754 total)