We recently installed a EMC FC4500, and are running SQL2000(ent)on the SAN. We have noticed that the performance on SQL processes is slower (about afactor of6) on the SAN than on the original local RAID. We have noticed that when running the process on the DB that is on the SAN, the number of reads […]
2001-09-07
3 reads
Hello sql server Gurus, I have taken a backup(through maintenance plan) from SQLServer 7.0 server. I wanted to restore that onto SQLServer 2000 database. When ever I try to do that, it gives me the following error message. File you've specified is not a valid SQLServer database file. I am just copying it from the […]
2001-09-07
2 reads
I have been analyzing Analysis Services for a few months now and really like some of the features that it has. Currently, we use Essbase for OLAP. I was wondering if anybody can give me some insight into the size of the server I would need to support the usage of 200 users (50 concurrently). […]
2001-09-07
2 reads
BOL has become harder to use in this last edition. A problem is that the new functions and enhancements are not clearly marked to define which version of SQL Server will allow its use. A simple header at the beginning of each content page (like Knowledge Base) would show quickly which features will work with […]
2001-09-06
2 reads
I have a merge replication and in one table I can't insert new rows on the suscriber. SQL Server says that the identities interval is full, but I don't know how to reserve another interval. The replication runs without problems. Sorry for my poor english and thanks. Edited by - sergiofg on 09/05/2001 10:03:32 AM
2001-09-05
4 reads
Hi, I run a query on SQL SERVER 7.0 (select+inner join+left join) on a couple of tables (one of them has 25 milions tuples) as sp in a job and everytime I run this job I get blocked process in msdb db. Any ideas? Thanks in advance.
2001-09-05
5 reads
Hi all, I've made SQLMail send mails to my Exchange server and Outlook2000. But, my corporate is using Lotus. How do I send mails to my corporate mailboxes. Thanx in advance Parasu Parasu Raman
2001-09-05
2 reads
Dear Listers, I imagine that many organisations operate with SQL7 on W2K, and that someone has already gone through the task of investigation. I have read that this is not an ideal combination. Is anybody able to provide personal experience or direction to documentation that details potential problems. Thanks In Advance John
2001-09-04
6 reads
We backup the the trans logs hourly on a SQL 2000 server. The size of a particular trans log dump done at Sunday 9pm, was 94KB. This is typical. But one hour later at 10pm, the same trans log dump had a size of 317,368KB! The business is closed on Sunday, expecially labor day weekend. […]
2001-09-04
2 reads
I have stored my data my using insert into table1(password) values (encrypt('mypassword')). Now how can I display this password field onto the front-end (ASP/VB). I shall see only encrypted data. I want to decrypt data, because I have been storing data so that no one... even the system admin cannot see the data. But when […]
2001-09-04
20 reads
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