DotNetShoutout

SQL

3
Shouts

Shout it

EntitySpaces in a RIA Services Silverlight Application Development Scenario

published 986 days, 20 hours, 22 minutes ago posted by

MikeGriffin 988 days, 5 hours, 37 minutes 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. (more)

category: Metro | clicked: 2 | comment | | source: www.entityspaces.net

tags: EntitySpaces, RIA Services, OR/M, SQL

12
Shouts

Shout it

Soft Delete – IsDelete Column – Your Opinion

published 988 days, 17 hours, 50 minutes ago posted by

pinaldave 990 days, 2 hours, 14 minutes 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 - (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

5
Shouts

Shout it

ssms tools pack

published 996 days, 16 hours, 56 minutes ago posted by

http://quachnguyen.myopenid.com/ 997 days, 1 hour, 24 minutes ago

SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2 and their respective Express versions. It contains a few upgrades to the SSMS IDE that I thought were missing. The current features include: • SQL Snippets • Window Connection Coloring • Query Execution History and Current Window History • Format SQL • Search Table, View or Database Data • Run one script on multiple databases • Copy execution plan bitmaps to clipboard or file • Search R... (more)

category: Data | clicked: 0 | comment | | source: code2code.info

tags: SQL 2008, SQL

10
Shouts

Shout it

SQL SERVER – Adding Column is Expensive – Limitation of the Views Part 2 « Journey to SQL Authority with Pinal Dave

published 998 days, 15 hours, 36 minutes ago posted by

pinaldave 999 days, 2 hours, 2 minutes ago

Let’s see another reason why I do not like Views. Regular queries or Stored Procedures give us flexibility when we need another column; we can add a column to regular queries right away. If we want to do the same with Views, we will have to modify them first. This means any query that does not need this column will start having the column’s data additionally. This will lead to added network traffic as well as it will reduce the performance of the part where the View is used. This further leads to a concl... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

2
Shouts

Shout it

DotNetRocks - Show #587 - Ted Neward Programs in Everything

published 1000 days, 19 hours, 8 minutes ago posted by

mithu 1001 days, 2 hours, 30 minutes ago

Carl and Richard talk to Ted Neward during the Live Weekend go back over the acquisition of Sun by Oracle and the potential for Oracle to muster a significant move in the development marketplace. Ted also talks about his exploring of other languages, including Objective-C for the iPhone. The conversation also explores how Oracle will have to rationalize their collection of databases: Oracle, MySQL and Postgres. (more)

category: Podcast | clicked: 1 | comment | | source: www.dotnetrocks.com

tags: DotNetRocks, iPhone, SQL

12
Shouts

Shout it

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 « Journey to SQL Authority with Pinal Dave

published 1000 days, 19 hours, 8 minutes ago posted by

pinaldave 1002 days, 6 hours, 37 minutes ago

Recently, I was about the limitations of views. I started to make a list and realized that there are many limitations of the views. Let us start with the first well-known limitation. Order By clause does not work in View. I agree with all of you who say that there is no need of using ORDER BY in the View. ORDER BY should be used outside the View and not in the View. This example is another reason why one should not use ORDER BY in Views. Here is the quick example for the same. I have used sample datab... (more)

category: Data | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

3
Shouts

Shout it

Cannot change column to Not Null: Cannot insert the value NULL

published 1001 days, 18 hours, 53 minutes ago posted by

codegain 1002 days, 20 hours, 53 minutes ago

Cannot change column to Not Null: Cannot insert the value NULL into column '', table '.dbo.Tmp_'; column does not allow nulls. (more)

category: Data | clicked: 1 | comment | | source: www.codegain.com

tags: SQL Server 2008, SQL, SQL Server 2005

13
Shouts

Shout it

SQL SERVER – Computed Columns – Index and Performance « Journey to SQL Authority with Pinal Dave

published 1002 days, 18 hours, 57 minutes ago posted by

pinaldave 1004 days, 4 hours, 36 minutes ago

This is the last article in the series of the computed columns I have been writing. Here are previous articles. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER – Computed Column – PERSISTED and Performance This article talks about how PERSISTED columns give better performance than non-persisted columns. SQL SERVER – Computed Column – PERSISTED and Performance – Part 2 This art... (more)

category: Data | clicked: 2 | 1 comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

9
Shouts

Shout it

Less known/used property: ExecValueVariable

published 1003 days, 20 hours, 10 minutes ago posted by

dhara 1005 days, 1 hour, 55 minutes ago

At times I have seen in SSIS forums people ask about the way they can know the number of records updated by a query or deleted by a query in an Execute SQL Task in control flow. Even I replied at times that its not possible(in a direct manner), until... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL, SSIS

10
Shouts

Shout it

Episode 59: Moving Applications to the Cloud on Windows Azure : Deep Fried Bytes

published 1004 days, 20 hours, 6 minutes ago posted by

raju 1006 days, 1 hour, 31 minutes ago

In this episode Woody sat down two members of the Patterns & Practices Cloud Guidance team at Microsoft to discuss Azure and the ways to get legacy applications to the Cloud. Also discussed during the interview was SQL Azure and Identity and Security in Azure. Thanks To Our Sponsor DevExpress products are built by developers for developers. We don’t believe in limitations or wasting anybody’s time. Our lightning-fast grid controls, slick reporting components and powerful IDE add-ins... (more)

category: Podcast | clicked: 1 | comment | | source: deepfriedbytes.com

tags: Cloud, DevExpress, SQL, Azure

13
Shouts

Shout it

Access a local SQL Compact database from Silverlight 4 - Blogs from the Experts

published 1006 days, 17 hours, 2 minutes ago posted by

jacobsebastian 1008 days, 6 hours, 11 minutes ago

In Silverlight 4, it is now possible for an elevated OOB application to access a local SQL Server Compact database. This post presents a walk-through that shows how to do this. (more)

category: Metro | clicked: 4 | comment | | source: beyondrelational.com

tags: Silverlight, SQL, sqlserver compact, Silverlight 4, ASP.NET

10
Shouts

Shout it

Dear DBA and Programmers Take Vacation!!!

published 1008 days, 15 hours, 34 minutes ago posted by

pinaldave 1010 days, 18 hours, 57 minutes ago

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

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

10
Shouts

Shout it

Why SQL Server is better than any other RDBMS Applications?

published 1009 days, 19 hours, 3 minutes ago posted by

pinaldave 1011 days, 20 hours, 12 minutes 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. (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

15
Shouts

Shout it

SHRINKDATABASE For Every Database in the SQL Server

published 1013 days, 19 hours, 51 minutes ago posted by

pinaldave 1014 days, 4 hours, 55 minutes ago

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

category: Data | clicked: 0 | 1 comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

5
Shouts

Shout it

Copy a table using SQL Server Management Objects

published 1015 days, 21 hours, 23 minutes ago posted by

http://baldi.myopenid.com/ 1016 days, 15 hours, 4 minutes ago

SwitcherSMO allows you to manage all objects which lives in the Microsoft SQL Server. It allows you to create, drop or alter objects from your .NET application with a API with is really easy to use. (more)

category: How To | clicked: 0 | comment | | source: www.mbaldinger.com

tags: SQL Server, .NET, SMO, SQL

6
Shouts

Shout it

SQL SERVER – Computed Column – PERSISTED and Performance

published 1021 days, 20 hours, 16 minutes ago posted by

pinaldave 1022 days, 16 hours, 59 minutes 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... (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

8
Shouts

Shout it

SQL Server - Count(*) or Count(1) ? - Which is better? - Dave Ballantyne's Blog

published 1022 days, 19 hours, 36 minutes ago posted by

jacobsebastian 1023 days, 4 hours, 44 minutes ago

This post explains the differences between COUNT(*) and COUNT(1) and helps you to decide which one is better (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: TSQL, SQL, Performance, SQLServer, Database

6
Shouts

Shout it

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example « Journey to SQL Authority with Pinal Dave

published 1023 days, 20 hours, 9 minutes ago posted by

pinaldave 1024 days, 16 hours, 23 minutes ago

In one of the recent consultancy, I was asked if I can give working example of BINARYCHECKSUM. This is usually used to detect changes in a row. 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 BINARYCHECKSUM cannot be used to detect the changes. Let us see quick example of the of same. Following example is modified from the original example taken from BOL. U... (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

What are the Sql Server Management Objects - Mattia Baldinger

published 1025 days, 19 hours, 40 minutes ago posted by

http://baldi.myopenid.com/ 1027 days, 12 hours, 10 minutes ago

What are the Sql Server Management Objects? It is a .NET library from Microsoft which allows you to access and manage all objects of the Microsoft SQL Server. It allows you to create, alter and drop objects like views, tables, jobs from your .NET application in a easy way. (more)

category: How To | clicked: 1 | comment | | source: www.mbaldinger.com

tags: SQL Server, .NET, SMO, SQL

4
Shouts

Shout it

How to Partition Table (a Non-Partitioned Table) using T-SQL in SQL Server 2008

published 1032 days, 14 hours, 45 minutes ago posted by

eralper 1033 days, 21 hours, 22 minutes ago

How to Partition Table (a Non-Partitioned Table) using T-SQL in SQL Server 2008 "Can we partition existing table in SQL Server ?", or "How can we add partitioning to a non partitioned table ?" are frequently asked questions about sql partitioning and partitioned tables in MS SQL Server among t-sql developers and SQL Server professionals. Especially partitioning non-partitioned tables may become a difficult task to partition an already existing table if it contains a lot of data and has many constraint... (more)

category: Data | clicked: 2 | comment | | source: www.kodyaz.com

tags: partition, SQL Server 2008, SqlServer 2008, SQL, T-SQL

Welcome!

SQL

EntitySpaces in a RIA Services Silverlight Application Development Scenario

Soft Delete – IsDelete Column – Your Opinion

ssms tools pack

SQL SERVER – Adding Column is Expensive – Limitation of the Views Part 2 « Journey to SQL Authority with Pinal Dave

DotNetRocks - Show #587 - Ted Neward Programs in Everything

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 « Journey to SQL Authority with Pinal Dave

Cannot change column to Not Null: Cannot insert the value NULL

SQL SERVER – Computed Columns – Index and Performance « Journey to SQL Authority with Pinal Dave

Less known/used property: ExecValueVariable

Episode 59: Moving Applications to the Cloud on Windows Azure : Deep Fried Bytes

Access a local SQL Compact database from Silverlight 4 - Blogs from the Experts

Dear DBA and Programmers Take Vacation!!!

Why SQL Server is better than any other RDBMS Applications?

SHRINKDATABASE For Every Database in the SQL Server

Copy a table using SQL Server Management Objects

SQL SERVER – Computed Column – PERSISTED and Performance

SQL Server - Count(*) or Count(1) ? - Which is better? - Dave Ballantyne's Blog

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example « Journey to SQL Authority with Pinal Dave

What are the Sql Server Management Objects - Mattia Baldinger

How to Partition Table (a Non-Partitioned Table) using T-SQL in SQL Server 2008

Open ID Login

Standard Login

Forgot Password?

Sign up