We have dedicated SQL Servers that have multiple instances of SQL 2K and a default SQL 7 instance. Once one of the SQL 2K instances is patched with SP3 it seems that any new instance that has to be installed requires either a reboot or to stop all SQL Server Services. Usually it only requires […]
2004-02-19
2 reads
You could try http://www.sqlserver-performance.com http://www.sqlteam.com
2004-02-14
I am more comfortable using OPENXML in a custom SP. But that is more because it is all I have tried.I have not found a nice way to use DTS for this. I think that what you can do in DTS you can do with a Visual Basic program running the XMLBulkUpload object.I have not […]
2004-02-03
This is my old scenario: Win NT 4.0 SP 6a in a Compaq Proliant PIII 500Mhz Single Processor, this is my PDC Server and also an MTS Server, A Win NT 4.0 sp 6a in a Dell PowerEdge 1300 PIII 500Mhz Single Processor, this is my server for MS SQL Server 7.0 sp4. I used […]
2004-02-02
Our developer complain slow processes, then ask me restore whole db in local server(in our company datacenter) to test compare their application with our power cluster server which sit very long distince from here, developer using from EM show me return from same table only 136 rows from EM for both server , which local server […]
2004-01-06
2003-12-08
We do it based on 24 hours for critical items on a complete failure (this gives us time to bring another server up and restore to it), 48 hours for required funtionality that is not critical and 1 week of bits and pieces crap (we call it non-essential functionality ). Deleted data restores are 24 […]
2003-12-03
No, the problem is not the code that makes the update. The trigger objects will recompile regardless of what object is doing the update. From our point of view: SQL server have three caching objects for triggers Single row trigger (setopts & 1024 = 1024) 2-4 row trigger 5- row trigger (same caching "space" as […]
2003-05-27
1 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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