RE: Third Party Replication Products
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-07-10
Sample Chapters
RE: Joining surrogate table entries into single field
This is a really interesting question! Here's how to do it without the cursor, but it still uses 1 temp table (will need 2 if Table 2 doesn't have an identity column). Script's to create test data at the bottom. These loops are super cheap...checking 1=1 is 50% of the costs! ---------------------------------- Declare @iID int, […]
2003-07-08
1 reads
RE: Temp Table results
Sounds like you are using an ADO object to open a file. Try reading the result into a DataSet object instead. If you must read using adoObject.Open, you will need to have a permanent table. Guarddata
2003-07-08
RE: SQL Profiler Trace
Have you looked at installing the SQL Server Client tools (including Profiler) locally? I often review Profiler trace files that are sent to me. If you also have SQL Server installed, you can load a trace file into profiler and save it as a table for additional query capabilities as cppwiz mentioned.
2003-07-08
RE: SQL Profiler Trace
What about running the trace on the server, storing the results in a table and querying the results from the client using Excel or Access ? Then you only need MDAC loaded on the client and not Profiler. Check out this article for more information on how to run the trace on the server:
2003-07-07
RE: Why add more memory?
Did you add the 3G switch in the boot.ini? Once you set that and reboot you should see the memory that SQL Server allocates increase. Hope this helps. David
2003-07-07
RE: Automatic table replacement
For the first problem. Creating 'linked' tables should work. The procedures might be more efficient since the SQL server engine is more powerful. However, you do introduce network overhead, so this might reduce the gain. Another problem might arise if you are using complex, updatable queries in Access. Some threads have been around that report […]
2003-07-02
RE: Copy Jobs between servers
you can create a script of the existing job by right clicking on the job, then 'All Tasks' the Generate SQL Scripts.
2003-06-24
1 reads
RE: Site Menu not working with Opera
I think you should consider a complete redesign of the navigation menu or maybe even the whole site (but don't you dare touch that logo!). That would spice things up! And for God's sake move on to asp.NET! The site and especially the forums could be running up to 80% faster /Tomi
2003-06-19
RE: Accessing all rows in an Update Trigger
I'm confused, or more likely misreading the problem. Won't "IF Update(column_name)" be either true for all rows affected in a set-based update, or false for all rows?
2003-06-10
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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