RAID server configuration and disk amounts(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 27 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

SQL SERVER 2011 “DENALI” New Function – EOMONTH(cecildt.blogspot.com)

submitted by cecildt(203) 8 months, 28 days ago

As we all are waiting in excitement for the final release of SQL Server “Denali” I’m going to look at the new TSQL functions it brings for developers. The first function is EOMONTH. EOMONTH stand for “End Of MONTH”. read more...

add a comment |category: Database |Views: 1

tags: Database another

Microsoft Research: Trinity Graph Database(cecildt.blogspot.com)

submitted by cecildt(203) 8 months, 29 days ago

I found myself wondering around the Microsoft Research website the other day and found the Trinity project. Trinity is a graph database and computation platform over distributed memory cloud. read more...

add a comment |category: Database |Views: 6

tags: Database another

Database Tuning overview – Buffer Tuning(beyondrelational.com)

submitted by jacobsebastian(3639) 9 months, 1 day 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

ADO.NET-Entity-Framework-What-How-Why(tutorialsaspnet.com)

submitted by mehta2626(108) 9 months, 1 day ago

Channel 9 video about ADONET-Entity-Framework-What-How-Why read more...

add a comment |category: ADO.NET |Views: 5

tags: ADO.NET Database another

Rename Store Procedure using T-SQL(www.aspxtutorial.com)

submitted by composeme(919) 9 months, 3 days ago

This example demonstrates how to rename the store procedure using Transact-SQL... read more...

add a comment |category: Database |Views: 5

tags: Database another

#QuickTip 8 - [SQL Server] How delete all data of all tables(www.ninjacode.com.br)

submitted by thiagosatoshi(248) 9 months, 3 days ago

How delete all data of all tables, sql server database. read more...

add a comment |category: Database |Views: 7

tags: Database another

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

submitted by jacobsebastian(3639) 9 months, 3 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

SQL Server Storage Internals Part 3 - Architecture of Heaps(beyondrelational.com)

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

In this article I have explained below topics, Key points on HEAP tables. What happens when a table is created? How to list IAM, data pages allocated to a heap table. As all data, index and system pages stores data in hexadecimal format, knowledge of... read more...

add a comment |category: Database |Views: 1

tags: Database another

How to drop multiple tables in a single drop command(www.dotnetlogix.com)

submitted by dotnetlogix(524) 9 months, 8 days ago

How to drop multiple tables in a single drop command read more...

add a comment |category: Database |Views: 3

tags: Database another

Using IN clause to search in multiple columns of a table in SQL Server(www.dotnetlogix.com)

submitted by dotnetlogix(524) 9 months, 8 days ago

Its possible to search a text in multiple columns of a table in SQL Server using a single IN instead of using multiple OR command. read more...

add a comment |category: Database |Views: 2

tags: Database another

SQL Server Storage Internals Part 1 - Basics(beyondrelational.com)

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

While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels of Index pages. This learning helped me to understand concepts better and to give better performance tuning solutions later. This is my... read more...

2 comments |category: Database |Views: 21

tags: Database another

#QuickTip 7 - [SQL Server] Disable all triggers(www.ninjacode.com.br)

submitted by thiagosatoshi(248) 9 months, 9 days ago

How disable and enable all triggers. read more...

add a comment |category: Database |Views: 0

tags: Database another

SQL Server Bit Data Type and how it Stores Values(www.sqlservercurry.com)

submitted by SuprotimAgarwal(715) 9 months, 9 days ago

SQL Server supports the bit datatype which can be used to store flag values like 'true' or 'false'. However it should be noted how the values are stored in the bit column. This article gives you an overview of the same. read more...

1 comment |category: Database |Views: 28

tags: Database another

DateTimeOffsetFromParts Function in Denali, CTP 3(beyondrelational.com)

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

This function returns a datetimeoffset value. Syntax: DateTimeOffsetFromParts (year, month, day, hour, minute, seconds, fractions, houroffset, minuteoffset, precision) Example 1: Simple example Select DateTimeOffsetFromParts (2011,7,24,0,15,44,120,0,0... read more...

add a comment |category: Database |Views: 6

tags: Database another

How to create primary key on a table or an existing table -DotNetLogix(www.dotnetlogix.com)

submitted by dotnetlogix(524) 9 months, 10 days ago

How to create primary key on a table or an existing table read more...

add a comment |category: Database |Views: 2

tags: Database another