I've also been using Sql Litespeed on several boxes backing up around a terabyte of data across all servers. I had some issues with the older 3.0.123 and up untill the new 3.1.x versions all of that is running very well. All my backup and restore scripts are centered around litespeed as well. I don't […]
2004-07-21
As per BOL:SQL Server automatically updates this statistical information periodically as the data in the tables changes. The sampling is random across data pages, and taken from the table or the smallest nonclustered index on the columns needed by the statistics. After a data page has been read from disk, all the rows on the […]
2004-07-21
Well, you can always fire up Task Manager on his machine to see if there are any memory hogs running. Also, even a small database can have a large memory leak, and a small database can download huge amount of data (especially OLE objects & images) that could be a problem.Another thought: check his free […]
2004-07-21
Sorry if I wasn't clear. SQL Server 2000 still performs implicit conversions such as your example. However, if the varchar(12) column contains non-integer values, you may get an error when you specify an integer constant in the WHERE clause (WHERE causeno = 17741) because in order to compare values, SQL Server converts the value in the […]
2004-07-20
Hi everyone, I want to find the list and size of the top 10 indexes in a database. Does anyone have a query that I can use? Thank you!
2004-07-20
PeterWe've had this database and the TEMPDB both set to increase by 50% (both data and log files) and auto-shrink has been disabled. Unfortunately, to no avail.Current statistics for database is as follows:Data file size = 4084 MB (1447 MB free)Log file size = 133 MB (118 MB free)For the specific table that the data […]
2004-07-20
2004-07-20
I read that this is a default configuration, but where do I check to see if it is configured and how do I change it?
2004-07-20
1 reads
Question: What is better, a fill factor of 0, a fill factor of 100 or something in between? I know what a fillfactor is for, but something in BOL blurs the issue for me. Under Fill factor options it is more or less stated, that there is no difference between a value of 0 or 100:A […]
2004-07-12
6 reads
You have to have SQLAgentMail configured before you can send emails or pages to the operators you've setup. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-05-14
1 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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