Geeks With Blogs
Information -> Source for Next Generation October 2003 Entries
Overview of 64Bit SQL from Ram Kishore
Great article on Overview of 64bit SQL by Ram Kishore ( http://www.sqlservercentral... The Publisher says "This is a great article, seems like it covers almost every question you might have about installing and using the 64 bit version of SQL2K" Pretty work Ram Kishore :) ......

Posted On Friday, October 31, 2003 9:12 AM

Queries to check SP,table,trigger exists in database or not
Simple quries to check whether they are existing in database or not. 1. Checking whether procedure exist in the NORTHWIND database with name 'CustOrdersDetail' Approach -1: use NORTHWIND if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CustOrde... and OBJECTPROPERTY(id, N'IsProcedure') = 1) print 'CustOrdersDetail Exists in the NORTHWIND database' else print 'CustOrdersDetail *does not exist* in the NORTHWIND database' Approach -2: Use NORTHWIND if exists(select * from ......

Posted On Thursday, October 30, 2003 9:32 AM

You are very near to use supercomputer as your desktop systems
Optical DSPs promise tera-ops performance Startup Lenslet Labs has demonstrated an optically based digital signal processing engine (ODSPE) that has the potential to take DSPs from the current giga-operations-per-second (Gops) limit to tera operations per second (Tops) by 2005, the company announced at the inaugural Communications Design Conference in San Jose last week. Lenslet site: Here is my admired praise to (32) ......

Posted On Thursday, October 30, 2003 8:23 AM

Overview of C#

Find overview of Programming C#

Posted On Thursday, October 23, 2003 10:49 AM

SQL Server's Coolest Features
SQL Server 2000's Coolest Features Just when you think you have a handle on SQL Server 7.0, Microsoft ships a new SQL Server release. SQL Server 2000 might skip 1,993 release numbers, but you won't find the same degree of difference between SQL Server 2000 and 7.0 as you found between SQL Server 7.0 and 6.5. Even so, this latest release is full of new functionality. Here are seven of my favorite new SQL Server 2000 features. 7. Integrated XML Support XML support is key to Microsoft's push to Web-enable ......

Posted On Thursday, October 23, 2003 10:48 AM

Removing Duplicates
Simple way to Remove Duplicate Rows from an Existing Table in SQL

INTO duplicate_table
FROM original_table
GROUP BY key_value
HAVING COUNT(key_value) > 1

DELETE original_table
WHERE key_value
IN (SELECT key_value
FROM duplicate_table)

INSERT original_table
FROM duplicate_table

DROP TABLE duplicate_table

Posted On Thursday, October 23, 2003 10:47 AM

Copyright © Raju | Powered by: