Sql Server Blogs & Blog Posts
Posting Frequency on sql server
|
Distinct: |
Percent: |
Latest Blog Posts on sql server
- Improve Performance of your LINQ to SQL Queries - Query Compilation by Mike Gleason jr's Blog on Oct 29, 2009
LINQ to SQL is a great Object-relational mapping (ORM) software that encapsulates and simplifies a lot anything related to your database. But as with every good things in life, it comes with a price. No I'm not talking about Montreal's hockey team h...
- Timezone Offsets With Sql Server - Revisited by Mike Gleason jr's Blog on Oct 20, 2009
This week-end I played a little bit with timezones and two new SQL Server 2008 functions: TODATETIMEOFFSET() SWITCHOFFSET() It reminded me how I was handling timezones on my websites and I decided to write about it. Introduction Timezone is alwa...
- Database Optimization Techniques to Increase SQL SERVER Performance - Part III - Index on multiple columns by Macronimous Web Design Blog on May 22, 2009
Index on multiple columns for SQL performance Since clustered index reorders the table and arranges the data according to the index key, SQL Server allows only one clustered index per table. This results in amazing performance, when you only have to...
- Database Optimization Techniques to Increase SQL SERVER Performance – Part III – Index on multiple columns by Macronimous Web Design Blog on May 22, 2009
Index on multiple columns for SQL performance Since clustered index reorders the table and arranges the data according to the index key, SQL Server allows only one clustered index per table. This results in amazing performance, when you only have to...
- The Weird Syntax of SQL DELETE From a JOIN by McBean Information Technology on May 22, 2009
It is perfectly legal in most SQL dialects to DELETE records that come from a JOIN clause. However, I never remember the syntax because its kind of strange and I don't do it often.I wrote the following example in SQL Server 2005:delete from arledger...
- Database Optimization Techniques to Increase SQL SERVER Performance – Part I – Increase SQL Server stored procedure performance by Macronimous Web Design Blog on May 19, 2009
1) Increase SQL Server stored procedure performance with following three tips: Â Â Â Â Â Â Â Stored procedures plays a vital role in enhancing the performance of the database. The following three tips will help us to maximize database...
- Database Optimization Techniques to Increase SQL SERVER Performance - Part I - Increase SQL Server stored procedure performance by Macronimous Web Design Blog on May 19, 2009
1) Increase SQL Server stored procedure performance with following three tips: Stored procedures plays a vital role in enhancing the performance of the database. The following three tips will help us to maximize database performance, w...
