We’ve all seen reindex procedures that rebuild all indexes in a database or all indexes in a database which have less than a specified ScanDensity. This one goes a few steps further. First, the DBA can specify a ScanDensity_Threshold (a min value for ScanDensity), plus a Limit (qty or %). If you specify a ScanDensity_Threshold […]
2005-06-14 (first published: 2005-03-31)
1,827 reads
Thanks Frank, I'd forgotten to add the update stats bit after the online defrag, but thought that Clive was experienced enough to know that anyway
2005-03-31
Hi all, I am trying to get this damned SQL XML Bulk Load to work and I have found that I can pass the ADO command to load it into the database.The 2 parameters I need are:1.) The XSD2.) The XML file to importThe problem I have is that the XSD file I have is […]
2005-03-29
There are 4 types of transaction isolation levels. Here is the syntax :SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | READ UNCOMMITTED | REPEATABLE READ | SERIALIZABLE }Once you set the Isolation level, it will work for that particular connection.--Kishore
2005-03-29
The 100% cpu is definately related to SQL?When you are hitting these cpu levels run a quick query to see what's going on, get an idea of what processes within SQL could be causing the problem.Quick example, I use this, which shows me what process is using the most CPU at the time (can be […]
2005-03-23
Im a newbie in sql. i started learning SQL at the begining of february...the assignment is a class assignment... Do you know any free online sql server? Any site with BOL will help me...have a great week...
2005-03-22
Create Table Contacts( name varchar(200)) go insert into Contacts(Name) Values('John E. Doe') insert into Contacts(Name) Values('Jan Smith') insert into Contacts(Name) Values('Ralph Wallace') insert into Contacts(Name) Values('Walter C Johnson') goselect Left(Name, Len(Name) - Charindex(' ',Reverse(Name),1)-1) As FName , Right(Name,Charindex(' ',Reverse(Name),1)-1) As LName from Contacts
2005-03-16
2005-03-13
To easily solve all types of pivoting problems with minimal coding check out the RAC utility for S2k.As easy as Access crosstab query but much more powerful with many features/options.www.rac4sql.net
2005-03-11
Ok, so if DIVIDEBY is algebra, could someone explain the answer please, for those of us who are not mathematicians.I'm not sure why we should have maths questions in what is an SQL forum. This question was clearly badly worded, judging by the percentage of people who got it wrong. If the question had been "T_SQL equivalent […]
2005-03-11
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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