Percentile_Cont Function in Denali CTP3(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 13 days ago

Percentile_Cont Function Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an interpolated value that would fall into that percentile value with respect to the sort specification.It accepts any... read more...

add a comment |category: Database |Views: 2

tags: Database another

SQL Server Denali – FORMAT() string function(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 14 days ago

SQL Server Denali brings us new string function, FORMAT function. It will make formatting of date/time and number values easier. Syntax: FORMAT (value, format [,culture]) Formatting Date/Time Let’s see how it works: DECLARE @a datetime = getdate... read more...

add a comment |category: Database |Views: 9

tags: Database another

Performance Best practice - Transaction log must on a different drive.(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 15 days ago

It is a well-known recommendation and best practice that the transaction log of any database must be on a drive different than the data files are on. This is especially useful to improve transaction log file performance, which manifests itself as a high... read more...

3 comments |category: Database |Views: 31

tags: Database another

Chart Helpers in ASP.NET MVC3(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 18 days ago

I am exploring ASP.NET MVC3 and everyday I am learning something new. In today’s post I am going to explain how we can create chart with ASP.NET MVC3. Chart is one of greatest way of expressing figures. We all need that functionality in any commercial... read more...

add a comment |category: ASP.NET |Views: 19

tags: ASP.NET another

T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 18 days ago

A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I will show you guys a couple of new windowing functions, that goes along with the OVER clause. read more...

add a comment |category: Database |Views: 8

tags: Database another

What is the architecture of WPF?(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 19 days ago

WPF has Presentation Framework, Presentation Core & Composition Engine (MIL). Each one sit on the top of the other in the following order 1. Composition Engine 2. Presentation Core & 3. Presentation Framework WPF uses 3D pipeline to render everything... read more...

1 comment |category: ASP.NET |Views: 34

tags: ASP.NET another

New expression language functions(Left,Token,TokenCount) in SSIS Denal(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 22 days ago

New expression language functions(Left,Token,TokenCount) in SSIS Denali CTP 3 In Denali CTP 3, we have three new functions in the expression language viz. Left , Token and TokenCount so far SSIS is concern Let us analyze these functions one by one Left... read more...

add a comment |category: Database |Views: 5

tags: Database another

TSQL Challenge 63 - A TSQL Sudoku(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 25 days ago

This challenge is a puzzle of numbers. Everyone of you might have came across this puzzle named 'Sudoku'. read more...

add a comment |category: Database |Views: 5

tags: Database another

File Upload using jQuery(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 25 days ago

Use case: To upload the file from client system and save the file in Server using File Stream Implementation: This can be done at the client side by using jQuery with the help of uploadify.js plugin 1. Designing the Page... read more...

add a comment |category: ASP.NET |Views: 57

tags: ASP.NET another

SQL Server – "Denali" – PERCENT_RANK() Analytic Function(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 26 days ago

PERCENT_RANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENT_RANK() ranks rows between 0 and 1, both inclusive. Computation formula used by PERCENT_RANK(): (RANK() – 1) / (Number of Rows – 1)... read more...

add a comment |category: Database |Views: 3

tags: Database another

Attach database without log file and rename database(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 27 days ago

Assuming the database was detached successfully, this t-sql code will attach a mdf file without a log file. It will also reattach the database with a new database name. USE [master] GO CREATE DATABASE [myTestDatabase] ON ( FILENAME = N'E:\Program... read more...

add a comment |category: Database |Views: 8

tags: Database another

RAID server configuration and disk amounts(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 28 days ago

Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge. Typical questions from the SAN\Storage guy to the DBA are: “How many disks in a RAID configuration?” “What is the optimal block... read more...

add a comment |category: Database |Views: 3

tags: Database another

Creating Basic RSS Reader in ASP.NET MVC 3(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 28 days ago

In this post I am going to explain you how we can create a basic RSS Reader with the help of Linq-To-Xml and ASP.NET MVC3 Razor. Those who are writing or reading Blogs already knows what is RSS Reader. But those who does not know What is RSS. Below... read more...

add a comment |category: ASP.NET |Views: 9

tags: ASP.NET another

Database Tuning overview – Buffer Tuning(beyondrelational.com)

submitted by jacobsebastian(3639) 9 months, 2 days ago

As part of the Performance Tuning series – Performance Stack , this section looks at Buffer Managment tuning. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large proportion... read more...

add a comment |category: Database |Views: 1

tags: Database another

Playing with dropdownlist using jQuery - SelectedValue, SelectedText, (beyondrelational.com)

submitted by jacobsebastian(3639) 9 months, 2 days ago

You might be working with ASP.NET Dropdown list or normal html dropdownlist while working with web development. In common scenarios and day to day applications we need to get value filed ( usually ID ) and text filed of the selected item in the drop down... read more...

add a comment |category: ASP.NET |Views: 6

tags: ASP.NET another

Intellisense in SQL 11 (“Denali”) uses “LIKE” search – A productivity (beyondrelational.com)

submitted by jacobsebastian(3639) 9 months, 4 days ago

SQL 11 (“Denali”) has been around us for quite some time now and is almost ready for making a dash towards the “Release Candidate” (RC) state with Community Technology Preview (CTP) 03 being released last month. read more...

1 comment |category: Database |Views: 9

tags: Database another