thanks everyone for your replies - that helps a lot but i do have another question.it will probably seem dumb but i am (sort of) new to the concept of querying multiple tables in one query. i know thats basic stuff but i just haven't had to to do that much until recently.anyway -
2005-04-26
My company hosts a number of SqlServer databases on remote dedicated servers. We are looking to move to another dedicated server because of issues we've had recently with the hosting company. We are trying to calculate how much disk space will be required to move the databases. The current database sizing can be attained by looking […]
2005-03-11
Does anyone know how to return the number of occurances of a string from a TEXT field. Thanks in advance.
2004-11-19
2 reads
i don't know if this is true or ondicative of another problem.we had a three tier app that handled hundreds of connections with no problems. ASAIK sql server handles the connection pooling.
2004-09-10
Find out from your system or mail administrators the name (or IP address) of your SMTP server. If you're going to use SQLMail, read through this Knowledge Base article, as it presents a reasonable coverage of how to setup SQLMail: http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556 If you're going to use SMTP without using SQLMail and you want to mail […]
2003-08-24
Public Role does not have update permission to all tables by default unless you grant it the permission. Create a new Role with proper permissions to select/update your particular tables and add your users as member of this new role.
2003-07-22
Hi Cneuhold Thanks for information. I'm dba from Brazil and the same thing happens at my MSSQL tools here. With your suggestion, the problem is resolved.
2003-07-11
There is a separate process that performs a disc to tape copy of the .bak files. And the backups are on a separate raid controller, not on the actual database server. I have looked into the maintenance plans and have suggested using that as an alternative for the very reasons you (mccork) have mentioned. Thanks!
2003-07-07
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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