Viewing 3 posts - 1 through 3 (of 3 total)
Found the answer to my own question.
Yes it is as i suspected. It is incremental. So if someone would like to get this value you should run:
declare @LazyPerSec bigint
SELECT @LazyPerSec...
May 1, 2013 at 6:44 am
thanx
I got a script that gives you all rows per filegroup in case someone needs it
SELECT
DB_NAME() AS 'DatabaseName'
,OBJECT_NAME(p.OBJECT_ID) AS 'TableName'
,p.index_id AS 'IndexId'
,CASE
WHEN p.index_id = 0 THEN 'HEAP'
ELSE i.name
END AS 'IndexName'
,p.partition_number...
April 11, 2013 at 8:51 am
Never ever use % on log file or DB...
I just had my first problem with that. I have 2 companies with the same software that we provide and both have...
April 11, 2013 at 6:16 am
Viewing 3 posts - 1 through 3 (of 3 total)