Viewing 15 posts - 4,036 through 4,050 (of 7,503 total)
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
HanShi (2/11/2009)
February 11, 2009 at 5:04 am
If you were on CU10 or 11 of SP2, I'd suggest you go on to CU1 of SP3 to get to the same software level.
February 10, 2009 at 11:45 pm
It's always nice if some one makes life easy for you. 😎
As always, adding default values for columns is something that depends on the needs of your data model !
If...
February 10, 2009 at 2:09 pm
As Chad stated, there is a CU1 for SP3 (released at about the same time as sp3 itself).
To apply it to a SP2+CU10 (or CU11), you can directly apply SP3...
February 10, 2009 at 12:52 pm
You just need to start it. No configuration needed.
Just be sure you use Local System service account !
(just as a best practise. In clustered env. you need it to be...
February 10, 2009 at 12:33 am
We run AV on all our servers.
For db servers we exclude the db file locatons as well as the location of the backup files.
We recently had an issue with one...
February 9, 2009 at 2:23 pm
You need to start SQLBrowser service for your applications to be able to find and use the instance.
(unless you connect directly using the actual port number)
February 9, 2009 at 2:18 pm
Although Greg's solution works, you should still pose the question if you need to do this in a query!
Presentation should be handled at the front end application !
(one of the...
February 9, 2009 at 2:14 pm
Did you try :
declare @begin datetime, @end datetime;
set @begin = getdate() - 1 -- dateadd(hh,-1,getdate())
set...
February 9, 2009 at 10:21 am
Viewing 15 posts - 4,036 through 4,050 (of 7,503 total)