In this script we create a temporal table and then review all indexes with next conditions.
avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
2008-09-05 (first published: 2008-07-10)
4,622 reads
2008-08-05 (first published: 2008-06-12)
3,412 reads
2009-08-03 (first published: 2008-02-29)
3,280 reads
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
Is there any thumb rule which can be used to decide about this selection.Pls suggest
2005-03-10
I have tryed to use the OLEDB provider but it is flakey at best as a linked server. but seems to work great in ADO.The most reliable "free" method I have found is to use the client access ODBC driver on the SQL server. then create a linked server using the OLEDB driver for ODBC. And […]
2004-09-16
Hi,as soon as you get the database to online, you couls use the undocumented proceduressp_delete_backuphistoryorsp_delete_backup_and_restore_historyto truncate your backup history...regards karl
2004-09-09
The problem is indexes then. Either create or check the health of the indexes on "Calls.JOB_NUMBER", "VISITS.JOB_NUMBER", "VISITS.VISIT_NUMBER". Unless you are on a very slow box this should in 1-2 seconds.
2004-08-27
Hi Dave,You do have an interesting issue. I would certainly be concerned over the integrity of your data. The first thing is to preserve as much of your data as possible, I would recommend BCPing all your data out to text files and store these in a safe place.Next you should have a look at the […]
2004-07-20
It is listed as freeware under the downloads option and not under the regular product section. I have used it before and found it to be effective. Here is the linkhttp://www.lumigent.com/downloads/schemaalert/
2004-06-24
By James Serra
Microsoft Copilot is an app that uses AI to help you find information, create content,...
By Steve Jones
Test Data Manager (TDM) is a suite of products from Redgate that make it...
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
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