|
|
-
|
|
Backup and restore database activity is common and routine task for all DBA when need to move database at another place. I did the same thing while needed to move database from one server to other server. But suddenly i encountered one issue while...
|
|
-
|
|
A few days before, i just posted one article to check running scheduled jobs and i used master.dbo.xp_sqlagent_enum_jobs system objects and joined with dbo.sysjobs object from msdb database for same. Please read that post before moving down. This was on...
|
|
-
|
|
Some days ago, i worked to get failed jobs detail and an alert for the same. I used some system tables from msdb database to fetch the details for same. And msdb.dbo.sysjobhistory is one of the table among them which used in the script. But this table n...
|
|
-
|
|
Few days back, i was working to add new table in publication in transaction publication. After adding a article in publication and after reinitialized, i see nonclustered index was not copied at subscriber database. I tried reinitialized one more time a...
|
|
-
|
|
A few days back, while i was working with Alerts for failed scheduled jobs and missing scheduled jobs, i was needed to exclude running jobs. So we can exactly know which jobs are actually failed excluding running jobs and sane case for missing jobs. I a...
|
|
-
|
|
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...
|
|