|
|
-
|
|
As a maintenance activity DBA need to take care of the database backups and monitoring for the same because database backups are more important in recovery.Production live databases have more sizes and because of heavily size of the databases it is require more time and IO to maintain it. You can ......
|
|
-
|
|
Because of some security policies we need to require our code to be safe from Users who are going to use SQL Server database and objects of them and some outside threat. We have different different users to access the database objects or used for ......
|
|
-
|
|
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 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 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...
|
|
-
|
|
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...
|
|
-
|
|
Recently while working with database move to other location , I used tsql script to move them. There are some methods to move the database files to other like detach and attach files from new location and other one is with modifying database file locati...
|
|
-
|
|
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...
|
|
-
|
|
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 ...
|
|
-
|
|
Recently we have seen the post for database size information and script used for the same too. Hope you liked that post. Sometime we need to have details like database size for growth and disk planning as we viewed in earlier post, same way i am repeati...
|
|