-
In Oracle, it is possible to split the record based on the columns and to insert them into multiple tables at the same time. Consider the below case where we have the tblEmployee as our base table SQL> Select * From tblEmployee; EMPID EMPNAME SALARY BELONGSTO DEPTID ---------- -------------------...
-
Well here it is the next version of SQL Server is getting out step by step, few months ago CTP3 and now Release Candidation 0 is available for download. The version number will be 11.0.1750.32, make a note of it. Microsoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help...
-
There are number of occasions where we need to get to know the SQL Server service start date time and also from what time the SQL Services are up and running generally termed as Uptime. There are many ways to do it like check for temp DB Creation time, using DMF sys.dm_io_virtual_file_stats etc. Below...
-
While finalising some slides for my presentation at the Canberra .Net User Group on Using XML and TVP’s to Transport Relational Data , I stumbled across a couple of posts by Bob Beauchemin relating to how TVP’s cause plan recompiles when called from ADO.NET . Given that I published a post back in May...
-
VB, VB.net and C# (4.0) developers knows what a named and optional parameter is. For those who are not familiar with the concept,it is like calling a function parameter by it's name instead of passing all of them. Consider a small example( it is only a pseudo code) function Add(int a = 0, int b ...
-
A computed column in SQL Server is an expression which is based on another column in the same table. Consider the following example create table test_table ( id int, names varchar(100), cust_id as right('00000'+cast(id as varchar(10)),5) ) GO insert into test_table (id, names) select 1,'test1'...
-
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of from attribute columns in dimension tables. This is because useful dimensional data is sometimes stored in a fact table to reduce duplication, especially when...
-
The current DBA trend is increased database management requirements and less DBAs to manage. Many factors are responsible, such as: 1)Global trends and predictions for increased data requirements 2)Automation 3)Economic pressure to decrease size of IT departments You can see why for many DBAs intense...
-
CONTINUE statement Introduce in Oracle 11g,this statement provides an easy way to force an immediate jump to the loop control statement Let us see this into action by writing a simple Even..Odd number program SQL> BEGIN 2 FOR i IN 1 .. 10 LOOP 3 IF MOD(i,2) = 0 THEN 4 CONTINUE; 5 DBMS_OUTPUT.PUT_LINE...
-
Quotename() is a SQL Server String function. It accepts an input string of of up to 128 characters. Which is a limitation, although you could easily create a workaround with a UDF Returns a Unicode string of a valid delimited identifier. Why would you use Quotename()? 1) Reviewing for SQL Injection Attacks...
-
PREEMPTIVE_XXX wait types are basically associated with the worker thread outside SQL engine. These wait types have been newly introduced in SQL server 2008. (SQL server will not have any control over the work.) Thank you to SQL server team introducing these wait types in SQL server 2008 to nail down...
-
EXIT statement EXIT statement is similar to the BREAK statement found in other programing languages like C, C++, Java, C# , JavaScript, SQL SERVER etc. It breaks the loop statement once the specified condition becomes true and then control comes to the statement immediately following the loop Syntax...
-
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated with a single dimension member. For example, consider the example of financial transactions in accounts that can have one or more customers. This can be modeled as: The relationship between...
-
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use DBCC CHECKDB and the steps to take if a corrupt page is discovered? This is a typical question I’ll ask at an interview for a DBA. In most cases the answers are vague. My approach on DBCC CHECKDB...
-
After getting very good response to the jQuery series some of the readers requested to write about WPF . BeyondRelational is always happy to serve for what readers are ask for. In continuation to jQuery series, I would also like to host WPF series. So Read On? 1. What is WPF ? Why it is used...