Viewing 15 posts - 211 through 225 (of 992 total)
You could at least index the department and salary columns to help speed up the join.
In SQL 2k5 you may be able to make it more efficient using some of...
January 17, 2008 at 5:44 am
The connection, being trusted, would be made using the user account under which your sql server is executing. Note that this is NOT necessarily the account you're using to...
January 17, 2008 at 5:38 am
Why not just move the where clause conditions for the right-hand table into the join condition rather than creating the derived table? Same end result although perhaps not as...
January 17, 2008 at 5:34 am
Perhaps your maintenance plan was doing some reindexing? If so then that's a logged change to your data causing the transaction log to grow.
January 17, 2008 at 5:31 am
You imply that you have several other MS SQL Servers. If we take the clustered server as server A, and you've tried to make it talk to both servers...
January 17, 2008 at 5:29 am
Good answers, except I'm not sure they fit the definition. The last answer given correctly gives the number of unique customers that placed an order in that month.
However, your...
January 16, 2008 at 2:56 am
If it's a data import you could
1. Drop the indices in the database before importing data, disable referential integrity, import the data, recreate the indices and then recreate referential integrity...
January 16, 2008 at 2:46 am
A primary key is the (usually sole) unique identifier for your table rows. By definition it cannot have any duplicates. The error message is indicating that you have...
January 16, 2008 at 2:45 am
The security described initially would require some sort of smart text parsing which could be overcome and perhaps break otherwise good queries...
The best thing would be to create a new...
January 15, 2008 at 7:53 pm
Get them to download SQL Server 2005 Express Edition and use the management tools that come with it to connect to your 2000 DB. I think you can even...
January 15, 2008 at 7:51 pm
If the problem is on the database server I'd suggest two things
1. Use SQL Profiler to see what else is happening on the server when the query takes longer than...
January 15, 2008 at 7:49 pm
Having read through all of the messages, it seems like some PMs were sent to explain things rather than putting them on the forum. My 2c and summary 🙂
Connection...
January 15, 2008 at 7:12 pm
Use the SysInternals utilities (Process Explorer or Process Monitor) to have a squiz at what's going on. You can see what files are in use by which applications....
January 15, 2008 at 2:23 pm
Stored procs, imho, are the better approach. Separate the database access code from the app. Initially it may seem like more work, but the CRUD stored procs don't...
January 15, 2008 at 2:17 pm
The presence of a deadlock does not imply your server is overworked - in fact they're not even correlated.
You said you had your database running on another server...
January 15, 2008 at 2:14 pm
Viewing 15 posts - 211 through 225 (of 992 total)