Query Optimization - Interesting Observation of Compute Scalar before (dotnetkicks.com)

published 2 days, 1 hour ago, submitted by pinaldave(6378) 3 days, 21 hours ago

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate February 5, 2010 by pinaldave | Edit 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 the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by the query. Click more for further story. read more...

add a comment | category: Database | Views: 226

tags: SQLAuthority SQLServer SQL Database pinaldave another

How to Convert Hex to Decimal - A simple puzzle (blog.sqlauthority.com)

published 3 days, 20 hours ago, submitted by pinaldave(6378) 9 days, 3 hours ago

How to Convert Hex to Decimal - A simple puzzle? Let us see if you have answer to this simple puzzle. read more...

1 comment | category: Database | Views: 389

tags: SQLAuthority SQLServer SQL Database pinaldave another

SQL SERVER – Find Statistics Update Date – Update Statistics (blog.sqlauthority.com)

published 12 days, 14 hours ago, submitted by pinaldave(6378) 14 days, 22 hours ago

Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to update the statistics if query is not optimal. Please note that there are many other factors for query to not perform well; expired statistics are one of them for sure. read more...

3 comments | category: Database | Views: 173

tags: SQLAuthority pinaldave SQLServer Database SQL another

Unique Nonclustered Index Creation with - A Transactional Behavior (blog.sqlauthority.com)

submitted by pinaldave(6378) 29 days, 16 hours ago

When we have situation where we are dealing with INSERT and TRANSACTION, we can see this feature in action. Let us consider an example where we have two tables. One table has all the data and the second table has partial data. If you want to insert all the data from the first table to the second table and insert all nonduplicate values, you can use this feature. read more...

add a comment | category: Database | Views: 61

tags: SQLAuthority pinaldave SQLServer Database SQL another

Fastest Way - Comma Separated Values (CSV) from Table Column (blog.sqlauthority.com)

published 1 month ago, submitted by pinaldave(6378) 1 month, 1 day ago

Learn the Fastest Way to get Comma Separated Values (CSV) from Table Column read more...

3 comments | category: Database | Views: 428

tags: XML SQLAuthority pinaldave Database SQL another

Generating Dynamic HTML Tables with jQuery From an In-Memory DataTable (www.codecapers.com)

submitted by mceranski(115) 1 month, 2 days ago

A step by step tutorial which will walk you through the steps to: 1. Run an asynchronous SQL query against a database using JQuery 2. Serialize the data as a JSON string 3. Render the table data dynamically with jQuery to build an HTML table. read more...

add a comment | category: ASP.NET | Views: 12

tags: SQL jQuery AJAX ASP.NET another

Differences in Vulnerability between Oracle and SQL Server (blog.sqlauthority.com)

published 1 month, 2 days ago, submitted by pinaldave(6378) 1 month, 5 days ago

In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: Read the whole article read more...

3 comments | category: Database | Views: 464

tags: Oracle SQLAuthority pinaldave Database SQL another

SSMS tab grouping with Tabs Studio (tabsstudio.wordpress.com)

submitted by SergeyVlasov(35) 1 month, 16 days ago

SQL Server Management Studio uses quite different scheme for tab names from Visual Studio. I’ve significantly improved SSMS support in the next Tabs Studio version... read more...

add a comment | category: Database | Views: 5

tags: SQLServer SSMS Database SQL another

How to get sql server 2008 intellisense working for schema changes (cherupally.blogspot.com)

submitted by kcherupa(255) 1 month, 19 days ago

The new feature "intellisense" added in sql server 2008 is making my life easier. And I am enjoying this feature a lot. But I noticed many times that when we make any changes to DB schema like creating / modifying database objects we don't notice the schema changes in intellisense in the same session. This made me too bad and many times I cursed Microsoft for this inclomplete feature. But after making some research on this, I have found the solution to get ... read more...

add a comment | category: Database | Views: 1

tags: Server Schema 2008 Database SQL another

Difference TempTable and Table Variable (blog.sqlauthority.com)

published 1 month, 21 days ago, submitted by pinaldave(6378) 1 month, 25 days ago

A Myth Busted. Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by suggesting following: Temp Table and Table Variable — both are created in TempDB and not in memory. read more...

6 comments | category: Database | Views: 381

tags: SQLAuthority pinaldave SQLServer Database SQL another

Mindscape LightSpeed 3.0 – Advocating a Commercial ORM (ericswann.org)

published 1 month, 26 days ago, submitted by ericswann(145) 1 month, 27 days ago

Compares the features of Mindscape's LightSpeed 3.0 ORM with those of LINQ to SQL and NHibernate. read more...

5 comments | category: Architecture | Views: 339

tags: Architecture To LINQ SQL NHIbernate another

Azure Start Guide – Step by Step Installation Guide (blog.sqlauthority.com)

published 2 months, 3 days ago, submitted by pinaldave(6378) 2 months, 8 days ago

One of the kind article about how to start right away with Azure read more...

3 comments | category: Database | Views: 427

tags: SQLAuthority Azure pinaldave Database SQL another

Comma Separated Values (CSV) from Table Column (blog.sqlauthority.com)

published 2 months, 10 days ago, submitted by pinaldave(6378) 2 months, 15 days ago

You need it yesterday, bookmark today and use it tomorrow! read more...

1 comment | category: Database | Views: 329

tags: SQLAuthority pinaldave SQLServer Database SQL another

A Common Design Problem – Should the Primary Key Always be a Clustered (blog.sqlauthority.com)

submitted by pinaldave(6378) 2 months, 17 days ago

The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover, is there any case, where one would not do the same? read more...

add a comment | category: Database | Views: 51

tags: SQLAuthority pinaldave SQLServer Database SQL another

Interesting Observation – TOP 100 PERCENT and ORDER BY (blog.sqlauthority.com)

submitted by pinaldave(6378) 2 months, 17 days ago

If you have any similar ideas as the above one, please leave a comment here. read more...

add a comment | category: Database | Views: 53

tags: SQLAuthority pinaldave SQLServer Database SQL another

Download Sql Server 2008 R2 November CTP (praveenbattula.blogspot.com)

submitted by praveenbattula(395) 2 months, 20 days ago

Get the latest version of Sql Server 2008 version R2 [CTP] read more...

add a comment | category: Database | Views: 1

tags: Server 2008 Database SQL another