Viewing 15 posts - 4,021 through 4,035 (of 7,496 total)
keep in mind partitioning is realy an advanced topic !
Books online has very good info and is a must read and try out !
And off course, Kimberlys very good WP:
Microsoft...
February 13, 2009 at 3:57 am
while you are at it ...
I always run the check for data purity after a restore from a lower version of sqlserver.
/*
* To be executed after a db-restore from...
February 13, 2009 at 3:52 am
Actually, I query sys.traces to import the trace file to figure out file extends, ...
There is nomore info for trace id 1 !
No info at all because we are not...
February 13, 2009 at 2:28 am
hopping in very late ....
but maybe this query gets you on the rails ...
Select *
from sys.trace_subclass_values TSV
inner join sys.trace_columns TC
on TC.name = 'objecttype'
...
February 13, 2009 at 1:51 am
My default trace crashed because .... disk is full
2009-02-12 15:44:20.880spid116Trace ID '1' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the...
February 13, 2009 at 1:37 am
Jack Kennedy (2/12/2009)
..
I managed to copy / past the wrong hyperlink :blush:
Combine your query with this one :
SELECT object_name(i.id)table_name
, i.rows
, i.rowmodctr
, i.name as ixname
, STATS_DATE(i.id, i.indid) as ix_Statistics_Date
...
February 13, 2009 at 12:13 am
IMO it has to do with the original date range you specified.
SQLServer must have decided that set of data might be better served doing it in anoher way than generated...
February 12, 2009 at 11:59 pm
I certainly advise to read Steve's article series 😎
Off course, with sql2005 you can also use ddl-triggers to capture structural changes of tables, view, indexes, sprocs,...
Check out
Monitoring Changes...
February 12, 2009 at 1:39 pm
Oh yes... I should have highlighted "during planned downtime"
February 12, 2009 at 6:58 am
Actualy that's how I implement all scripts provided by an external party.
So during planned downtime (dev/qa/prod), just add a begin transaction on top of the script and if it fails,...
February 12, 2009 at 6:27 am
I searched SSC for
stats_date for all indexes
and it came up with:
http://www.sqlservercentral.com/scripts/Index+Management/30041/
February 12, 2009 at 5:11 am
Probably it will, but your existing object will not be available to others during your transaction and your db's catalog may get locked.
So keep you transactions as short as possible.
February 12, 2009 at 5:06 am
Vic.K (2/11/2009)
ALZDBA (2/11/2009)
How about using
select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
from information_schema.tables
where table_type = 'BASE TABLE'
order by table_schema, table_name
But it's good only for the actual database, isn't it? So, there is...
February 11, 2009 at 8:18 am
HanShi (2/11/2009)
Sorry, you are right. I remembered wrongly what I have learned in the past.:blush:
No worries ..... been there, done that :hehe:
abarber,
I'm glad you managed the work around.
Some times, that's...
February 11, 2009 at 8:00 am
Vic.K (2/11/2009)
EXEC sp_msforeachdb 'select * from sys.tables'
or, if you need one resulset:
select Replicate(' ', 128) DB, * into #temp from sys.tables
delete #temp
exec...
February 11, 2009 at 5:42 am
Viewing 15 posts - 4,021 through 4,035 (of 7,496 total)