Статистика поиска

http://wordstat.yandex.ru/
http://www.google.com/insights/search/

Пример курсора

declare @Login nvarchar(255)
declare @Password nvarchar(255)
declare @i int

DECLARE curs CURSOR FOR
SELECT [Login], [Password]
FROM [UsersToCreate]

OPEN curs

FETCH NEXT FROM curs INTO @Login, @Password

set @i=1

WHILE @@FETCH_STATUS = 0
BEGIN
 BEGIN TRY
  exec('CREATE LOGIN ['+@Login+'] WITH PASSWORD = '''+@Password+'''')
  exec('CREATE USER ['+@Login+'] FOR LOGIN ['+@Login+'] WITH DEFAULT_SCHEMA = my_sc')
  exec('EXEC sp_addrolemember ''my_role'', ['+@Login+']')
 END TRY
 BEGIN CATCH
  print cast(@i as char(3))+ ') login: ' + @Login + ' - error:' + ERROR_MESSAGE()
  set @i= @i+1
 END CATCH;
 FETCH NEXT FROM curs INTO @Login, @Password
END

CLOSE curs
DEALLOCATE curs 

C#, Get Current Path

public static class PathHelper
{
 public static string GetCurrentPath()
 {
  string codeBase = System.Reflection.Assembly.GetExecutingAssembly().CodeBase;
  UriBuilder uri = new UriBuilder(codeBase);
  return System.IO.Path.GetDirectoryName(Uri.UnescapeDataString(uri.Path));
 }

 public static string CombineWithCurrent(string path)
 {
  return System.IO.Path.Combine(GetCurrentPath(), path);
 }
}

Ext-method: Capitalize

public static string Capitalize(this string value)
{
  if(string.IsNullOrEmpty(value)) return value;
  if(value.Length == 1) return value.ToUpper();
  return value.Substring(0, 1).ToUpper() + value.Substring(1).ToLower();
}

CSS хаки

div {
background: red; /* для нормальных браузеров */
//background: green; /* для всех ie */
-background: blue; /* “_”, или дефис “-“ для ie6 и ниже */
*background: blue; /* для ie7 и ниже */
}

favi-icon

<link href="[url]" rel="shortcut icon" />

Оптимизация клиентской части

Непогана стяття
Оптимизация клиентской части