Search results for query: *

I have a query that takes 5 minutes to run. I already posted a question about ideas on improving the speed here: http://www.tek-tips.com/threadminder.cfm?pid=962 But, my new problem is that it appears that whenever a user runs this query, it is preventing other users from inserting new rows...

Right now, our SQL server machine is setup as follows: C: is 2 drives setup in a RAID 1 configuration, 33GB in size, 25 GB free D: is 4 drives setup in a RAID 5 configuration, 203 GB in size, 49 GB free E: is 6 drives setup in a RAID 5 configuration, 101 GB in size, 10 GB free Currently, SQL...

I have a query that currently takes around 5 minutes to return results. I have run it through the Index Tuning wizard (on Thorough) and it had no recommendations. I will layout the query, the field types, and the current indexes. If you have any thoughts, please let me know. Here is the query...

For some reason our database has begun to slow down after the service has been running for a day or two. If I start up the server, and run a set of queries, their results are instantaneous. After the server has been running for a day or so, these same queries will take minutes to execute, and...

I was wondering if anyone could suggest a good resource (book, website, etc.) for learning SQL Profiler. From basics up through advanced techniques. Most books I see cover a meriad of SQL topics, and just have a small section on Profiler and what it does. I am looking for something that goes a...

In Enterprise Manager, I can go to Server-Management-Current Activity-Process Info and see a list of what is going on in the system. In isqlw I can get the same results by running sp_who2 Now, what I need to know... In Enterprise Manager, once I am looking at the Process Info list, I can...

I have an interesting problem with the following query... SELECT DISTINCT tbl_insite_manufacturer_def.insite_manufacturer_id, tbl_insite_manufacturer_def.manufacturer_name FROM tbl_server_installs, tbl_insite_feu_radio_events, tbl_insite_feus, tbl_insite_manufacturer_def WHERE...

We had 2GB of RAM in our Win2K3 Standard server, which is running SQL 2000. All 2GB of RAM was being used. The sqlserver.exe process in Task Manager was using 1,736,128K. We upgraded the machine to 4GB of RAM and rebooted. The sqlserver.exe process in Task Manager is still only using...

Our SQL 2000 install is running on a Win2K3 Standard server which has 2 processors. But, when you open Task Manager, there are 4 processor graphs. And each graph is different. Not like 2 sets of identical graphs. Also when you go to the Processor tab of the Properties for the server in...

I need to get the row count for all the tables in my databse. Rather than doing: select count(*) from table_name I was going to do: SELECT rows FROM sysindexes WHERE name = 'table_name' But this does not always return a row. For 90% of the tables in my database it does, but for the other 10%...

I am completetly at a loss for what is going on here. I have a query, which when given one set of values, executes in less than 1 second. Give it another set of values, and it take more than 1 minute to complete! Here is the query that executes fast: SELECT tbl_bin_group_detail.content_id...

I am looking to setup a procedure to perform reindexing of tables in our database. I am going to determine which tables need reindexing based on the Scan Density results off the DBCC SHOWCONTIG process. I got this method from the following article...

Can I setup Outlook 2003 to simply delete an email when I "delete" it, rather than sent it to the "Delete Items" folder? When I delete something out on my Inbox, I don't want to go to Delete Items and have to delete it again! Thanks.

Exchange 5.5 server, Outlook 2003 client Trying to delete the items in my "Sent Items" folder. Highlighted all messages, and clicked "delete". It's been running (hourglass) for over 2 hours! How long does it take just to delete messages? Shouldn't this be a fairly quick task? The folder has...

We have an Access MDB that was created in Access 2000 and has been running for 2 years without problems, and our entire user base was running Access 2000. Recently, some of the users got upgraded to Office 2003. For awhile, everything will rok fine. Then, people will start to get errors like...

Hi all, hopefully a simple question here: Just upgraded from Office 2000 to Office 2003. First thing I noticed in Access was that the grid in form design mode is very close together. Looked up how to change it in Help, and found the Grid X and Grid Y settings in the Form property sheet. But...

SQL 2000, all patches... We recently created a new database, and I added it to the job that I have created for all the other user databases, to do backups, transaction logs, integrity checks, etc. I did this simply by opening the Database Maintence Plan that was already in existence, and...

If I want to reference the bound column of a combo box in the criteria of a query, I put the following in the criteria: [Forms]![form_name]![cbx_name] Now what if I want to refernce another column of that Combo Box? I put the following: [Forms]![form_name]![cbx_name].Column(2) This is how I...

I have a pass-through query that Access apparently has decided to change the SQL of for some unknown reason. After being created through code and ran, it gets an ODBC Call Failed message, due to bad syntax. If I edit the Query manually and change it back to what I originally had and rerun it...

I have a question about the reporting of the current date and time, and the length of time something takes to accomplish. I have a Stored Procedure which has the following line at the top: PRINT 'Started - ' + CONVERT(varchar(30), getdate()) The procedure then executes a series of queries, and...