Understand envirionmental\infrastrusture challenges

Plan for availability, growth, performance and security

Think distributed and federated

Expect the Unexpected

Follow Best practices

Network with other teams (e.g. network, san, security etc...)

Enjoy

Here's a good reference point for...

Hi,

Interesting issue with long shot feedback........

During your SMS wrapper, what location are you putting the database files you detached in earlier step?

Cheers,

Phillip Cox

Hi,

I would strongly agree with RAID 5 vs RAID10 recommendation, but also consider using a many disk for each volume for better throughput. If system isn't heavy on reporting,...

Hey,

For index rebuilds, the stats are updated as part of index rebuild process, but not for indexdefrag (e.g reorg.). If you opt for a reorg vs a rebuild, you...

Hi,

DBA's and storage team's must now work very closely together, as the SAN now plays a fundamental role in the foundation of high performing SQL Server implementations. As already...

hey,

It seems your log shipping is ok and the inital large log file is not an issue. Depending on the database activity, you will always have a pretty big...

Hey,

Are you running log shipping in standby mode or read-only mode?

Hi,

Run this in context of the database in question:

select * from sysobjects

where name like '%manager'

and type = 'U'

Thank you,

Phillip Cox

Hi,

Have you checked the size of the log backup file? If so, do you notice any size deviations?

Thank you,

Phillip Cox

Hi,

Here's an example query

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.tables

Where table_name = Manager

Thank you,

Phillip

Hi,

I was referring to SQL Server Alias, but nevertheless its worked out for you.

Thank you,

Phillip Cox

Thanks all!

With a slight change of plan in code, by changing from a number of "AND" to "OR", the query now runs in sub-second. We were dealing with a...

Hi,

You must use server names and not ip addresses when configuring replication. You can create an alias to workaround the name problem. As you mentioned, you can use...

Hi,

Have you tested access to distributor from IIS server (e.g. ODBC test) to ensure you can see distribution server?

Thanks,

Phillip Cox

Hi,

Depending on what your end result may be, you may want to look at something like Red-Gate SQL Compare to help consolidate objects into a single database, but you will...