kdarty

--Description: Delete Duplicate Records in SQL Server Keeping only One
--Author: Ben Thul
--Source: http://stackoverflow.com/questions/6025367/t-sql-deleting-all-duplicate-rows-but-keeping-one
--NOTE: A common use-case is that "foo, bar" are the group identifier and "baz" is some sort of time stamp. In order to keep the latest, you'd do ORDER BY baz desc)

WITH cte AS (
  SELECT[foo], [bar], 
     row_number() OVER(PARTITION BY foo, bar ORDER BY baz) AS [rn]
  FROM TABLE
)

kdarty

/**
 * Vanilla CSS 1.0.2
 * http://cssreset.com
 */
body {
	font: 9pt/1.5em sans-serif;
}
pre, code, tt {
	font: 1em/1.5em 'Andale Mono', 'Lucida Console', monospace;
}

kdarty

"use strict";
var ACME = {};
ACME.Web = {};
ACME.Web.UI = {};

ACME.Web.UI.Customer = function () {
    var FirstName, LastName, FullName;

    FullName = function () {
        return this.FirstName + " " + this.LastName;

kdarty

<?xml version="1.0"?>

<configuration>

  <!-- Disable Inheritance -->
  <location path="." inheritInChildApplications="false"> 

    <system.web>

      <compilation debug="false" />

kdarty

var Person = new function () {
	var _firstName = null;
	var _lastName = null;

	// Public Properties
	this.FirstName = {
		get: function () {
			return _firstName;
		},
		set: function (value) {

kdarty

/// <summary>
/// Extension Metion to verify that a Generic List is not NULL or Empty
/// </summary>
/// <typeparam name="T">List Type</typeparam>
/// <param name="source"><see cref="List"/> Source</param>
/// <returns><see cref="bool"/> (true/false)</returns>
public static bool IsNullOrEmpty<T>(this List<T> source)
{
    if (source != null && source.Any())
    {

kdarty

--Source Discussion: https://community.spiceworks.com/topic/131997-sql-copy-field-in-to-smaller-field
--Author: Jason Crider - https://twitter.com/jasoncrider

--Get MaxLength on all columns in a table
DECLARE @SQL VARCHAR(MAX)

DECLARE @TableName sysname

SET @TableName = 'INSERT_TABLENAME_HERE'

kdarty

-- StackOverflow Discussion: 
-- http://stackoverflow.com/questions/2675168/get-the-unique-constraint-columns-list-in-tsql
SELECT TC.CONSTRAINT_NAME, 
       CC.COLUMN_NAME, 
       TC.TABLE_NAME 
FROM   INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC 
       INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CC 
               ON TC.CONSTRAINT_NAME = CC.CONSTRAINT_NAME 
WHERE  TC.CONSTRAINT_TYPE = 'Unique' 
ORDER  BY TC.Constraint_Name;

kdarty

/****************************************************************************************************************************/
/* Source Article:                                                                                                          */
/* http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/ */
/****************************************************************************************************************************/

-- Turn on advanced options
EXEC  sp_configure'Show Advanced Options',1;
GO
RECONFIGURE;
GO

kdarty

// Convert DateTime to "JSON Date" Format
// Adapted From: http://overpie.com/javascript/articles/convert-datetime-to-JSON-datetime-format
function convertToJSONDate(strDate) {
    var dt = new Date(strDate);
    var newDate = new Date(Date.UTC(dt.getFullYear(), dt.getMonth(), dt.getDate(), dt.getHours(), dt.getMinutes(), dt.getSeconds(), dt.getMilliseconds()));
    return newDate.getTime().toString();
}