Thursday, September 13, 2007

A win with king's gambit.

I don't think black made too many mistakes.
Still all it took was 22 moves for a mate.

Here' the game . Click here

And here's pgn...
1. e4 e5 2. f4 exf4 3. Nf3 d6 4. d4 Be7 5. Bxf4 Bg4 6. Bc4 h6 7. O-O Nf6 8. e5 dxe5 9. Bxe5 O-O 10. c3 Bd6 11. Qb3 Bc8 12. Bxf6 Qxf6 13. Ne5 Qe7 14. Nxf7 Qe3+ 15. Kh1 Kh7 16. Qc2+ g6 17. Nd2 Bf5 18. Rxf5 gxf5 19. Qxf5+ Kg7 20. Qg4+ Kf6 21. Ne4+ Ke7 22. Qe6#

Thursday, March 22, 2007

pick up random records from a table

Question:
How to pick up random records from a table?

Gabbar:

SELECT TOP 5
*
FROM
tblName
ORDER BY
right(convert(nvarchar(100),((row_number() over (order by ColumnName)) * rand())),3)

This will work in SQL 2005. To make it work in 2000, use any numeric column instead of row_number.

Tuesday, February 06, 2007

Truncate log and shrink all the database

Question:
How to truncate log and shrink the ALL the databases on a SQL Server 2005?

Gabbar:
Create the job with following script....
USE [msdb]
GO
/****** Object: Job [TruncateLogAndShrinkAllDatabases] Script Date: 02/06/2007 15:39:03 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object: JobCategory [Database Maintenance] Script Date: 02/06/2007 15:39:03 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'Database Maintenance' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'Database Maintenance'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'TruncateLogAndShrinkAllDatabases',
@enabled=1,
@notify_level_eventlog=0,
@notify_level_email=0,
@notify_level_netsend=0,
@notify_level_page=0,
@delete_level=0,
@description=N'No description available.',
@category_name=N'Database Maintenance',
@owner_login_name=N'sa', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/****** Object: Step [TruncateLogShrink] Script Date: 02/06/2007 15:39:03 ******/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'TruncateLogShrink',
@step_id=1,
@cmdexec_success_code=0,
@on_success_action=1,
@on_success_step_id=0,
@on_fail_action=2,
@on_fail_step_id=0,
@retry_attempts=0,
@retry_interval=0,
@os_run_priority=0, @subsystem=N'TSQL',
@command=N'DECLARE @var nvarchar(max)
SET @var = ''''

SELECT
@var = @var +
''
backup log '' + name + '' with truncate_only
DBCC SHRINKDATABASE('''''' + name + '''''')
''
FROM
sys.databases
WHERE
is_read_only = 0
AND database_id > 4

EXEC sp_executesql @var
',
@database_name=N'master',
@flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'MidNight',
@enabled=1,
@freq_type=4,
@freq_interval=1,
@freq_subday_type=1,
@freq_subday_interval=0,
@freq_relative_interval=0,
@freq_recurrence_factor=0,
@active_start_date=20070206,
@active_end_date=99991231,
@active_start_time=0,
@active_end_time=235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

Wednesday, November 15, 2006

याद रक्खूंगा.....

When Gabbar is arrested and being sent to the jail, he meets Thakur on the way and says...
याद रक्खूंगा.....तुझे याद रक्खूंगा.....

The tone of his voice and the hatred in his eyes....लाजवाब!!

Monday, October 30, 2006

अनुस्वार

अरे ओ सांभा.....

Thursday, October 19, 2006

मराठीत लिखाण

मी आता मराठी लिहीण्यात चान्गलाच पटाईत झालो आहे.
सुरुवातीला जरा हळू हळू लिहाव लागल, पण आता मात्र वेग आला आहे.
अजून अनुस्वार देता येत नाही.

Thursday, October 12, 2006

Excellent tool for stock market

found this...
Market Heat Map

A very good tool to look at performances of major stocks.
Don't forget to click on options and check the color changes on selection of time periods.