Question of the Day for 07 Apr 2004
Comments posted to this topic are about the Question of the Day for 07 Apr 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=220.
2004-04-06
Optimization
RE: MSDE installation rolls back
Check that the server service is running, I had an installation that was continually rolling back, but it completed as soon as I started the server service
2004-03-31
RE: do I have to DELETE then re-enter
The method depends upon whether and how you have used DRI...If, as your "schema" pseudocode implies, you have not used DRI, you can just use UPDATE statements on each table. If you don't have exclusive access to the database, then update both tables within an explicit transaction.If you use DRI with the ON UPDATE CASCADE […]
2004-03-11
RE: Disk performance issues
Looks like an Access design http://qa.sqlservercentral.com/columnists/sjones/pagesize.aspYou should try to stay within the limit mentioned in the article or rethink your design.
2004-02-02
RE: Reporting Services - typical Microsoft
Russ:I don't think the problem is so much the license cost of of VB studio, but how many people do you really want to give a tool with that complexity and capacity?Talk about empowering, just do the world a favor and buy them the tool that builds all the virus' out there why don't you.On the […]
2004-01-28
1 reads
RE: A Brief History of SQL
quote: Good one. In recent days I heard about Hirarchial Databases. What about them? Have they released?? The hiearchical database model is somewhat older than the relational model. I think the most prominent system is IBM's IMS which (still) runs on older mainframe systems. With the evolution of object-relational or object-oriented DBMS this model has […]
2003-09-16
1 reads
RE: DTS Package containing unused connections
Thanks. That works just fine! What I have to do is add a connection via the right click menu, choose an Existing connection and then Cut or Delete the icon. If I add a connection by dragging from the connections toolbar then I cannot delete the unwanted connection. Thanks.
2003-08-19
2 reads
RE: HOw to install sql server 2000 in laptop
quote: Thanks all for valuable suggestion,Actually i want to install sql server 2000 first,than my database and after that my application which is a exe file.All this i want from CD to my laptop in a single click.I want all this for demo purpose. If this is for a demo, you shouldn't need a full […]
2003-06-27
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers