SQL Server Tips & Tricks

2012-05-28T23:23:00.001-07:00

Lambda Restriction Functions http://ping.fm/2rz1m

2012-05-02T23:41:00.001-07:00

How to do DYNAMIC Market Share Calculation http://ping.fm/0qPof

2012-05-02T21:06:00.001-07:00

When to use Abstract Factory and Factory Method Pattern http://ping.fm/gyFW7

2012-04-17T20:28:00.001-07:00

Parallel Programming not supported with Entity Framework http://ping.fm/TvK0J

2012-04-17T20:24:00.001-07:00

Cannot Implicitly Convert Type IQueryable http://ping.fm/duiMd

2012-04-16T17:21:00.001-07:00

Kill All Process in Sql Server Database http://ping.fm/jaiSb

2012-04-03T10:11:00.001-07:00

How to setup the server where the cube will be deployed http://ping.fm/ZmmJo

2012-02-27T21:57:00.001-08:00

nth Occurrence of a character in a string http://ping.fm/MwHm4

2012-02-22T19:39:00.001-08:00

Inheritance in JavaScript http://ping.fm/X7ShL

2012-02-21T21:10:00.005-08:00

Checking a Date whether it is weekend or monthend in VBA http://ping.fm/LW7w8

2012-02-21T21:10:00.003-08:00

Checking a Date whether it is weekend or monthend in VBA http://ping.fm/abq9P

2012-02-21T21:10:00.001-08:00

How to Get Child Records and all Descendant Records from a Parent-Child Relationship Table http://ping.fm/VVYvE

2012-02-21T21:09:00.003-08:00

How to Loop through all files in a folder using VBA http://ping.fm/7zV2s

2012-02-21T21:09:00.001-08:00

VBA Mathematic/Arithmetic Functions http://ping.fm/q7Kzp

2012-02-07T01:09:00.001-08:00

Finding Invisible Characters in TSQL String and Remove Invisible Characters with Space http://ping.fm/8K5Dz

2012-02-05T22:04:00.001-08:00

JSON to Object Conversion in C# http://ping.fm/zUpGB

2012-02-05T19:54:00.001-08:00

SQL Server Pivot: Converting Rows to Columns with Dynamic Query http://ping.fm/wdXkP

2012-02-02T01:27:00.001-08:00

Where to get VseWss 1.3 Service http://ping.fm/DNvGC

2012-02-01T18:58:00.001-08:00

Comma Separated string of all the rows of a column http://ping.fm/juRWm

2012-01-30T20:14:00.001-08:00

Date formatting in SQL Server http://ping.fm/YKf92

2012-01-30T20:00:00.001-08:00

Padding TSQL String Using a Character for a Particular Length http://ping.fm/tjqmB

2012-01-30T19:57:00.001-08:00

Removing the last character from a TSQL string http://ping.fm/LrmV3

2012-01-30T19:39:00.003-08:00

Finding All the Unicode Character Values Used in a String using TSQL http://ping.fm/alhSq

2012-01-30T19:39:00.001-08:00

SQL Server Array: Implementing TSQL Array Using XML and XQuery http://ping.fm/0mDtT

2012-01-30T19:38:00.001-08:00

Checking a Date whether it is weekend or monthend in VBA http://ping.fm/Rw4HZ