RSS Feed
Archive for the ‘DBA’ Category
SEQUENCE in SQL Server 2011
February 9th, 2011 
wiseinn
By : Dinesh Asanka Jan 05, 2011 SQL Server 2011 (or Denali) has now arrived CTP. In this article I will look at a core new feature of SQL Server 2011 which is SEQUENCE. Well, if you are familiar with Oracle, you will already know all about this feature since it has been standard [...]
Posted in 
VALUES() and Long Parameter Lists – Part II
November 17th, 2010 wiseinn
Did you like this? Share it:Tweet
Showplan Operator of the Week – SORT
November 17th, 2010 wiseinn
Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the DML. Once again, Fabiano demonstrates why it is important to be aware of these operators when getting queries to perform well. Over the past few weeks and months, we’ve featured the ShowPlan operators used by [...]
Working with the INSERT statement in SQL Server
November 17th, 2010 wiseinn
Did you like this? Share it:Tweet
Oracle to SQL Server: Putting the Data in the Right Place
November 17th, 2010 wiseinn
Jonathan Lewis is an Oracle expert who is recording his exploration of SQL Server in a series of articles. In this fourth part, he turns his attention to clustered indexes, and the unusual requirement SQL Server seems to have for the regular rebuilding of indexes. In the previous article in this series, I investigated [...]
The DIS-Information Principle, Part II
November 17th, 2010 wiseinn
Database design simply involves populating a schema with tables that model sets of entities and relationships. A table will contain Columns that model an entity’s attributes and contain scalar values. What could go wrong? Plenty, unfortunately, when these simple principles are misunderstood or flouted, and Joe continues to itemise bad design practices that can cause [...]
SQL Speed Secrets
November 9th, 2010 wiseinn
Have you ever had the feeling that your application was slowed down by SQL Server, but didn’t know how to fix the problem? SQL Server performance management is usually reactive and focused on server health. Database administrators (DBAs) respond to trouble rather than avoiding it in the first place. And visibility is largely restricted to [...]
SQL Server Email Alerts Notifications
October 21st, 2010 wiseinn
As DBAs, we are often required to set up alert notification emails for various tasks. For example, there might be a requirement to set up notification alerts if a particular backup job fails. A while back, I came across the situation where I was asked to write a script which sent an email alert to [...]
