Feeds:
Posts
Comments

Archive for the ‘SQL’ Category

StreamInsight is a new event processing platform introduced in upcoming version SQL Server 2008 R2. Similar to other components such as SSIS, SSAS or Service Broker, it also needs to be installed along with the SQL Server.
Up to SQL Server 2005, Microsoft’s main focus on SQL Server was to build a platform to efficiently store, [...]

Read Full Post »

I encountered the situation recently where I needed to find the size of the log file. When I tried to find the script by using Search@SQLAuthority.com I was not able to find the script at all. Here is the script, if you remove the WHERE condition you will find the result for all the databases.
SELECT [...]

Read Full Post »

SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL [...]

Read Full Post »

I will be presenting following two sessions at TechEd Sri Lanka this week. I am very excited as this is very first time I will be presenting in TechEd event. I have previously presented many sessions but I have never presented at this premier Microsoft Event.
I will be presenting on following two subject.

The history of [...]

Read Full Post »

I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on [...]

Read Full Post »

Recently, I read a question on my friend Ritesh Shah’s SQL site regarding the following: sp_depends does not give appropriate results whereas information_schema.routines does give proper answer.
I have quite often seen that information_schema.routines gives proper dependency relationship where assp_depends returns an incorrect answer. However, as per book online sp_depends will be deprecated, and instead, sys.dm_sql_referencing_entities [...]

Read Full Post »

MVP Open Day South Asia was held in Hyderabad from Jan 20, 2010 to Jan 23, 2010. This event was a fun-filled event as well as an educational one. The event was held at Microsoft IDC at Hyderabad, the largest Microsoft Development location after Redmond. I had great time meeting my friends and some of [...]

Read Full Post »

MVP Open Day South Asia was held in Hyderabad from Jan 20, 2010 to Jan 23, 2010. This event was a fun-filled as well as an educational event. This event was held at Microsoft IDC at Hyderabad – the largest Microsoft Development location after Redmond. I had a great time meeting my friends and some [...]

Read Full Post »

In one of the recent projects, I realize the bottleneck of the query was an inline function which was converting Hex to Decimal. I optimized the inline function and reduced the query running time to one-tenth of the original running time. Later, I was eager to find out the script my blog readers might be [...]

Read Full Post »

While working on project of database backup and recovery, I found out that my client was not aware of the resource database at all. The Resource database is a read-only database that contains all the system objects that are included with SQL Server.
Location of this database is at different places in the different version of [...]

Read Full Post »

Older Posts »