SQL server could not start cannot find object or property (0×80092004)
Recently I got a call from my team the users couldn’t connect the SQL server and it’s throwing error. As always, I checked the SQL server status via configuration manager and noticed the server 2008 r2 stopped. I tried… Read more
AWE has removed from SQL server 2012
AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit servers. To use more than 4GB memory you have to buy 64 bit servers.
A small organization may suffer because of this feature has removed from the next… Read more
SQL server 2012 does not start
Today is not a good day. Ha ha not like that
Usual I opened SQL server DENALI to play something it doesn’t open (start) it at all. It’s throwing error. Probably you know what I will do I went configuration manager checked the service… Read more
SQL server has three types of internal joins. I know most of folks never… Read more
Microsoft has given the SQL Server Denali CTP3 (Community Technology Preview) for public preview. You can download the SQL Server Denali CTP3 here.
I’m very interested to see the SQL Server Denali new Features.
SQL Server 2008 SP2 10.50.2418.0 latest cumulative update 5 available now. You may download and test it.
Cumulative Update 5 for SQL Server 2008 Service Pack 2
SQL server T-SQL best practice
He is working with Microsoft and see here his online activities MSDN. The topic this month is T-SQL best practice. It’s the both DBA and developers Topic/Job.
SQL server Database restores sequence Steps
It’s a simple task to the experienced DBAs. However it’s…
SQL server Disaster Recovery Options
The disaster recovery is really “It depends”.
What is disaster recovery?
Disaster recovery is called DR. Hmm…
In this post I am going to explain the importance of recovery models and backup types.
Why I am writing this post ?
Because, when I was teaching about the topic to my PHP friend .He got doubts on bulk logged recovery model and differential backups. I have given some… Read more
Restoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There is no direct way to do this like Backup/Restore. You can use an alternative ways.
The alternative ways are,
1. Generate Script
Microsoft SQL Server 2008 R2 SP1 CTP
SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.
Here is mine:
1. Too many indexes on a table… Read more
Shrinking the log file script for SQL server database
This script mainly for a DBA’s, because most of the time the log file grow again and again and eats up all the disk space and finally an application goes down.
Errors from SQL server error log:
Error: 9002, Severity: 17,…
INDEX DEFRAGMENTATION SCRIPT SQL 2000
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance. When you perform any DML operation (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. If you use predefined maintenance plan it will take much server resource and…
Difference between truncating and shrinking the transaction log file
I have noticed in many forum the frequently asked question is “Truncating and shrinking the log file both are same”
The answer is obviously NO. These both are totally different. Before going into discussion, let’s read the transaction log file…
T-SQL Tuesday #015: Automation:
How to setup the DB mail using Gmail account
In this article I am going to show the database mail setup steps with screen shots. When I tried to test one of my automation procedure in my friend’s laptop I got number of errors.Then I Goggled and found the solution.…