Monthly Archives: September 2013

Processing 6 billion records in 4 seconds on a home PC with crappy pentium processor.

Processing 6 billion records in 4 seconds on a home PC. Lately I see a lot of hype around Hadoop. However if you look close at the performance of Hadoop clusters it is not all that stellar. Actually it is more … Continue reading

Posted in SQL Server | Tagged | Comments Off on Processing 6 billion records in 4 seconds on a home PC with crappy pentium processor.

See your ASP.NET app's server interaction thanks to Glimpse

Glimpse lets you see what’s happening on the server for your ASP.NET application, all within the browser and with no changes to the application. What is going on? We’ve all been in this situation: The code looks right and the … Continue reading

Posted in SQL Server | Tagged | Comments Off on See your ASP.NET app's server interaction thanks to Glimpse

Importing SharePoint data from Access Data Projects looks much faster than using SSIS.

Just had to share.. I’m currently importing a list of about 4000 items from SharePoint into SQL Server. I’m experimeting with moving OFF of  ADP to do this.. but the performance side just kills me. I just swear that using … Continue reading

Posted in SQL Server | Tagged | Comments Off on Importing SharePoint data from Access Data Projects looks much faster than using SSIS.

Big integer checksum

I’m really thinking about writing a function exactly like checksum, but it returns a big integer . I frequently use checksum to prototype a surrogate key. Having a larger integer result from the checksum function would make this a lot … Continue reading

Posted in SQL Server | Tagged | Comments Off on Big integer checksum

nonclustered Covering index will usually provide the optimum performance of a query

Designers of database systems will often assume that the use of a clustered index is always the best approach. However the nonclustered Covering index will usually provide the optimum performance of a query. https://www.simple-talk.com/sql/learn-sql-server/using-covering-indexes-to-improve-query-performance/

Posted in SQL Server | Tagged | Comments Off on nonclustered Covering index will usually provide the optimum performance of a query

Querying agent job status, executing and waiting for job completion from within T-SQL

In this article I would like to describe how easily you can query an Agent Job status from within T-SQL command and also how it is possible to execute an agent job and wait for it’s completion. It can happen, … Continue reading

Posted in SQL Server | Tagged | Comments Off on Querying agent job status, executing and waiting for job completion from within T-SQL

my favorite Windows API calls in VB

When a VBA solution falls short of your needs, there’s probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work. Office developers rely heavily on … Continue reading

Posted in Access, SQL Server | Tagged | Comments Off on my favorite Windows API calls in VB

great list of windows shortcut keys

great article I found regarding Windows Shortcut keys. This articles claims that this is specific to HP computers, I think that most of these are applicable to most Windows PCs. HP PCs – Using Keyboard Shortcuts and Special Keys This … Continue reading

Posted in Windows | Tagged , , | Comments Off on great list of windows shortcut keys

Stubborn math problems

Tough Programming lesson for the day.. When your math doesn’t add up.. Numbers dont match.. its really easy to see a discrepancy of ten. But not every math problem can be solved by ten. Sometimes it helps to try other … Continue reading

Posted in SQL Server | Tagged | Comments Off on Stubborn math problems