If it's happening every minute, I'd be willing to bet someone has a SQL Agent job set up to check something on a dev server every minute and they've pointed...

Depends. I've seen instances where the firewall was configured for the traffic necessary for the SQL Server to communicate but not the traffic the browser service needed to communicate....

Hmmmm......

15K rows per hour is WAY too slow. Something is wrong somewhere. What's the definition for the target table? Does it have a trigger of any kind?...

Used it on Sybase and it's great. The information it brings back is very good at pointing out the worst bottlenecks and the server overhead was pretty small. ...

Seriously? I just want them to connect to the SSIS server so they can extract packages, work on the locally, and then import them back. For that they...

Run a profiler trace on the DB. Find out what it's really doing. If it never really issues any ddl commands, then create the new group as discussed...

If this is a 64 bit SQL Server instance, you may need to use this:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

There's not enough information for anyone to help you with anything other than a random guess. Please post the definitions for the underlying tables, including any indexes, the view...

21.3333 can't fit into a (5,5) numeric. 21.3333 has 2 numbers to the left of the decimal, but (5,5) indicates that all the numbers will be to the right...

How about:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[ufnlastcolumn](

@col1 varchar(255), @col2 varchar(255), @col3 varchar(255), @col4 varchar(255)

)

RETURNS varchar(255)

WITH SCHEMABINDING

AS

BEGIN

DECLARE @ReturnValue varchar(255);

set @ReturnValue = 'a';

If @col1 > @ReturnValue

set @ReturnValue =...

I think the 'case' in the 'group by' is confusing things. What happens with:

select

m_mainid,

case

when memberid in ('A','B','C',) then 2000

when memberid = 'E' and m_mainid in...

If you need to move data and structure back and forth, SSIS is probably your best bet.

Are you sure you're getting the right bcp? Does bcp -v still tell you it's Sybase? What happens if you use the full path name to call bcp,...

While rowid and sqlstr are column names in your table, you are also using variables @rowid and @sqlstr in your code without ever declaring them. Add the declaration for...

If this is SAN attached, you might take a look at any latency reports you can get from the SAN that indicate increased latency during your slow periods. This...