Hi all After some testing, I have found that the "duration" filter/column is a poor one to measure DML performance. The trace seems to pick up the duration for the entire elasped time for not on the DML to run, but its parse time, and connect/disconnect time for the transaction returning back to the end-user. […]
2001-08-23
34 reads
Yes, Are there any known "gotchas" to look out for when applying SQL SP3 in an NT 4 environent? Logins, Backup, DTS package, gotchas? (Some SQL boxes has SQL 7 SP1, others have no SQL Service Pack at all) Bill Salkin
2001-08-23
2 reads
hello andy, what i mean by not displayed is that the value for that particular field is being shown as <"Long Text"> and nothing else will try convert ok will let u know if something clicks by using convert thanks keyur
2001-08-17
Does anyone have information about setting up replication betwen the virtual servers in a cluster or is it the same as setting up replication on stand alone servers. Lance
2001-08-16
2 reads
Hi guys, does anyone know how to populate the page's text boxes and pull down menus using an initial pull down menu at the top without using a button? Is there any such way? Or do I really have to use the button thing? Right now, I have one that uses a button after the […]
2001-08-10
2 reads
We have stepped up the criticality level on one of our production db's (actually it is 4 db's) so I now have to setup replication and maintain a backup server. What would be the best type of replication to use? Are there any good replication resources (books etc..) available that might help? TIA, Matt
2001-08-10
3 reads
Hi everyone, I have a problem. Using DTS I created an Execute SQL task that queries an SQL Server table for the maximum activity date and puts this date in a global variable. Then I use that value in the global variable in a Transform Data task to query the Oracle table by writing a […]
2001-08-09
8 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/achigrik/sqlserver7:someusefulundocumenteddbcccommands.asp
2001-08-09
9 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/achigrik/sqlserver2000:someusefulundocumenteddbcccommands.asp
2001-08-09
2 reads
Has anyone got any figures of the effect on the server of processing XML in the database. I am currently of the thinking that to gain the most out of the server XML should not be used in the database. Any thoughts?
2001-08-08
8 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
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