Viewing 14 posts - 46 through 59 (of 59 total)
Mainstream support is over for SQL 7.0 on December 1, 2005. The original date was moved to this date, because 2005 wasn't ready to release to market. As for how...
October 5, 2004 at 2:12 pm
Thank you all! This has been a very enlightening discussion, and I now have an interesting wealth of information to hand over. I'd like to thank Joe Celko for his...
October 5, 2004 at 9:06 am
ouch. I've never seen this, but I'll tell you what I'd be doing if I did.
I'd run DBCC CHECKDB to see if I had any errors. While that was running,...
September 25, 2004 at 9:45 am
I haven't looked it up, but Alter,Database, and File are the three search words for BOL that comes to mind. Or if that doesn't do the trick, then a restore...
September 25, 2004 at 9:31 am
If you were moving it to another database, I'd say yes. If you are just reattaching the database to the same server and you want to take the time to...
September 23, 2004 at 12:13 pm
Also, if the Pages/sec is usually around 0, that means your server is not having to page to the harddrive to service RAM requests. I'd say this was a good thing....
September 23, 2004 at 12:01 pm
The plug-in is much better than the 6.5. But I meant Multi-Server Administration option. In 7.0, it was called Master Console. Not a lot of people seem to use it....
October 10, 2003 at 8:56 am
That would depend on which SQL you mean? Microsoft SQL Server or SQL? One is a Relational Database Management System (RDBMS) and the other one is a programming language (Structured...
October 8, 2003 at 12:20 pm
I don't know if anyone would do this today, but I started out at help desk, and tortured the Network guys every chance I got to learn networks. Then I...
October 8, 2003 at 10:08 am
Phil,
Never even thought of either solution. Thank you SO much. Both are suitable for their purposes.
October 8, 2003 at 9:56 am
Thank you for answering. However, xp_cmdshell isn't available on the originating server because SQL Server isn't installed. Anyone else have any ideas? Possibly a third-party solution?
September 29, 2003 at 7:34 am
Thank you! Now I'm wondering about the memory requirements for my Data Warehousing database. I've got 4 GB, and I still wasn't able to get the code for a long...
September 25, 2003 at 11:50 am
I got this on a PROC that ran three SELECT INTO statements to temp tables then did another SELECT with JOINS on 2k SP3. I don't remember if it were...
September 17, 2003 at 9:07 am
Viewing 14 posts - 46 through 59 (of 59 total)