|
|
-
|
|
Recently while working with one query to get schedule jobs status, i used xp_sqlagent_enum_jobs object which gives details of state values of all jobs in msdb database and this is undocumented object. But received an error while running following query ...
|
|
-
|
|
Because of data growth and performance issue we need to move tables or indexes to other filegroups. The purpose of moving tables or indexes to improve the database performance as it reduce I/O from single drive or single filegroup. We can create another...
|
|
-
|
|
This week, I resolved one issue which I received continuously which is noting but exactly displayed in post title. The issue occurred when I ran ssis package with batch file or scheduled job and same error message raised. Source: Start Exe...
|
|
-
|
|
You all know about the database file structure as whenever we created databases without specifying file location and filegroups , they will be created in default path and default filegroup. Here i have tried to created a new database without defining an...
|
|
-
|
|
You may worked with xml and you may aware of title mentioned in this post. Today when I was working to collect information from one table which having xml column, I was trying to open xml data result set from query analyzer with new query window. For so...
|
|
-
|
|
A while before few weeks, I discussed about an error of replication “The row was not found at the Subscriber when applying the replicated command”. We had a tricks to get discrepancies for error table and resolved issue. Let me put another method (Actu...
|
|
-
|
|
A week ago, I posted for Insert, Update and Delete statement with TOP clause and Merge statement as individual post. If you not read those posts then read it before to move next. In this posts I used TOP clause with DML operations and Merge statement bu...
|
|
-
|
|
A few days back, I spoke about the manual failover of mirroring and also explained one issue and workaround too. Continuing with the same failover, I want to express one more issue here. This issue is not very critical but it somehow to create an issue ...
|
|
-
|
|
As a DBA, disk space is an important factor for daily monitoring and I encountered one issue for same for disk space. I found it based on disk space statistics report from all servers. I investigated disk space usage of all databases and found msdb sys...
|
|
-
|
|
Today I asked by my friend for merge statement and identity insert, how to insert identity column data using merge statement? I posted for the merge statement without identity insert. Please read that post first before move ahead. so I would like to pub...
|
|