Viewing 15 posts - 2,926 through 2,940 (of 3,232 total)
Run sp_who2 and look in the programname column. If SQL Profiler exists, someone is running a trace. You can then track it down by using hostname and login.
April 21, 2006 at 8:52 am
The no lock hint is equivalent to running in read uncommitted isolation level. This means that you could have dirty reads. I would guess that the nulls came from...
April 20, 2006 at 8:38 am
With as simple as your stored procedures are, your problem may be that the data pages are dropping out of cache. You may also look at pinned tables in BOL. ...
April 19, 2006 at 11:28 am
The first time a stored procedure runs, it is compiled and the execution plan is stored in cache. Execution plans are aged out of cache based on the frequency of...
April 19, 2006 at 11:17 am
Look up 'deleted tables' in BOL. You need to select firmfile, system_user(), getdate() from DELETED.
April 19, 2006 at 9:18 am
DTS will not meet your needs if you need real time syncronization like you've said. You must use replication or triggers.
April 19, 2006 at 8:33 am
Any process that creates a resource bottleneck could be the problem. You should be running your backups either during a maintenance period, or in non-peak hours to minimize the performance...
April 18, 2006 at 10:14 am
I do not mind paying taxes. Sometimes it seems like we pay alot in taxes, but we pay much less than people in other countries. I had an opportunity...
April 17, 2006 at 12:54 pm
I feel that the sole purpose of a job is to generate money for lifestyle. While it is good to feel like you are making a contribution and experiencing some...
April 14, 2006 at 9:00 am
If you are dealing with a large database that has constant pressure, I would not recommend using DTS as it will add overhead to your database and could impact performance. ...
April 13, 2006 at 1:35 pm
I usually start out at a high level with perfmon. Monitoring disk, memory, and cpu at a high level should tell you if you need to drill down more into any...
April 13, 2006 at 1:21 pm
It sounds like you are not very familiar with SQL Profiler, so if you are, please do not take offense as I am writing this from the standpoint that you...
April 12, 2006 at 3:35 pm
If you have an index on vendor_name, a 'where vendor_name like 'a%' should result in an index seek. If you don't have an index on this column, consider adding one.
April 12, 2006 at 3:08 pm
There isn't a canned script that will do what you are asking for. You must create one using the syntax that karthik suggested. Depending on what types of constraints you...
April 12, 2006 at 9:39 am
Of course, you could combine these 2 updates into one using a more complex case statement, but this should get you heading in the right direction.
declare @t table (Recreate_flag bit,...
April 12, 2006 at 9:18 am
Viewing 15 posts - 2,926 through 2,940 (of 3,232 total)