Accumulative counts based on Date
declare @tmpTbl table(d int primary key, c int, cr int) insert into @tmpTbl select MONTH(<datecol>), ,count(userid),0 FROM <table_name> WHERE group […]
SQL – SSIS Get FileName from Multi-Flat-File Import
SUBSTRING(FileName,LEN(FileName) – FINDSTRING(REVERSE(FileName),”\\”,1) + 2,LEN(RIGHT(FileName,FINDSTRING(REVERSE(FileName),”\\”,1) – 1))) Recommend on Facebook share via Reddit Share with Stumblers Tweet about it
Truncate Logs
alter database <mydb> set recovery simple go checkpoint go alter database <mydb> set recovery full go backup database pubs to […]
SQL – Find Space Used, Row Count of all tables in a database
SET NOCOUNT ON DBCC UPDATEUSAGE(0) — DB size. EXEC sp_spaceused — Table row counts and sizes. CREATE TABLE #t ( […]
Visual Studio – Delete blank lines
Visual Studio has ability to delete empty lines in replace operation using regular expressions. 1.Click Ctrl-H (quick replace) 2. Tick “Use Regular […]
Unix – Zip a Folder
In the shell use the following command: zip -r filename directory Recommend on Facebook share via Reddit Share with Stumblers […]
IE6 and IE7 on Windows 7 (or any platform)
Here’s the scenario: You are running Windows 7, but need to test a website or a web application for Cross […]
VMWare Fusion: Lost Connection to Internet
On a Mac, using VMWare Fusion is close to a must in the business world, due to all the VPN […]
Formula to Explode a Cell
So, you have a big list of contacts but one column has both, first and last name, but you need […]
Use Unix commands in Windows
In order to use Unix Commands in Windows, you will need to download CoreUtils from GnuWin32 (Sourceforge: http://sourceforge.net/projects/gnuwin32/ | Direct […]
