Viewing 15 posts - 5,626 through 5,640 (of 6,105 total)
One thing that would probably need to be tested in a development environment is the effect on objects that are owned by said user. It should not affect any,...
February 14, 2002 at 12:41 pm
You've looked in the Knowledge Base and I did a search there, too, and the only thing that came up was for Enterprise Manager, which doesn't describe the issue. ...
February 14, 2002 at 12:37 pm
Our DBAs have local administrative rights to most boxes. Boxes that are within the control of the DBA team are configured in this manner. The rationale is pretty...
February 14, 2002 at 12:33 pm
There's this, but it's through EM:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246588
K. Brian Kelley
February 13, 2002 at 2:59 pm
Interesting. How are you handling a trend analysis that would go across the year end? Say looking at 6 months from Oct 2001 - Mar 2002?
K. Brian Kelley
February 12, 2002 at 11:56 am
Consider this:
(a) User has to realize that decryption tools are available for SQL Server.
(b) User has to know how to fire up and use Profiler
(c) User probably knows how to...
February 12, 2002 at 10:36 am
As far as where to save, Brian Knight addresses the issue in an article:
http://www.sqlservercentral.com/columnists/bknight/savingpackages.asp
Security and the like I know we've discussed in the forums. You might do a search...
February 11, 2002 at 1:16 pm
mbova, here's the deal on security.
If we build stored procedures that contain only static SQL statements, we can take advantage of ownership chains. For instance, dbo owns the stored...
February 11, 2002 at 8:29 am
Each active instance requires a separate license. That's why you can get away with a single SQL Server license for an Active/Passive setup, but you need two licenses for...
February 10, 2002 at 11:20 am
I teach Children's Church at my local place of worship and I used to teach alcohol/drug prevention, but I have no teaching experience in the technology sector. I just...
February 10, 2002 at 11:13 am
The person you are talking about is Brian Knight. Brian's books are great and in talking with him through emails I've learned a lot, too. His articles on...
February 9, 2002 at 8:16 pm
One other place you might want to look is at an article by Neil Boyle. It covers the topic of JOINs and might also be helpful:
http://www.sqlservercentral.com/columnists/nboyle/ansijoins.asp
K. Brian Kelley
February 9, 2002 at 6:24 pm
Since it is a Proliant, you may want to head over to the support site:
http://activeanswers.compaq.com
There are is a performance analyzer tool that runs on a separate system and uses the...
February 9, 2002 at 5:43 pm
Ok, let's step through this one join at a time. For table aliasing I tend to use the first letter of each word for the table, so you'll see the...
February 9, 2002 at 2:41 am
Something doesn't mesh. Your processor queue length is high. Your page faults/sec is high, but your processor utilization is at 1%? Usually when there is excessive paging,...
February 8, 2002 at 9:30 pm
Viewing 15 posts - 5,626 through 5,640 (of 6,105 total)