Viewing 15 posts - 36,661 through 36,675 (of 39,720 total)
What should happen:
User contacts SQL Server, sends credentials, SQL then verifies these with the DC and once verified, checks syslogins (and sysusers) for access before responding to the client.
Steve Jones
December 24, 2002 at 11:28 am
Sorry, not a cluster guy. Try to get Brian to look at this.
Steve Jones
December 24, 2002 at 10:07 am
Don't try to reinvent this. You will forget something and screw yourself.
Use VSS or CVS or some system designed to do this. Maintian strict controls on this.
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
Steve Jones
December 24, 2002 at 10:05 am
Get Brian Kelley's book for some ideas:
http://www.netimpress.com/shop/product.asp?product_id=NI-SQL2
Don't see too much on benchmarking per se. Probably should write something up on this.
Also:
http://www.sql-server-performance.com has lots of articles on perfromance tuning.
http://www.sqlservercentral.com/columnists/nboyle/memorytuning.asp
Steve Jones
December 24, 2002 at 10:02 am
There is a new security book from CurlingStone, SQL Server Security Distilled, that covers this in great detail. If it's taking significantly longer, you have network issues.
As Anatares said, once...
December 24, 2002 at 9:45 am
Most likely what you want to do is change your PK index to non clustered. High selectivity, etc. Not worth having the clustered. I'd move the clustered to the StartTime...
December 24, 2002 at 9:42 am
December 24, 2002 at 9:32 am
Thanks for the update.
So the issue was lack of disk space? On the paging file?
Seems like a memory issue, like you don't have enough memory available at that time for...
December 23, 2002 at 11:10 am
Never setup an operator as a person.
Setup a distribution list in Exchange and use that as the list in SQL. Prevents points of maint if the dba changes. The network...
December 23, 2002 at 11:08 am
BTW, did find this, but it doesn't appear to work for me:
select serverproperty('LicenseType')
Steve Jones
December 23, 2002 at 11:06 am
Sorry for no answer. I looked around for this, but haven't been able to find a way yet.
Steve Jones
December 23, 2002 at 11:03 am
sort of. You can register an exteneded stored procedure, which will be a DLL, however, it will not be in the context of the trigger. It will be part of...
December 22, 2002 at 9:43 pm
In SQL Server 7 and 2000, a debugger is available in Query Analyzer.
Steve Jones
December 22, 2002 at 9:42 pm
Agreed. Compared to some other vendors that shall go unnamed, the support is premium.
Another vendor experience (not good) prompted me to write this one.
Steve Jones
December 21, 2002 at 10:54 pm
Viewing 15 posts - 36,661 through 36,675 (of 39,720 total)