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

published 1 day, 14 hours ago, submitted by pinaldave(6378) 3 days, 10 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: 220

tags: SQLAuthority SQLServer SQL Database pinaldave another

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

published 3 days, 9 hours ago, submitted by pinaldave(6378) 8 days, 16 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: 382

tags: SQLAuthority SQLServer SQL Database pinaldave another

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

published 12 days, 4 hours ago, submitted by pinaldave(6378) 14 days, 11 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: 172

tags: SQLAuthority SQLServer SQL Database pinaldave another

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

submitted by pinaldave(6378) 29 days, 5 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

Service Broker Basics (sqlblog.com)

submitted by Jemm(9400) 1 month, 2 days ago

"I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not a lot of information out there to help guide you through the process. Here I'd like to walk you through the basics." read more...

add a comment | category: Database | Views: 8

tags: ServiceBroker SQLServer Database another

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

published 1 month, 1 day ago, submitted by pinaldave(6378) 1 month, 4 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

EntitySpaces ORM 2010 Preview (I and II) (www.entityspaces.net)

submitted by Mike.Griffin(2290) 1 month, 5 days ago

This is another quick progress video on EntitySpaces 2010. In this video we show off our esEntityCollectionView<> class which in ES2009 relied on ADO.NET DataViews. However, these are now entirely our own creation and far superior. Remember, we do not use ADO.NET under the hood anymore (see Part I here if you missed it). However, our data providers which read and write to the database of course. Also, we show off some very cool new debugging features that will really help you when debugging your EntitySpaces applications. And finally, with the use of implicit type casting operators, working with the proxy stub classes has become basically, well, transparent. read more...

add a comment | category: Architecture | Views: 14

tags: SQLServer Architecture EntitySpaces Database ORM another

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

submitted by SergeyVlasov(35) 1 month, 15 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

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

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

published 2 months, 3 days ago, submitted by pinaldave(6378) 2 months, 7 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, 16 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, 16 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

Understanding Table Hints with Examples (blog.sqlauthority.com)

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

Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how they are helpful. read more...

add a comment | category: Database | Views: 18

tags: SQLAuthority pinaldave SQLServer Database SQL another

Policy Based Management – Create, Evaluate and Fix Policies (blog.sqlauthority.com)

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

This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the system. It also provides additional administration assistance to DBAs and helps them effortlessly manage various tasks of SQL Server across the enterprise. read more...

add a comment | category: Database | Views: 42

tags: SQLAuthority pinaldave SQLServer Database SQL another