I have been trying to create a complex view of tables in our local SQL Server 2000 database along with tables in the University's central storage. Between SQL Server databases, this is straightforward. In this case, the LINK_TO_AFFILIATE linked server is a Sybase DB. Here's a simplified example of what I'm trying to do: CREATE […]
2001-07-18
6 reads
I will be collecting data every quarter from clients. How can I estimate the size the database will get. I am looking for disk space usage calculations. Is there a reference book to help with this? Thank you in advance. cwiney
2001-07-17
5 reads
I need to be able to gather generic information regarding I/O. I want to know the number of reads & writes by database/table that occur on the SQL Server. When I need to trouble-shoot the system, I can then in turn compare the I/O table read/writes with information from Perfmon to figure out which tables […]
2001-07-17
6 reads
Comments posted to this topic are about the content posted at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp
2001-07-17
4 reads
WebCast! June 27, 2001 from 9:00am to 10:30am Pacific Time. Registration closes 24 hours prior to the event start time.
2001-07-17
4,327 reads
SQL Server 2000 won't install on my machine. It aborts telling me, "Setup cannot continue because a file that needs to be copied is currently in use. Shut down other active processes. This error can also occur if virus-checking program is being used." I am not running any virus protection as yet and have shut […]
2001-07-16
15 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/lplatt/aspandadogotchaduplicatefieldnamesinaquery.asp
2001-07-16
8 reads
Hi all We're currently developing a VB application that (currently) uses MSDE as the back end. The data held in MSDE is fairly sensitive and as such we'd like to prevent users from bypassing the app and reading or copying it directly. I had thought that encryption would be the way to do this but […]
2001-07-12
28 reads
When I try to run a query from Query Analyser into a file in SQL 2000 the saved file has columns separated by spaces. So far it was working fine. However the last file we had to send to a client should contain 279 columns. The client uses SPSS. Trying to open the file we […]
2001-07-11
9 reads
Not again you sigh... 🙂 Well, its on for young and old and im in the thick of it yet again. Table and column naming conventions are what I am after as far are recommendations and tried and tested schemas. I have gone for the following for sometime now: Tables : name as required to […]
2001-07-11
407 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