Dayananthan M. posted an article on
Dayaa's Blog
-
Apr 30, 2011, 9:58 am
-First-year students at Texas A & M’s Vet school were attending their first Anatomy class, with a dead pig.
They all gathered around the surgery table with the body covered with a White sheet. The professor started the class by telling them, ‘In Veterinary Medicine it is necessary to have two i... Comment - Like
Dayananthan M. posted an article on
Dayaa's Blog
-
Jan 3, 2011, 8:08 am
I wish you all a very happy new year 2011 and hope we will have a great year ahead… I have spent this new year in shirdi. We had a good dharsan after standing 4 hours in a long queue. As a whole it was a nice devonational trip.
NewYear2011 Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Sep 17, 2010, 10:59 am
The following query will fetch the index creation date.
SELECT name AS IndexName, STATS_DATE(OBJECT_ID,index_id) AS Creation_Date, OBJECT_NAME(OBJECT_ID) AS ‘TableName’
FROM sys.indexes WHERE name like ‘%index_name%’ Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Jul 3, 2008, 7:23 am
Suppose we have the situation to delete some duplicate records in our table. Suppose consider one table
create table #Test
(
EmpID int,
EmpName varchar(50)
)
–Insert the Records into #Test table
insert into #Test values(1,’Daya‘)
insert into #Test values(1,’Daya‘)
insert into #Test ... Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Jun 12, 2008, 4:59 am
The following query will fetch you the max value among three columns
Create Table #test (Name Char(10), Qty1 INT, QTY2 INT, QTY3 INT)
Insert into #Test (Name, QTY1, QTY2, QTY3) Values (‘Monitor’,12,13,11)
Insert into #Test (Name, QTY1, QTY2, QTY3) Values (‘KeyBoard’,8,7,6)
Insert i... Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
May 30, 2008, 2:58 am
I have created an Table Test with wrong column name as EepId instead of EmpID, and now i want to change it to EmpID, the following is the query to get
create table Test
(
EepID int
)
insert into Test values(2)
Now I want EepID column to Change to EmpID. The following is the solution
EX... Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Apr 24, 2008, 5:35 am
Few important things about isolation level
Read uncommitted
When its used, SQL Server not issue shared locks while reading data. So, you can read an uncommitted transaction that might get rolled back later. This isolation level is also called dirty read. This is the lowest isolation level. It ensu... Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Apr 24, 2008, 5:34 am
–Created one Example table
create table Events
(
PeopleName varchar(50),
EventType varchar(50),
Events varchar(100)
)
–Model Values
insert into Events values(‘Daya’,‘B’,‘Drinking’)
insert into Events values(‘Daya’,‘B’,‘Washing’)
–Created function t... Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Apr 24, 2008, 5:33 am
Select
dmStats.last_execution_time as ‘Last Executed Time’,
dmText.text as ‘Executed Query’
from
sys.dm_exec_query_stats as dmStats
Cross apply
sys.dm_exec_sql_text(dmStats.sql_handle) as dmText
Order By
dmStats.last_execution_time desc Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Mar 13, 2008, 8:44 am
The following query will fetch the tables that doesn’t have relationships.
Select ST.[Name] as “Orphan Tables”
from Sys.Foreign_Keys as SFK Right Join Sys.Tables as ST
On ST.object_id = SFK.parent_object_id Or
ST.object_id = SFK.referenced_object_id
Where SFK.type is null Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Jan 29, 2008, 7:18 am
Suppose we have to display all the data in the table into an XML format and at that time we have some null values in the table. Sometime few peoples will face an issue that they want “NULL” to displayed in XML for the null data. So we can we use query like this to get it.
Code:
SELECT
EmpI... Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Jan 20, 2008, 1:16 am
Few Interesting Questions and concepts
There are 3 tables Titles, Authors and Title-Authors (check PUBS db). Write the query to get the author name and the number of books written by that author, the result should start from the author who has written the maximum number of books and end with the ... Comment - Like
Dayananthan M. posted an article on
Dayananthan’s Weblog
-
Jan 8, 2008, 12:19 am
Hi,
Normally for exporting data from SQL Server to Excel one would use DTS (SQL 2k) or SSIS (SQL Server 2005).
For some reason if at all you want to do it via query read on:
Step 1: Execute the code snippet
–Step 1: Execute the code snippet
EXEC sp_configure ‘show advanced options&#... Comment - Like
Dayananthan M. posted an article on
Dayaa's Blog
-
Dec 31, 1969, 7:00 pm
We went to Shivasamudram last sundary. Its really a nice trip and this is the first time long drive in my bike. Shivasamudram is around 130 kms from Bangalore. The drive to Shivasamudram was super and you can enjoy lot. We started at early morning at 6:50 AM. There are two routes to reach Shivasamud... Comment - Like
Dayananthan M. posted an article on
Dayaa's Blog
-
Dec 31, 1969, 7:00 pm
Today we all went to see the opening of thiruvalluvar’s statue in Ulsoor, Bangalore..18 years era come to an end and it’s one of successful milestone for Karunanidhi political carrier..
Few snaps..
Hope this be will safe in future..
Dayaa Comment - Like
Dayananthan M. posted an article on
Dayaa's Blog
-
Dec 31, 1969, 7:00 pm
It was quite long ago i planned to go night trekking along with my friends..so finally yesterday we went to skandagiri hills and it was so thrilling because it was my first night trek… Me and my friends Senthil, Raman and Mahi are stared at 1 AM in two bikes.. It was so cold while drivin... Comment - Like
Dayananthan M. posted an article on
Dayaa's Blog
-
Dec 31, 1969, 7:00 pm
Hi Friends,
May this New Year bring many opportunities your way, to explore every joy of life and may your resolutions for the days ahead stay firm, turning all your dreams into reality and all your efforts into great achievements.
Happy New Year 2010
New Year 2010 Comment - Like
Dayananthan M. posted an article on
Dayaa's Blog
-
Dec 31, 1969, 7:00 pm
“Pongal is here, an occasion that marks joy and cheer, and brings along everything that’s best. May the festival of the harvest season, be one that brings along with it, all that’s best and everything you’re so deserving of. Have a memorable Pongal.” Comment - Like
Recent Discussions
