pradeep1288

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.*;


/**
 * Created with IntelliJ IDEA.
 * User: pradeepnayak

pradeep1288

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.*;


/**
 * Created with IntelliJ IDEA.
 * User: pradeepnayak

pradeep1288

SELECT      @@SERVERNAME AS SqlServerInstance,
            db.name AS DatabaseName,
            SUM(CASE WHEN af.groupid = 0 THEN 0 ELSE 8192.0E * af.size / 1048576.0E END) AS DatabaseSize,
            SUM(CASE WHEN af.groupid = 0 THEN 8192.0E * af.size / 1048576.0E ELSE 0 END) AS LogSize,
            SUM(8192.0E * af.size / 1048576.0E) AS TotalSize
FROM        master..sysdatabases AS db
INNER JOIN master..sysaltfiles AS af ON af.[dbid] = db.[dbid]
WHERE       db.name NOT IN('distribution', 'Resource', 'master', 'tempdb', 'model', 'msdb')   

GROUP BY    db.name

pradeep1288

Hi,

You can use the below scrip to send thank you notes to your friends who wished for your birthday on your Facebook timeline.

Instructions:

#Get the Facebook access token:

Head to https://developers.facebook.com/tools/explorer

pradeep1288

<form action="http://maps.google.com/maps" method="get" target="_blank">
   <label for="saddr">Where are you now ?</label>
   <input type="text" name="saddr" />
   <input type="hidden" name="daddr" value="<Your desired destination address>" />
   <input type="submit" value="Find me the way" />
</form>