COUNT(*) Not Allowed but COUNT_BIG(*) Allowed in VIEW(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 8 months ago

One of the most prominent limitations of the View it is that it does not support COUNT(*); however, it can support COUNT_BIG(*) operator. In the following case, you see that if View has COUNT (*) in it already, it cannot have a clustered index on it. On the other hand, a similar index would be created if we change the COUNT (*) to COUNT_BIG (*).For an easier understanding of this topic, let us see the example here. read more...

add a comment |category: Database |Views: 107

tags: SQLAuthority pinaldave SQLServer Database SQL another

7 Freely available E-Books/Guides I found essential for .NET Programme(amazedsaint.blogspot.com)

submitted by Bognit(2125) 1 year, 8 months ago

Freely available E-Books/Guides I found essential for .NET Programme read more...

3 comments |category: ALT.NET |Views: 914

tags: ALT.NET another

How to Stop Growing Log File Too Big(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 8 months ago

A Simple Solution to Ancient Problem read more...

add a comment |category: Database |Views: 276

tags: SQLAuthority pinaldave SQLServer Database SQL another

What is an MVP? – How to become an MVP?(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 8 months ago

A Direct Answer to Famous Question! read more...

add a comment |category: Community |Views: 552

tags: SQLAuthority pinaldave SQLServer Community SQL another

Soft Delete – IsDelete Column – Your Opinion(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 8 months ago

"Deleted records aren’t deleted. Look, they’re right there!” There is interesting conversation on the subject going on. If you are doing this, this one is for you - read more...

add a comment |category: Database |Views: 410

tags: SQLAuthority pinaldave SQLServer Database SQL another

Adding Column is Expensive by Joining Table Outside View – Limitation (blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 8 months ago

A second part of the story regarding limitation of the views! I am sure you did not know this! read more...

add a comment |category: Database |Views: 114

tags: Database another

Use New Bing Maps Road Imagery In Silverlight Map Control(pietschsoft.com)

submitted by crpietschmann(11.3k) 1 year, 9 months ago

Recently the consumer facing Bing Maps site changed the map imagery that is displayed for the Road map mode. This map imagery has not been officially made available for Bing Maps for Enterprise developers to use within their applications. The imagery is only officially available to the Bing Maps consumer website. Unofficially, you can still access the imagery if you know the URL format to get it. Below is an example of using the URL format for the new imagery to display it within the Bing Maps Silverlight Control. read more...

add a comment |category: Silverlight |Views: 36

tags: BingMaps bing Silverlight another

Fix for the ever-growing Search and Replace Dialog(connect.microsoft.com)

submitted by yesthatmcgurk(4063) 1 year, 9 months ago

MS just released a fix for the ever-growing Search and Replace dialog for Visual Studio 2010. Been waiting for this since RTM! read more...

add a comment |category: Visual Studio |Views: 24

tags: VisualStudio another

Dear DBA and Programmers Take Vacation!!!(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 9 months ago

A very simple article containing advices and suggestions about how a most responsible job owner can take vacation without any worry. read more...

add a comment |category: Database |Views: 397

tags: SQLAuthority pinaldave SQLServer Database SQL another

Why SQL Server is better than any other RDBMS Applications?(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 9 months ago

I strongly suggest that you bookmark this post as this post can be used in future when you might want to write why SQL Server is better than any other RDBMS application. read more...

1 comment |category: Database |Views: 710

tags: SQLAuthority pinaldave SQLServer Database SQL another

SHRINKDATABASE For Every Database in the SQL Server(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 9 months ago

This article is an interesting story of Shrinking the Database. Do you Shrink your database - learn the story today! read more...

add a comment |category: Database |Views: 254

tags: SQLAuthority pinaldave SQLServer Database SQL another

Exchange Server 2010 – send and receive SMS text message(www.sarin.mobi)

submitted by sathai(262) 1 year, 9 months ago

Can anybody help me find where can i set the exchange server 2010 to be able to send and receive SMS text message from Outlook Web Access as it say here read more...

add a comment |category: Products |Views: 6

tags: another

Exchange 2010 - OMS in OWA(www.sarin.mobi)

submitted by sathai(262) 1 year, 9 months ago

Some you would have know about Outlook Mobile Service (OMS) from Outlook 2007, where you get to send and receive text messages directly integrated into Microsoft Outlook 2007 itself. But now in Exhange 2010 beta you can set up OMS directly into the Exchange server by mailbox account. read more...

add a comment |category: Products |Views: 6

tags: another

Computed Column – PERSISTED and Performance(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 9 months ago

Did you know computed columns are computed at run time? Yes or No? If yes, you know the answer of following question: Is it better with performance or not? If no, go on and read it... read more...

add a comment |category: Database |Views: 174

tags: SQLAuthority pinaldave SQLServer Database SQL another

jQuery Code Snippets for Visual Studio(johnnycoder.com)

submitted by johnsheehan(4785) 1 year, 9 months ago

Ben Griswold gives an overview of working with the jQuery Snippets for Visual Studio 2010, including how to get them to work with ReSharper read more...

add a comment |category: Visual Studio |Views: 13

tags: VisualStudio another

Introduction to BINARY_CHECKSUM and Working Example(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 9 months ago

If any row has any value changed, this function can be used to figure out if the values are changed in the rows. However, if the row is changed from A to B and once again changed back to A, the BINARY_CHECKSUM cannot be used to detect the changes. Let us see quick example of the of same. Learn the trick! read more...

add a comment |category: Database |Views: 149

tags: SQLAuthority pinaldave SQLServer Database SQL another