we are using linked servers but not much, only when there is a need for historycal data application uses linked server to retrive from another server, but most of the...

i have checked few times today, but the value does not seem to be fluctuating, it is still 27M, but good idea to log the values for a week or...

does the server where you are trying to create linked server resolves the name "SEV-DB01" . if not either use IP or create an alias for that server then retry.

the query returns 27 MB but dbcc memorystatus displays as below, MEMORYCLERK_SQLCLR (6G reserved) is that normal?

MEMORYCLERK_SQLCLR (node 0) ...

so 4G may not be enough for OS and CLR executions. how to check CLR memory usage?

what is the error that you see in job history for scheduled tnx job.

here is the table definition , partition funtion and partition schema used to partition the table.

CREATE PARTITION FUNCTION [part_fn](char(20)) AS RANGE

RIGHT FOR VALUES (N'20110325 ...

DBCC SHOW_STATISTICS indicates that statistics are up to date (showing few hours ago), and number of rows returning from query matches rows shown in execution plan. a week ago i...

yes we have an index on that column, and selecting few columns also does full scan.

Hi,

the details are:

version:SQL Server 2008 SP1 CU7 version 10.0.2757

connection:max number of connection 3000-3500

thread count:max worker thread is 400

no connections could be done even using DAC.

Thanks we already get hostname,appname for specific operations.We DBAs do administrative task on a terminal server with a SQL server generic user. If we cant get osuser somehow then you...

the problem is solved. i explicitly define table_name like db_name.dbo.table_name and it worked.

my bcp command was like

"use db_name select * from table_name queryout "D:\QUERY.DAT" -c -C RAW -t "<ec>"...

We aremoving data on daliy basis, but for some reasons the scheduled job failed for last 2 weeks and the amount of data grow.

now i am tring to bcp out...

I am trying to move a 60G table to a SQL2000 history server.Using DTS would take days.

thanks.

hi,

select @@rowcount will display the number of rows returned from your query.