I use wmic for mount point

declare @table table (id int identity(1,1), textdata varchar(4000))

insert @table

exec xp_cmdshell 'wmic volume get capacity, drivetype, freespace, caption /format:csv'

; with cte as (

select Data.value('(/root/r/text())[1]','varchar(1000)')...

If it's a heap then add clustered index and then drop it to reclaim unused space.

HI,

It may be agent SQL Server Agent Job History Log limit is being breached (default is 1000 rows) you can look at msdb..sysjobservers for last run date and time.

HTH -...

ah well, I have seen that before where you think removing the extra select will improve performance but it doesn't. Anyway I am working on a look ma no...

hi sorry i haven't tested for performance or sure if this has been done but removed the ctelen

IF OBJECT_ID('dbo.DelimitedSplit8K') IS NOT NULL

DROP FUNCTION [dbo].[DelimitedSplit8K]

go

CREATE FUNCTION [dbo].[DelimitedSplit8K]

...

what about xml?

declare @table table (id int identity(1,1), textdata varchar(4000))

insert @table

exec xp_cmdshell 'wmic volume get capacity, drivetype, freespace, caption /format:csv'

; with cte as (

select Data.value('(/root/r/text())[1]','varchar(1000)') Node

, convert(bigint,Data.value('(/root/r/text())[2]','varchar(1000)')) / (1024...

if table was truncated before restart then the first insert after will be 0 instead of 1. This may not be desired so could you sys.identity_columns instead to get...

round trip of scope_identity()???? it's a return value of your method call. Please don't feed the bears.

Isa related ?. I want to only update a table's columns where the data has changed, but columns_updated is limited to tables with 32 columns or less.