SQL SERVER – Copy Statistics from One Server to Another Server(blog.sqlauthority.com)

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

A very efficient way of copying database statistics from one server to another server without moving data. read more...

add a comment |category: Database |Views: 46

tags: SQLAuthority pinaldave SQLServer Database SQL another

Are you Database Developer or Database Administrator? (blog.sqlauthority.com)

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

Your opinion matters! Are you Database Developer or Database Administrator? read more...

add a comment |category: Database |Views: 250

tags: SQLAuthority pinaldave SQLServer Database SQL another

Known Unknown of System Stored Procedure of sys.sp_tables(blog.sqlauthority.com)

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

Do you know even simple query like sys.tables can kill the performance of your system. There are better thing to use: Read more... read more...

add a comment |category: Database |Views: 95

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – Encrypted Stored Procedure and Activity Monitor(blog.sqlauthority.com)

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

If you are using Encrypted Stored Procedure you not see them in Activity Monitor read more...

1 comment |category: Database |Views: 67

tags: SQLAuthority pinaldave SQLServer Database SQL another

The Limitations of the Views – Eleven and more…(blog.sqlauthority.com)

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

I am confident that you may know few and you may know many. I am now interested to read what all of you have to offer on this subject. I encourage all of you to go through complete series and write your own on the subject read more...

add a comment |category: Database |Views: 191

tags: SQLAuthority pinaldave SQLServer Database SQL another

Wait Stats and Health Check - A Path to Performance (blog.sqlauthority.com)

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

Wait Stat Analysis is very crucial for optimizing databases, but it is often overlooked due to lack of understanding. We perform advanced resource Wait Statistics Analysis and provide you with suggestions to optimize your database server. We train your DBA to make them skillful enough so they can perform this analysis by themselves in the future. read more...

add a comment |category: Database |Views: 87

tags: SQLAuthority pinaldave SQLServer Database SQL another

Sequential Guid Algorithm – Implementing Combs in .NET(www.developmentalmadness.com)

submitted by developmentalmadness(730) 1 year, 7 months ago

A class for generating mostly seqential guids (for loads under 1K/second) across system boundaries. read more...

add a comment |category: C# |Views: 34

tags: mssql SQL C# another

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

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

Utilizing SQL Server Templates(www.davidyardy.com)

submitted by dyardy(199) 1 year, 8 months ago

Within the Template Window create a new folder to store your custom templates, create a new template, paste the above SQL and Save. To use simply click on the template and Ctrl-Shift-M to be prompted for the variables and values. Great stuff. read more...

2 comments |category: C# |Views: 99

tags: SQL C# another

Introducing SQL Server CE 4.0 CTP(www.mikeborozdin.com)

submitted by MikeBorozdin(1146) 1 year, 8 months ago

Learn what SQL Server CE 4.0 means for ASP.NET developers. Find out where you can get it and how to install. And finally learn how you can create tables with no tools provided. read more...

2 comments |category: ASP.NET |Views: 344

tags: SQLCE SQL ASP.NET another

EntitySpaces in a RIA Services Silverlight Application Development Sce(www.entityspaces.net)

submitted by EntitySpaces(315) 1 year, 8 months ago

Whether RIA Services is merely a buzzword you’ve heard bounced around or you’re a seasoned Silverlight developer you should checkout this functionality. When you combine EntitySpaces with RIA Services you will almost instantly be able to create professional quality Silverlight applications. read more...

add a comment |category: Silverlight |Views: 50

tags: Silverlight EntitySpaces RIA Server 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

Writing a Silverlight Application Using EntitySpaces is Awesome(www.entityspaces.net)

submitted by EntitySpaces(315) 1 year, 8 months ago

Sometimes you’re so busy designing, coding, testing, and supporting a product that you don’t take the time to stop and appreciate what you have actually accomplished. A customer of ours asked us to create a video overview of our Silverlight functionality and in doing so we had to step back and say “wow”, this is pretty cool. It truly is easy to use EntitySpaces to create a Silverlight application as you will see. read more...

add a comment |category: Silverlight |Views: 262

tags: Server Silverlight EntitySpaces WCF SQL another

EntitySpaces Adds Support for SQL Azure and SQL Server Compact 4.0(www.entityspaces.net)

submitted by EntitySpaces(315) 1 year, 8 months ago

This release of EntitySpaces adds two new databases, adds Silverlight 4 support (we already supported Silverlight 3), provides some excellent proxy improvements, and finally it provides a few well placed customer requested tweaks. EntitySpaces 2010.1.0830.0 is available to customers for download now. Our trial version will be upgraded by Tuesday night, perhaps sooner. read more...

add a comment |category: Azure |Views: 26

tags: Server EntitySpaces Azure SQL ORM another