XTIVIA BLOG
Why do I need to update SQL Server statistics?
Introduction A question we are often asked by both our Virtual-DBA and Consulting customers is: Why do I have to update statistics if auto-update statistics is turned on? The short answer is that your data changes, and even if you have auto-update statistics turned on the...
Data source name not found and no default driver specified at System.Data.Odbc.OdbcConn ection.HandleError
Started: 1:03:12 PM Progress: 2012-02-08 13:03:15.24 Source: Data Flow Task Validating: 0% complete End Progress Error: 2012-02-08 13:03:16.15 Code: 0xC0047062 Source: Data Flow Task V91MOD APIMAG [1] Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC...
ORA-01502 Unusable Indexes
Encountering the ORA-01502 error due to unusable indexes in Oracle can be challenging. A client called with an issue running a script from a 3rd party vendor. He was getting Oracle error ORA-01502 while running the supplied script. The ORA-01502 is basically stating that there...
Release Planning in an Agile Environment
Customer: "When will you deliver the scope in our statement of work?" Consultant: "We are Agile, so we can't tell you that!" Customer: "At least give me a high-level timeline. When can I expect to see my deliverables?" Consultant: "Ask me again at the end of Sprint 3 after...
Making SASS Linear Gradient Mixins Behave in IE
A very large gift given to us user interface developers in Liferay 6.1 is the inclusion of SASS support. One of the many ways SASS comes in handy is handling prefixed CSS rules – instead of having to specify each rule every time you, say, want to declare a gradient, you can...
The Great Performance Chase with Informix
We all worry about the performance of our servers. It is what separates the DBAs from the pretenders. You just never know just what setting will be the one that makes the big difference. The worst part is that the setting that works today may hinder or not even matter...
How to Start SQL Server if You Lost TEMPDB Data files
Recently we migrated one of our client's SQL Server instances to a new server. During the migration we had moved the storage to the new server so the old server didn't have some of the disk drives that were previously mounted on it. After the migration the client requested that...
ORA-01105: Mount is incompatible with mounts by other instances
I recently came across an issue in a 2 node RAC, Oracle 11gR2 environment for one of our Virtual-DBA clients. The client dba had created a new spfile and placed it in ASM for node 1 and then tried to restart the instance using srvctl. The instance would not...
SQL Server 2005/2008: Deadlock while changing database to MULTI_USER mode
Msg 1205, Level 13, State 68, Line 10 Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Msg 5069, Level 16, State 1, Line 10 ALTER DATABASE statement failed. On a...
Using the SC cmd to Remove Orphaned/Hosed up Oracle Services from Window OS
Have you ever had a situation where Oracle database software or services have not been uninstalled properly or completely on a Windows OS? Well this happens more often that we would like. The options left to us at this point are either painstaking editing of the OS registry or...