Viewing 15 posts - 37,711 through 37,725 (of 39,456 total)
I'll try to look around, but AFAIK SQL doesn't maintain these types of statistics. Profiler, Performance Montitor were designed to do this.
Steve Jones
March 21, 2002 at 1:44 pm
Shouldn't be an issue. SQL is usually designed further ahead than Windows for scale. Supposedly SQL 2000 is 64bit ready. Just waiting for Windows.
Steve Jones
March 21, 2002 at 1:41 pm
At TechEd 2000, I heard a presentation about Microsoft.com. They talked about designing a stateless system because the use of "session" variables inhinbits your scalability. Each user is then "bound"...
March 21, 2002 at 1:32 pm
March 21, 2002 at 1:29 pm
March 21, 2002 at 1:25 pm
Personally, I'd let the instances compete and then see what happens. SQL does a good job of managing itself, though I'm not sure how the instances will work with each...
March 21, 2002 at 1:19 pm
I think you are doing this backwards. Any changes that you make to your production server should have already been made on your test database. That is the purpose of...
March 21, 2002 at 1:14 pm
I believe a detach / attach will work. You can also backup and restore from these two if I remember. Raul Sharma and Brian Knight have articles on this subject...
March 21, 2002 at 9:34 am
It sounds like you have an installation issue. I saw a similar post recently, search "dbase" and you should find it. Once this is up, it usually works, though I...
March 21, 2002 at 9:31 am
I use the backup restore method to move the backups. This is nice because if I need to to the development db twice in one day, I am not going...
March 21, 2002 at 9:29 am
March 21, 2002 at 9:27 am
I did this in v6.5, but used 2 tables. One for tables and one for columns to make notes. Basically objectname and comment fields.
Steve Jones
March 21, 2002 at 9:20 am
Here's a ref:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_l_9jfo.asp
I also used VB 6, W2K Pro, SQL 2K personal, to get a list of servers with this function:
Public Function ListAllServers(i As Integer)
Dim ServerList As NameList
Dim objDMO As...
March 20, 2002 at 5:37 pm
you are welcome. this is a handy feature, but I'm not thrilled with it's implementation in 2000. Can't get all the comments at once.
Steve Jones
March 20, 2002 at 3:33 pm
Not in SQL 7, but in SQL 2000, in design mode, there is a place to enter a comment.
Steve Jones
March 20, 2002 at 3:02 pm
Viewing 15 posts - 37,711 through 37,725 (of 39,456 total)