I have been monitoring the procedure cache on my SQL 2000 DB. It is an Ecommerce DB. The procedure cache percentage is way low, about 12% average. Compiles are way up to around 100 average. Any ideas where I should start looking.
2001-12-28
2 reads
Hi, I am trying to figure out if a column exists in the system tables and if so to execute some code. I can figure out if the column exists, but how can I set a dynamic executed statement equal to another variable. Here's my code: DECLARE @myDB varchar(255), @myTable varchar(255), @myColumn varchar(255), @myOutcome int, […]
2001-12-26
Dear all, how can i change the source i.e database table and destination text file dynamically through vb application. Thank You
2001-12-21
1 reads
Our database has external files that need to be included in a user "topic/keyword" search. The files maybe different formats such as Word, html, Excel, pdf. Does SQL Server 2000 have tools/topics for creating an index/catelog table to have these files as part of the search? Thanks in advance...
2001-12-06
1 reads
We have a database that says we have 3000 views. Upon inspection 2100 of those are syncobj_.... What exactly is this? Thanks in advance.
2001-12-04
655 reads
Anyone have any suggestions on how to do this? I have some data in an Excel sheet that I transfer to a table in SQL SVR 2000. There is only two fields: one for customer name and then one that holds a string of account codes separated by commas (e.g. CUS001, CUS005, CUS010). I want […]
2001-12-04
2 reads
Hi, Everybody say that temporary tables are just like normal tables. But can we perform alter and update operations on temporary tables as we do for normal tables? I am facing a problem with temporary tables created in stored procedures in SQL server 2000. I have written a Stored procedure as follows: ---------------------------------------------- create procedure […]
2001-12-04
1 reads
Am I lost, I could not find the search function for these forums? It looks like Snitz which has a great search but I could find the link?
2001-11-30
3 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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