RE: Event ID: 1069
Also make sure all the resources that belong to sql are in the sql cluster group i.e. disk or services that may not have been included. Wes
2003-11-18
HIERARCHYID
RE: Index Wizard and Memory
It didn't show any room for improvement? Did you try going with thurough and setting the number of statements to check up? Also you may want to make sure that the db you ran it against when it failed all those times does not have any statistics droppings.
2003-09-17
RE: More sophisticated locking model
Fix: Uninstall SQL Server. Install Oracle. (I like these easy ones)
2003-06-24
2003-05-14
RE: Need to create constraint.
quote: ...Could you give an example with this column structure. I just want to make sure I understand... Sorry took so long to get back; went home for the day! 🙂 Here you go: CREATE TABLE new_property ( UserID INT NOT NULL, MLSNum INT NOT NULL, DateInserted DATETIME NOT NULL, CONSTRAINT PK_new_property PRIMARY KEY ( […]
2003-05-14
RE: Full text in Cluster
Can you post the error messages here? Make sure all SQL Server resources are online from Cluster Administrator. What service account SQL Server and Agent services run? Has 'BUILTIN\Administrators' login been removed from SQL Server login? Full Text does not work properly after sp3 upgrade SQL Server 2000 (upgrading to SP3) where SQL Server 7.0 […]
2003-05-13
1 reads
2003-05-13
2003-05-13
RE: Distribution Statistics
Thanks for this. I notice that the _WA_SYS stats count towards the 255 indices allowed on a table. There is an db option to autocreate these stats which defaults to "ON" as does the autoupdate facility. I notice that tables under 8Mb do a FULLSCAN where as those over the 8 do a sample. Although […]
2003-05-13
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