Excel formulas: increments months or years or days

Incrementing Months in Excel

Excel Formulas: Separating String Values between spaces

place these formulas side by side in two columns..

=LEFT($A1,FIND(" ",$A1)-1)

=RIGHT($A1,FIND(" ",$A1)-1)

Performing a Batch Delete

hi,
use a batch DELETE, e.g. something like

DECLARE @batchSize INT
SET @batchSize = 10000

WHILE (SELECT COUNT(*) FROM yourTable WHERE yourCondition) > 0
BEGIN
  DELETE  FROM yourTable
  WHERE   primaryKey IN ( SELECT TOP ( @batchSize )
                                  primaryKey
                        FROM      yourTable
                        WHERE     yourCondition ) ;
END ;

of course using EXISTS is faster:
WHILE EXISTS(SELECT * FROM yourTable WHERE yourCondition)

Kill SQL Server database connections

USE master
go

DECLARE @dbname sysname
SET @dbname = 'yourdbname'

DECLARE @spid int
SELECT @spid = min(spid)
 from master.dbo.sysprocesses
 where dbid = db_id(@dbname)

WHILE @spid IS NOT NULL
BEGIN
EXECUTE ('KILL ' + @spid)
SELECT @spid = min(spid)
FROM master.dbo.sysprocesses
WHERE dbid = db_id(@dbname)
 AND spid > @spid
END

Windows: Configuring Local Users: lusrmgr.msc

lusrmgr.msc

SQL Server backup results

SELECT a.name, b.type, DATEDIFF(MINUTE,b.backup_start_date , b.backup_finish_date),
b.backup_start_date ,
b.backup_finish_date
FROM master..sysdatabases a
LEFT OUTER JOIN msdb..backupset b ON a.name = b.database_name
WHERE DATEPART(DW,b.backup_start_date) IN (6, 7)
AND b.type NOT IN ( 'L', 'I')

system.cpl = workstation properties

system.cpl = workstation properties

Managing Session Timeouts in .NET

If you are using ASP.NET 2.0, use have to check in the IIS. Open the IIS, click on the Application Pools, Select the Application pool for your application. Right Click on that, Select Properties. In the Performance tab, Set the idle timeout as your desired minutes for "shutdown worker processes after being idle for ..... minutes". Apart from this you have to set the timeout in web.config as said by the other friends.

import/export BLOB

http://blog.rptea.com/post/Simple-scripts-to-insert-File-to-BLOB-field-and-export-BLOB-to-File-system.aspx

CREATE TABLE [dbo].[TmpBin](
     [MyId] [int] IDENTITY(1,1) NOT NULL
   , [MyDesc] [varchar](50) NULL
   , [MyBin] [varbinary](max) NULL ) 
ON [PRIMARY] 

INSERT INTO (MyDesc, MyBin) 
Select 'MyDesc01' 
   , BulkColumn from Openrowset( Bulk 'C:\temp\image1.jpg', Single_Blob) as tt 

Insert TmpBin(MyDesc, MyBin) 
Select 'MyDesc02' 
, BulkColumn from Openrowset( Bulk 'C:\temp\image2.jpg', Single_Blob) as tt

INSERT INTO TmpBin(MyDesc, MyBin) 
SELECT 'MyDesc03' 
     , BulkColumn 
FROM Openrowset( Bulk 'C:\temp\image3.jpg', Single_Blob) as tt

What language uses .do extension?

No, No, No! The .do extension is strictly for JavaServer Pages using the struts framework. The .do extension tells the Application Server to find a config file which calls the proper action class to process the form. Struts is the ultimate "separate content from display" implementation. Go to www.sun.com or to apache.org to find out more about JSP and Struts.