Currently browsing tag

architecture

ircmaxell Framework Fixation An Anti Pattern

ircmaxell: Framework Fixation – An Anti Pattern ircmaxell: Framework Fixation – An Anti Pattern, short summary: delegation of architecture decisions to frameworks may not be optimal or even wrong only use frameworks when doing prototypes or projects you don’t need to maintain frameworks don’t save time/money in the long term …

Using V8 Javascript engine as a PHP extension update write PHP session

Using V8 Javascript engine as a PHP extension (update: write PHP session) pre { background-color:#444; white-space:pre-wrap; font-size:85%; padding:0px 6px; } “We Are Borg PHP. We Will Assimilate You. Resistance Is Futile!” Just got to something described as: This extension embeds the V8 Javascript Engine into PHP. It is called v8js …

Disadvantages of ORM

Disadvantages of ORM ORM has attracted a lot of attention in the last years. So let’s get a bit deeper into it.The biggest advantage of ORM is also the biggest disadvantage: queries are generated automatically queries can’t be optimized queries select more data than needed, things get slower, more latency(some …

SSIS package

SSIS package In my previous article I am trying to explain related to What is data warehousing. If you don’t read it please follow this link before going to this… http://sqlknowledgebank.blogspot.in/2012/05/data-warehousing.html In this article I am trying to explain related to SSIS package. A Package is the core object within …

Finding OBJECTS in DB

Finding OBJECTS in DB Sometime we have confusion that the object presents in the database or not. To find the objects present we have to query the sys.sysobjects. I am trying to make it easy by a stored procedure.  The limitation of the stored procedure is it helps to find …

Partition Table

Partition Table The Table partitioning can make very large tables and index easier to manage and improve the performance of the query. This article is related to table partitioning concept and how you crate the partition table. Hope all of my readers will like it. History Table partitioning was introduced …

GETDATE Vs SYSDATETIME

GETDATE() Vs SYSDATETIME() To get the current system date and time we can use GETDATE() or  SYSDATETIME() function in SQL server.  The question is what the difference between them is. To get the answer let execute the SQL statements mentioned bellow. SELECT GETDATE() ‘GETDATE’,   SYSDATETIME() ‘SYSDATETIME’ The output is mentioned …

TIME data type

TIME data type SQL Server 2008 introduced a new data type called TIME, which allow the TIME without DATE. Before SQL Server 2008 it is not possible. In this article I am going to explain the TIME data type by creating scenario to understand it better way. Scenario-1 [ The …

SQL 2008 FILESTREAM storage

SQL 2008 FILESTREAM storage SQL Server never is good to storing unstructured data like video, graphics file, MS-Office file etc.  Before SQL server 2008, we have two choices to manage such kind of data mentioned bellow.  1.    By using VARBINARY(MAX) columns inside the database.   2.    Store the data outside …

Database SCHEMA

Database SCHEMA From SQL Server 2005 the DATABASE SCHEMA is introduced by Microsoft. Before understanding the database schema we must review the SQL Server 2000 to understand it properly. Problem with earlier version of SQL Server (Before SQL Server 2005) In SQL Server 2000 the schema is owned by, and …

CROSS APPLY on SQL 2005

CROSS APPLY on SQL 2005 A new feature of Microsoft SQL Server 2005 is “CROSS  APPLY”. It restricted “INNER JOIN” between a table (outer query) and a table-valued function (common usage), or derived table from correlated subquery. The table-valued function is evaluated only for the parameter values supplied by the …

IDENTITY Columns Violation

IDENTITY Columns Violation We all know about the identity columns of SQL Server and how important it is. This article is related to it but I am representing this article to solving a common proble. First take a quick look about the identity columns and how it works. Then we …