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, [...]
Archive for the ‘SQL’ Category
SQL SERVER – Brief Note about StreamInsight – What is StreamInsight
Posted in DBA, Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged StreamInsight on February 9, 2010 | Leave a Comment »
SQL SERVER – Find the Size of Database File – Find the Size of Log File
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged SQL Log File on February 8, 2010 | 5 Comments »
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 [...]
SQL SERVER – SQL Server 2008 R2 Update for Developers Training Kit
Posted in Database, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on February 7, 2010 | Leave a Comment »
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 [...]
SQLAuthority News – Presenting Two Sessions at TechED Sri Lanka
Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged TechEd on February 6, 2010 | 5 Comments »
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 [...]
SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged Query Operator on February 5, 2010 | 2 Comments »
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 [...]
SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines and sys.dm_sql_referencing_entities
Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology on February 4, 2010 | 7 Comments »
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 [...]
SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun
Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on February 3, 2010 | 9 Comments »
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 [...]
SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Business
Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on February 2, 2010 | 2 Comments »
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 [...]
SQL SERVER – Question – How to Convert Hex to Decimal
Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on February 1, 2010 | 6 Comments »
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 [...]
SQL SERVER – Location of Resource Database in SQL Server Editions
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology on January 31, 2010 | 4 Comments »
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 [...]
About Pinal Dave
Pinalkumar Dave is a Microsoft SQL Server MVP and a Mentor for Solid Quality India. He has written over 1200 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He is also Regional Mentor for PASS Asia.

-
Blog Stats
- 12,658,682 (12 Million+)
SQLAuthority Links
.
My Homepage
My Resume
My Other Blog
I prefer Idera
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Top 5 Commenters
Categories
- About Me (67)
- Best Practices (96)
- Business Intelligence (23)
- Data Warehousing (37)
- Database (282)
- DBA (130)
- MVP (106)
- Poll (5)
- Readers Contribution (40)
- Readers Question (49)
- Software Development (67)
- SQL Add-On (92)
- SQL Backup and Restore (55)
- SQL BOL (11)
- SQL Coding Standards (20)
- SQL Constraint and Keys (52)
- SQL Cursor (28)
- SQL Data Storage (46)
- SQL DateTime (38)
- SQL Documentation (234)
- SQL Download (235)
- SQL Error Messages (134)
- SQL Function (125)
- SQL Humor (25)
- SQL Index (106)
- SQL Interview Questions and Answers (58)
- SQL Joins (65)
- SQL Optimization (77)
- SQL Performance (234)
- SQL Puzzle (27)
- SQL Security (121)
- SQL Server DBCC (42)
- SQL Server Management Studio (28)
- SQL Stored Procedure (102)
- SQL String (21)
- SQL System Table (53)
- SQL Trigger (24)
- SQL User Group (50)
- SQL Utility (128)
- SQL White Papers (48)
- SQLAuthority (414)
- SQL Training (1)
- SQLAuthority Author Visit (89)
- SQLAuthority Book Review (19)
- SQLAuthority News (383)
- SQLAuthority Website Review (33)
- SQLServer (96)
- Tech (978)
- Pinal Dave (968)
- SQL Scripts (565)
- Technology (1241)
- SQL (1239)
- SQL Authority (1239)
- SQL Query (1239)
- SQL Server (1239)
- SQL Tips and Tricks (1239)
- T SQL (1239)
-
Top Posts
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL Server Interview Questions and Answers Complete List Download
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
- SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
- SQL SERVER - 2005 List All Tables of Database
-
Authors
-
pinaldave
- SQL SERVER – Brief Note about StreamInsight – What is StreamInsight
- SQL SERVER – Find the Size of Database File – Find the Size of Log File
- SQL SERVER – SQL Server 2008 R2 Update for Developers Training Kit
- SQLAuthority News – Presenting Two Sessions at TechED Sri Lanka
- SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate
- SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines and sys.dm_sql_referencing_entities
- SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun
- SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Business
- SQL SERVER – Question – How to Convert Hex to Decimal
- SQL SERVER – Location of Resource Database in SQL Server Editions
-
Archives
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Pages
Category Cloud
About Me Best Practices Database Data Warehousing DBA MVP Pinal Dave Readers Contribution Readers Question Software Development SQL SQL Add-On SQL Authority SQLAuthority Author Visit SQLAuthority News SQLAuthority Website Review SQL Backup and Restore SQL Constraint and Keys SQL Cursor SQL Data Storage SQL DateTime SQL Documentation SQL Download SQL Error Messages SQL Function SQL Index SQL Interview Questions and Answers SQL Joins SQL Optimization SQL Performance SQL Query SQL Scripts SQL Security SQLServer SQL Server SQL Server DBCC SQL Server Management Studio SQL Stored Procedure SQL System Table SQL Tips and Tricks SQL User Group SQL Utility SQL White Papers Technology T SQL


