RE: Buffer cache calculation
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-09
databases
RE: Tables with tree structure
A standard recursive call would involve a cursor but that is a dirty word on this forum. Depending on the target application you could use a 'fragment caching' technique. Fragment caching is saving a frequently used query to the application cache, for example standard navigation. But without knowing your target I can't say. Another technique […]
2003-06-09
1 reads
2003-06-04
1 reads
RE: slow enterprise manager
Same here: just after .NET framework along with VS Studio.NET were installed, EM became slower. This particular one also connects to both SQL7 and SQL2000, but that's pretty normal.
2003-06-04
RE: DTS and web page grab
Hi Rolf, after reading what php fopen() does, I think the FileSystemObject might be equivalent to it. I'm not sure if this will work on a remote site, but you can use an ActiveX Script Task with this script. I've found this in MSDN '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Const ForReading […]
2003-06-02
RE: Why detach?
Detaching just cleans up sysdatabases and sysfiles. Nothing at all wrong with stopping the server, copying the files to a different server and attaching. Doesn't affect anything. You'd use detach to avoid stopping the service on the original server. If you need a copy without stopping the server OR losing access, then you have to […]
2003-05-29
1 reads
RE: Restore with STOPAT
I am doing it in EM and this is the only log backup and I have SP3 for mai SQL2000. So should I do this in query analyzer?
2003-05-28
1 reads
RE: return value from exec(string)
The example I gave was not the best in that it immediate brought up questions of why I was trying to generate the key in that way in the first place. The situation is more one of coming into a place where they keys are generated in this way, but for each table and I […]
2003-05-22
2 reads
RE: permissions to start sql server agent
You always have the option attacking this via other methods: 1) In Windows 2000, you can set the service to restart itself (services.msc). This is the easiest approach. 2) You can have a monitoring process that looks for SQL Server and SQL Server Agent and makes sure they are running. If they aren't, it restarts […]
2003-05-20
RE: New To Replication
To some degree it will, depends on how you replicate the transactions. If you replicate the stored proc call, one big transaction is one big transaction. If you're replicating the data changes, SQL limits how much goes over per batch. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-08
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