This is to some extent the beginning of a standards document and I think a good start. Some additional thoughts: I think developers should be discouraged from creating a new database for each application, instead favoring having databases for related needs (related in particular by where they are needed, replication needs, backup needs). This reduces […]
2003-12-16
fhanlon, Thank you again for replying. Yes I need to have the old tables that the "warranty people" are still using moved or as you stated merged to the new server. So you recommend using the script or getting the SW thqat you mentioned. Keep in mind im fairly new to SQL. 🙂 So any […]
2003-12-15
Reminder: 32-bit DTS is not supported on a 64-bit box. You will need a 32-bit machine from which to run your tools. CynicalDBA, I read a review that said dts jobs ran considerably slower with 64bit. Have you seen this? Do you have a work around that is sufficient? We are considering the 64bit version, […]
2003-12-08
quote: OK still can't get it to work. Here is a simular example of what I'm doing using the Northwind database. This is the proc I'm executing exec crosstab2 'select top 20 shipvia from orders group by shipvia','count(shipvia)','year(orderdate)','orders','shipvia' Here is the output shipvia 1996 1997 1998 1996 1997 1998 1996 1997 1998 3 58 122 […]
2003-11-18
1 reads
quote: I ran it in our dev environment after copying some of our most complex DTS packages there. They were completely reorganized after I ran the script in your article. As per the article "Another thing you will notice is that the visual layout of various package components will change after this is run, but […]
2003-09-11
1 reads
2003-09-05
You need to pass the value 262144 (SQLDMOScript_OwnerQualify) in scripttype. See "Script Method (Table Object)" in BOL. A T-SQL example is: DECLARE @ScriptType BIGINT SET @ScriptType = 2 | 4 | 262144 EXEC sp_OAMethod @table, 'Script', NULL, @ScriptType Cheers, - Mark
2003-09-02
2 reads
SELECT Table4.col1, IIf([FirstOfCol2]=[LastOfCol2],[FirstOfCol2],[FirstOfCol2] & [LastOfCol2]) AS Col2, First(Table4.col2) AS FirstOfcol2, Last(Table4.col2) AS LastOfcol2 FROM Table4 GROUP BY Table4.col1;
2003-08-22
All the emails are flowing in from the past 12+ hours now. Seems to be catching up over here...
2003-08-08
Hi haremeher, quote: How can i optimise stored procedures in all ways. what so you mean by 'optimise'? With respect to runtime, reusage, resource utilization, readability.......? There are hundreds and thousands approaches to this. And yet no general recommendation, I think. So it depends on the specific case. Maybe some example would be helpful? Cheers, […]
2003-08-04
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