Have you updated the statistics on the table lately?

Getting a start as a junior DBA is very difficult as there are very few positions out there to start with and most Juniors will come from a development or...

A few questions:

1. If you run the trace without filters for a short period of time do you see any of the events you want to capture being captured?

2....

Pretty much eveerything you need is in here:

http://technet.microsoft.com/en-us/library/hh213417.aspx

The most important things are the listener and setting the correct application intent on your connection string. Also not all database connectivity...

What are your requirements? Monitoring only, monitoring and alerting, do you just want only SQL Metrics, or do you want OS metrics as well?

one option if you have another SQL server available is to use that as a remote distributor.

I'm not sure what db those procs are in but I would suspect that...

havoc_rah (11/20/2013)

I am currently running a SQL 2005 Standard failover cluster with some 250 databases. I also use mirroring for some of my mission critical databases.

I...

For any packages we had that were developed in 2008 have been upgraded to 2012 so they can be stored in the SSISDB.

Im not 100% but I think...

For the SQL Logins (opposed to the windows logins) do they have the same SID?

Are all your SQL logins that exist on the principal server available on the instance hsoting the mirror which are used by your mirrored database?

sp_updatestats will update the statistics for all user defined and internal tables with the database you execute the procedure for.

http://technet.microsoft.com/en-us/library/ms173804.aspx

UPDATE STATISTICS is used when you only want to update the...

Do you have to use the Import and export wizard it can be achived in a few lines of code, for example importing a xmlfile into a column of a...

Your proposal should be fine as its not really any different to adding a secondary SQL 2008 SQL Cluster.

What you can do is take the passive node out from the...

Have you tired changing the package protecion level within the package in SSDT:

http://technet.microsoft.com/en-us/library/cc879310.aspx

Based solely on the error is your default sql collation "'Latin1_General_100_CI_AS_SC'"?

If so the last line in the errors tells you that you must use a collation that does not include...