Microsoft Announces a New Security Program
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
security
How do I set a fixed amound of memory for SQL?
Hi there- newbee question for ya. I have an SQL server with IGB RAM that was recently upgraded to 2GB but SQL still hogs all the RAM for itself. I have been told I should reserve 15% for the OS but I don't know how. Its SQL7 running on WinNT4. Thanks, Kevin Reynolds
2001-10-17
4 reads
Sports Ranking SQL Problem
I have a database for sports results. I have a table that holds entry details (Name, Class, Number etc) and a table for results which can be considered as just linking a given result to a given entry. Each competitor has more than one run and the best N runs count. I know I can […]
2001-10-15
10 reads
Query Execution Plan
Dear Listers, Scenario: A stored procedure executed on SS7 SP2 completed in approx. 5mins. Following an upgrade to SP3 the same proc. completed in approx. 55mins. !! (Same server, same db, yada, yada, yada) i) Could the QEP have changed ? ii) Is there any means by which one can guarantee that a stored procedure […]
2001-10-15
4 reads
Baseline processes to monitor ?
My company is in the process of evaluating monitoring software (bmc) and below is a list of parameters that are recommended to monitor. What are the baseline processes to monitor ? and where can I find a detailed explanation of all these parameters ? ARATest BlockerProcs ErrorLogUpdates NumBlockedProcesses SQLExecJobFailures SQLServerStatus SuspectDatabases ConnectionsRemaining IdleProcs CheckConfiguration CurConfigsColl […]
2001-10-12
23 reads
Microsoft Analysis Services Trounces the Competition
Comments posted to this topic are about the content posted at http://www.microsoft.com/PressPass/press/2001/Sep01/09-18OLAPReportPR.asp
2001-10-12
2 reads
Microsoft Announces a New Security Program
Comments posted to this topic are about the content posted at http://www.microsoft.com/security/
2001-10-12
5 reads
SQL Server authorization modes after SP3 installed
One of our users, which is worked in SQL Server 7.0 with our application, installed SP3 in NT-integrated authorization mode instead to install it in mixed mode, that our application is requested. Can he return his SQL server to mixed mode, and if yes - how to perform it. Thank you very much for any […]
2001-10-10
Trimming MSDB db size
How can I trim the size of our SQL 7 MSDB database? I have no problems dumping old histories that are no longer needed. Any other sugestions. TIA, Bill
2001-10-09
11 reads
2001-10-09
4 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers