We have a performance problem on our servers and we have isolated it down to one particular application. However, the question asked in meetings is how does SQL Server divvy up CPU between SPIDs? For example, between 10:32:36am and 10:48:02am, the server's CPU was maxed out by the service sqlservr.exe. Looking in Enterprise Manager at […]
2004-02-17
5 reads
I recognize that a where clause with something like "WHERE A=B and C=D" you might not be able to count whether or not it will evaulate the "C=D" if A<>B.But there are times you need to and I thought it was possible by doing nested selects. But it isn't working. Here is a real example:select * […]
2004-02-16
5 reads
Hi allHad some very strange prod server errors yesterday, basically this connection string would result in around a 5sec delay per connect, this is reminicient of a MDAC bug in dbnetlib.dll (see KB 300420).The string was:Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=10.10.xx.xx,2433;Network Library=DBMSSOCNI have the client network util on the box, so created an alias called "BILLABONG" and […]
2004-01-29
1 reads
Disaster Recovery (DR) is the process of restoring systems to an operational status after a catastrophic systems failure leading to a complete loss of operational capability. Business Continuity (BC) is the forethought to prevent loss of operational capability even though there may be a catastrophic failure in some parts of the system. BC includes DR plans […]
2004-01-25
I've seen this error message when a Package created using SQL 2000 Client Tools is edited using SQL 7.0 Client Tools.
2004-01-23
1 reads
2004-01-20
2004-01-08
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-12-26
Amazing what a little public scrutiny will do. K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-12-12
1 reads
if you're talking about SQL Agent jobs, they correspond to logins (sysjobs has a sid column as a result). Since roles (at least ones we can define) are at the database level, they can't be assigned as the owner of a job. K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server […]
2003-12-09
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
By Steve Jones
The survey is out now and you can share your experiences for a chance...
By Rob Sewell
"We can really be dangerous if we want, without being too afraid of it."
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers