Viewing 15 posts - 316 through 330 (of 1,524 total)
Before you move run this special version of CHECKDB on each database
DBCC CHECKDB with data_purity
If you have time it is a good idea when you upgrade to a...
March 6, 2015 at 11:37 am
Here is the command to run against the databases you want to downgrade from Ent to Std edition
SELECT * FROM sys.dm_db_persisted_sku_features
March 6, 2015 at 11:29 am
If you are taking advantage of database options that are allowed in Enterprise Edition it is not possible to downgrade a db from Enterprise to Standard Edition. There is...
March 6, 2015 at 11:06 am
Has the number of rows in the tables that you are rebuilding the indexes on greatly increased? Has anyone created any new indexes?
March 3, 2015 at 1:19 pm
There are some pitchers that work extremely slow... some players that take way too many adjustments between every single pitch. Don't know how you can limit those without...
February 20, 2015 at 11:49 am
Funny. I would bet the pace of the game from 1981 until now has a significant jump in commercial time... they CERTAINLY won't cut that!
February 20, 2015 at 9:18 am
Looking forward to the season starting up again. Although my Red's I don't think are going to be that good. All star game is in Cincinnati for...
February 18, 2015 at 10:39 am
I think it would be absolutely fascinating to be a data analyst for a MLB Team. I am absolutely intrigued with Baseball stats.. I love listening to games and...
February 13, 2015 at 12:14 pm
Works very well for just jobs. However, if that job is tied to a Maintenance plan it generates the job part but is worthless without the maintenance plan.
February 4, 2015 at 11:27 am
I use maint plans for Update stats weekly and integrity checks daily.
Also a couple of other things to look into.... MSDB cleanup process (it is a task in Maint...
February 2, 2015 at 11:43 am
I have reached the peak of what I want to do. I like being a senior DBA. I have been a DBA since 1993.. first with Mainframe DB2,...
February 2, 2015 at 11:37 am
how long have you had this installed? Did SQL Server start previously OK?
Something odd happened or someone got in and changed startup parameters somehow.
February 2, 2015 at 11:29 am
silly question but I have to ask... are you running Update Stats on a regular basis?
SAN issues are the most difficult to pin down. It could be the BIOS,...
January 22, 2015 at 8:43 am
Very interesting. I had something similiar but it isn't as good as this one. Thanks for sharing.
January 22, 2015 at 8:37 am
You have some process that is doing it... maybe large temp tables... or are their any rebuild index jobs with sort in temp db running>?
January 14, 2015 at 10:28 am
Viewing 15 posts - 316 through 330 (of 1,524 total)