2017-01-10 (first published: 2017-01-05)
881 reads
Database Space
Free space for all database files
I wrote this script to help determine which data files are taking up space on an instance.
2013-07-02 (first published: 2013-06-05)
1,548 reads
Database Space Capacity Planning
Describes a process to create a consolidated space forecasting report, which focuses on a "days remaining" metric.
2009-10-13
19,074 reads
RE: No Result set with a WHERE Clause.
I have sorted out this issue. It was a data quality problem between the UserEntered column and the LanUserId column ob the JOIN. Thanks to all for your help.
2004-12-16
RE: Optimize Your Applications
In fact, what I wanted to show is how to cache most-frequent and static (considerably) data. If data is modified often (like invoice table), this is not a solution. It is crystal clear. But every database has some data that is considerably static. Then definitely this scenario can be applied. Remember there are two options: […]
2004-02-11
1 reads
RE: Can't Open Default Database
Need some more detail on how you are trying to re-register the server. You had a SQL Server running and then what happened ? Files got corrupted or disk crashed ?
2003-07-29
RE: QOD june 27 select * from
quote: I think you've missed the point. There's a "feature" in ADO that struggles with text type. I did not mis the point of the question. But I think you've missed mine. My point is that you're application should not depend on the order of the columns of the table. You should never use select […]
2003-07-09
1 reads
RE: QOD june 27 select * from
So, the QOD was a test to understand if we knew the workaround for a bug that has been fixed since MDAC 2.1? Hmmm.... -- Si Chan Database Administrator
2003-07-01
1 reads
RE: Adding and removing Indexes
I suppose it depends on the maintenace scripts as well. If the index were to be used by a single script, the command could just be part of the script. Guarddata-
2003-06-27
RE: Adding and removing Indexes
Yes, you could do that as a job in SQL Server. I suppose the questions are how big are these tables and why go through the contortions to create the indexes nightly? Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance. Patrick
2003-06-27
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