sqlserverfactory.blogspot.com
Sql Server Factory - a vipin cherukara factory: June 2009
http://sqlserverfactory.blogspot.com/2009_06_01_archive.html
View my complete profile. Features of Sql Server 2008. SQL Server 2005 Indexes: Sql Query to find How man. A few maximum limitations for SQL Server 2005. Friday, June 5, 2009. Features of Sql Server 2008. SQL Server 2005 provides a comprehensive solution for encryption and key management. SQL Server 2008 delivers an excellent solution to this growing need by supporting third-party key management and HSM products. Automatic Recovery of Data Pages. SQL Server 2008 enables the principal and mirror machines ...
sqlserverfactory.blogspot.com
Sql Server Factory - a vipin cherukara factory: September 2009
http://sqlserverfactory.blogspot.com/2009_09_01_archive.html
View my complete profile. SQL Server Computed Columns. Monday, September 7, 2009. SQL Server Computed Columns. Is a column that contains values that are calculated, rather than inserted. When the column is defined, a computed column specification. Is provided. This definition includes the expression that is used to determine the value of the column in each row of the table. It is not possible to specify the values for these columns in INSERT or SELECT statements. Computed columns can be used in most situ...
sqlserverfactory.blogspot.com
Sql Server Factory - a vipin cherukara factory: DeadLocked !
http://sqlserverfactory.blogspot.com/2009/06/deadlocked.html
View my complete profile. Features of Sql Server 2008. SQL Server 2005 Indexes: Sql Query to find How man. A few maximum limitations for SQL Server 2005. Thursday, June 4, 2009. Statements sometimes deadlock against UPDATE. The theoretical explanation is this: regardless of explicit transactions SQL. Server tries to stay Atomic, Consistent, Isolated and Durable. The default isolation level for all SELECT. Statements is READ COMMITTED. To achieve this SQL. Connection 1 : UPDATE. Connection 2 : SELECT.
sqlserverfactory.blogspot.com
Sql Server Factory - a vipin cherukara factory: Features of Sql Server 2008
http://sqlserverfactory.blogspot.com/2009/06/features-of-sql-server-2008.html
View my complete profile. Features of Sql Server 2008. SQL Server 2005 Indexes: Sql Query to find How man. A few maximum limitations for SQL Server 2005. Friday, June 5, 2009. Features of Sql Server 2008. SQL Server 2005 provides a comprehensive solution for encryption and key management. SQL Server 2008 delivers an excellent solution to this growing need by supporting third-party key management and HSM products. Automatic Recovery of Data Pages. SQL Server 2008 enables the principal and mirror machines ...
sqlserverfactory.blogspot.com
Sql Server Factory - a vipin cherukara factory: A few maximum limitations for SQL Server 2005
http://sqlserverfactory.blogspot.com/2009/06/few-maximum-limitations-for-sql-server.html
View my complete profile. Features of Sql Server 2008. SQL Server 2005 Indexes: Sql Query to find How man. A few maximum limitations for SQL Server 2005. Wednesday, June 3, 2009. A few maximum limitations for SQL Server 2005. Every now and then i see a question pop up that asks what is the max this or that in sql server? Well here are some maximum values:. Bytes per short string column. Bytes per GROUP BY, ORDER BY. Columns in GROUP BY, ORDER BY. Limited only by number of bytes. Bytes per index key.
developingfor.net
A Good, practical LINQ example | Developing For .NET
https://developingfor.net/c-30/a-good-practical-linq-example.html
Developing For .NET. A developer's journal. A Good, practical LINQ example. A Good, practical LINQ example. January 17, 2008. You may recall that one of my New Year’s Resolutions. Was to find and participate in a .NET Forum. Well, I have joined several, and have even posted a few times. While perusing the C# Corner forums today, I found this post. Bool hasErrors = false; foreach (Control c in this.Controls) { if (! Equals(errorProvider1.GetError(c) ) { hasErrors = true; break; } }. It soon dawned on me t...
sqlserverfactory.blogspot.com
Sql Server Factory - a vipin cherukara factory: SQL Server Computed Columns
http://sqlserverfactory.blogspot.com/2009/09/sql-server-computed-columns.html
View my complete profile. SQL Server Computed Columns. Monday, September 7, 2009. SQL Server Computed Columns. Is a column that contains values that are calculated, rather than inserted. When the column is defined, a computed column specification. Is provided. This definition includes the expression that is used to determine the value of the column in each row of the table. It is not possible to specify the values for these columns in INSERT or SELECT statements. Computed columns can be used in most situ...
sqlserverfactory.blogspot.com
Sql Server Factory - a vipin cherukara factory: SQL Server 2005 Indexes: Sql Query to find How many and how big?
http://sqlserverfactory.blogspot.com/2009/06/sql-server-2005-indexes-sql-query-to.html
View my complete profile. Features of Sql Server 2008. SQL Server 2005 Indexes: Sql Query to find How man. A few maximum limitations for SQL Server 2005. Wednesday, June 3, 2009. SQL Server 2005 Indexes: Sql Query to find How many and how big? This little snip of code allows you to list how many indexes are present on a table, their type and how big (kb and mb) they are:. Space used in kb. Space used in mb. Sysdm db index physical stats. Posted by Vipin Cherukara. Subscribe to: Post Comments (Atom).