• Home
• Policy
• RSS

Archive for the 'Databases' Category

Happy New Year

Yazan: admin | 28 December 2008 | No Comments
Categories: Databases

I think that is my first blog which does not relate to SQL Server,though why not?I wish to SQL Server Consultants lots of contracts to help out businesses in 2009, I wish to SQL Server DBAs lots of interesting work but that their databases will run smoothly,I wish to SQL Server Developers to write [...]

Do you always write parameterized query?

Yazan: admin | 19 December 2008 | No Comments
Categories: Databases

As you know SQL Server creates an execution plan for the query/stored procedure and stores it in procedure cache in order to reuse it when you run the query next time.But more and more execution plans in memory will also hurt the performance as we do not have a control the procedure cache’s size [...]

When constraint remains in system table even the table is no longer exists

Yazan: admin | 05 December 2008 | No Comments
Categories: Databases

Ok, I’m talking about temporary tables and yes,it could happen to you even you think that the temporary table is no longer exists. Consider the below script where stored procedure inserts the data with wrong type which caused the error(245conversion error). As you propably know we would never name the constraints for local temporary tables [...]

Can I hide undesirable database in SSMS?

Yazan: admin | 13 November 2008 | No Comments
Categories: Databases

We have discussed the issue many times and there is an opened connection to Microsoft to add this feature in the next release. Recently I was visiting our client and we tried to do something for the subject.
1) CREATE new SQL login ‘John’2) CREATE a user named ‘John in master database3) GRANT CREATE DATABASE to [...]

Track down DDL Database changes

Yazan: admin | 23 October 2008 | No Comments
Categories: Databases

If you want to know who alters/drops/creates tables/views/stored procedures… I would like to share with you the following script. As you know DDL Triggers (introduced in SQL Server 2005) work very like the DML triggers but details of the event that fired the a trigger are available only in XML format.
Fist of all I create [...]