Hi folks - I want to dynamically create a diagram of our existing databases. The only thing I can find is in Enterprise Manager... Diagrams - and this appears to actually build a database for me (plus I have to do it manually).I want to point this tool to one of my databases and have […]
2004-03-10
2 reads
I'm relatively new to SQL Server and have been using it for a web based intranet application. Even though I have not encountered any problems, yet, from failing to qualify objects with the owner, this stills seems like good advice to me.Thanks for the article.
2004-03-10
Thanks everyone. Based on your input I was able to change the query so it was SQL compliant. A couple minor changes on the queries Frank and Gary wrote and I was in business. This saved me a lot of time and frustration.Thanks again.
2004-02-03
Is there a way that MSSQL can compress a backup while it is dumping it or after it dumps?
2004-01-30
Do you have the other two registered in EM or as an alias?
2004-01-23
1 reads
If all you have is this one task, why are you using DTS?How about breaking up the stored procedure execution into a few steps. Then use workflow and looping to perform the job.You can return a resultset in an ExecuteSQL task and loop through it. See the following,http://www.sqldts.com/default.aspx?298
2004-01-22
1 reads
Hi, I want to implement products/spare parts. I have the following schema <SCHEMA>tblProductproductIdproductCategroryId (refs tblProductCategory.categoryId)productNameetc tblProductCategorycategoryIdcategoryNameisSparePart (BIT)<\SCHEMA> Now, when I am searching for spare parts, I can use a udf to simplify my queries.. udfGetSparePartsSELECT DISTINCT p.productId, p.productNameFROM tblProduct p, tblProductCategory pc WHERE p.categoryId = pc.categoryIdAND pc.isSparePart= 1 So, I can select against the table that this udf returns, instead of […]
2004-01-13
The text in my bio seems to be truncated. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-29
I think that I would work at attempting to find another solution. It may be that the impact from a de-normalized table, and overhead of the triggers doesn't affect you right now, but going this route, rather than reworking the query seems excessive......I don't know your situation enough to say, it's just that this is […]
2003-12-29
1 reads
2003-12-22
1 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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