RE: Strange Response Times
How many processors your server has? It could be query optimizer generating different execution plans due to statistcs changes that results in large number records inserted/updated/deleted.
2005-04-28
Indexing
RE: New Server what spec
See if these will helphttp://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx http://www.microsoft.com/sql/techinfo/administration/2000/scalability.aspAnd as RAID 5 has been mentioned above, this is definitely interesting:http://www.baarf.com/I would also surf the sites of those hardware vendors. Usually you can find there case studies, that can be useful.
2005-04-22
RE: replication type advice
We are currently using pesimistic locking.... will this help as there will still surely be instances that 2 people in different locations can open the same one till they sync.If there is a conflict, is there any way of taking one side (i.e. earliest), but emailing the details of the overwritten one to an email […]
2005-04-22
RE: dbo problem
use datbase name update sysobjects set uid = 1 where uid = 6 This is writing straight to the system catalog which works perfectly but isn't advised by Microsoft.
2005-04-22
RE: Should I change my avatar
Even the idea that I want to scare anyone off this board is pathetically hilarious! I'm not even going to comment on this thought : If someone is really scared by this avatar, I suspect him to have other massive problems, but that's another story. But actually it's really easy to "force" me to change […]
2005-04-20
2005-04-18
Script to Move Indexes off of the Primary Filegrou
This is a stored proc that will move your indexes to two new file groups. A Cindex file group is for the clustered indexes and NCindex file group is for non clustered indexes. The parameters for this procedure are @CPATH - the path to the clustered index datafiles @NCPATH - the path to the nonclustered […]
2005-04-29 (first published: 2005-04-15)
376 reads
RE: Generating a SP Dependency Tree
When you have 0% to start with and the task is large, an 80 or 90% solution would probably be pretty useful as a start.
2005-04-14
Execute SQL-DMO Database method on all databases
This script allows you to specify a method and a server (or multiple servers.) It will then execute the method on every database on the server. With very minor tweaking you could have it search for the servers, then call the server db script with each one, or add another nesting to call tables or […]
2005-04-27 (first published: 2005-04-14)
697 reads
RE: new to SQL Server 2000
Go to http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=enDownload and install MSDE (Microsoft SQL Server 2000 Desktop Engine)Then you can use client tools.
2005-04-14
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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