SELECT TOP 10 * FROM Table ORDER BY NEWID()

NEWID() generates a globally unique identifier (GUID) in memory for each row. so, when we sort by that GUID with the ORDER BY clause random row are being selected.

But when it comes to large tables where million of records are stored selecting random records for sampling affect performance very much.

Best alternative way is of using "BINARY_CHECKSUM" function.

SELECT TOP 10 * FROM Table WHERE (ABS(CAST((BINARY_CHECKSUM(*) *RAND()) as int)) % 100) < 10

The BINARY_CHECKSUM function generates a checksum value that is based on the values of the columns that you specify.

If two rows are different, they typically will generate different checksum numbers.

The BINARY_CHECKSUM function generally is used to verify whether any of the columns in a row in a table have changed.

There-by when we added the RAND function to the BINARY_CHECKSUM(*) function would generate a random number for each rows as column values for each row would vastly differ.

(ABS(CAST((BINARY_CHECKSUM(*) *RAND()) as int)) % 100) would generate a random number between 0 and 99 for each row in the table and then choose all of those rows whose random number is less than the value of the specified percent (in this case, it is 10)

Please find some useful keyword shortcuts available in Microsoft SQL Server Management Studio that would help to improve your productivity on the thing done frequently.

https://developers.facebook.com/blog/post/525/

Change required:

1) response.session should be changed to response.authResponse

Old:

FB.login(function(response) {
  if (response.session) {
    console.log("User is connected to the application.”);
    var accessToken = response.session.access_token;
  }
});

New:

FB.login(function(response) {
  if (response.authResponse) {
    console.log("User is connected to the application.”);
    var accessToken = response.authResponse.accessToken;
  }
});

2)auth.sessionChange is deprecated and being replaced with auth.authResponseChange

3)perms should be changed to scope

New:

FB.login(function(response) {
  if (response.authResponse) {
    console.log('Welcome!  Fetching your information.... ');
    FB.api('/me', function(response) {
      console.log('Good to see you, ' + response.name + '.');
      FB.logout(function(response) {
        console.log('Logged out.');
      });
    });
  } else {
    console.log('User cancelled login or did not fully authorize.');
  }
}, {scope: 'email'});

Though there are ways to make them case-sensitive using collation at various levels i.e at Server Level, Database Level, Column Level. This would make SQL Server case sensitive at that level permanantely.

In some case is required to matching value with case temporarily at particular T-SQL or in an If Condition. This case-sensitive check in SQL Server can be performed with following methods.

Method 1: Using COLLATE

Adding COLLATE Latin1_General_CS_AS makes the search case sensitive If condition matching can be done as

	IF('Case Sensitive Sql' COLLATE SQL_Latin1_General_CP1_CS_AS='CASE SENSITIVE SQL')
		PRINT 'Matched'
	ELSE
		PRINT 'Un-Matched'
	

Search can been done in T-SQL as

	SELECT mycolumn FROM mytable WHERE 
		 CAST(mycolumn AS VARBINARY(10)) = CAST('Case Sensitive Sql' AS VARBINARY(10)) 
	

Method 2: Using VARBINARY

Casting the given varchar value in equalent VARBINARY would determine the difference in value due to case.

	select CAST('Case Sensitive Sql' AS VARBINARY(100)) as Camelcase,CAST('CASE SENSITIVE SQL' AS VARBINARY(100)) as UpperCase
	

	IF(CAST('Case Sensitive Sql' AS VARBINARY(100))=CAST('CASE SENSITIVE SQL' AS VARBINARY(100)))
		PRINT 'Matched'
	ELSE
		PRINT 'Un-Matched'
	

Search can be done in T-SQL as

	SELECT mycolumn FROM mytable WHERE 
		 mycolumn COLLATE SQL_Latin1_General_CP1_CS_AS='Case Sensitive Sql'
	

The following T-SQL snippet gets the AM/PM from a DateTime format in Sql Server.

print Right(CONVERT(VARCHAR,getdate(),9),2)

CREATE FUNCTION dbo.ReplaceSpecialChars (@inpStr VARCHAR(512),@repChar CHAR(1))
RETURNS VARCHAR(512)
BEGIN
	DECLARE @retStr VARCHAR(512)
	SET @retStr = ''
	IF(LEN(@inpStr) > 0)
	BEGIN
		DECLARE @l INT
		SET @l = LEN(@inpStr)
		DECLARE @p INT
		SET @p = 1
		WHILE @p <= @l
		BEGIN
			DECLARE @c INT
			SET @c = ASCII(SUBSTRING(@inpStr, @p, 1))
			IF @c BETWEEN 48 AND 57 OR @c BETWEEN 65 AND 90 OR @c BETWEEN 97 AND 122
				SET @retStr = @retStr + CHAR(@c)
			ELSE
				SET @retStr = @retStr + @repChar
				SET @p = @p + 1
		END
	END
RETURN @retStr
END

To replace special characters with ‘-’ use the below query

Select dbo.ReplaceSpecialChars(’English,Tamil,Hindi Movies’,'-’)

Output : English-Tamil-Hindi-Movies

To remove special characters use following query

Select dbo.ReplaceSpecialChars(’English,Tamil,Hindi Movies’,”)

Output : EnglishTamilHindiMovies

Code Sample to replace continues replace chars:

If you have continues special character, you will get many replace characters. to remove multiple replace character use below code before the return statement.

while charindex(@repChar+@repChar, @retStr ) > 0 
begin 
select @retStr = Replace( @retStr , @repChar+@repChar,@repChar) end

Select dbo.ReplaceSpecialChars(’English , Tamil , Hindi Movies’,'-’)

Output : “English-Tamil-Hindi-Movies” instead of “English—Tamil—Hindi-Movies”

   var geocoder;
   var map;
   function initialize() {
        geocoder = new google.maps.Geocoder();
        var myLatlng = new google.maps.LatLng(sLat, sLng);
        var myOptions = {
            zoom: 5,
            center: myLatlng,
            mapTypeId: google.maps.MapTypeId.ROADMAP
        }
        map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
	
	GoToAddress();
   }
   function GoToAddress() {
        var address = "Adyar, Chennai, India"; // Address to Search
        geocoder.geocode({ 'address': address }, function (results, status) {
            if (status == google.maps.GeocoderStatus.OK) {
                map.setCenter(results[0].geometry.location);
                map.setZoom(15);
            } else {
                alert("Search was not successful for the following reason: " + status);
            }
        });
    }
    window.onload = function () {
        var script = document.createElement("script");
        script.type = "text/javascript";
        script.src = "http://maps.google.com/maps/api/js?sensor=false&key=__Your_Google_Map_API_registered_Key__&callback=initialize";
        document.body.appendChild(script);
    };

initialize() method would render google map with your registered google map api key.

GoToAddress() method uses geocoder.geocode in google map api for searching particular location on map. And on google.maps.GeocoderStatus.OK status, it zooms the map with desired zoom level.

If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed.

sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ]       [ , [ @provider= ] 'provider_name' ]      [ , [ @datasrc= ] 'data_source' ]       [ , [ @location= ] 'location' ]       [ , [ @provstr= ] 'provider_string' ]       [ , [ @catalog= ] 'catalog' ]   

Valid provider_name for various databases

SQL Server - SQLNCLI

Oracle - MSDAORA

Access/Jet - Microsoft.Jet.OLEDB.4.0

ODBC data source - MSDASQL

Sample query to create linked server in sql server 2005 for

Database name=dbname

Data Source=servername

User ID=dbuser

password=dbuserpwd

sp_addlinkedserver 'lnkservername','lnkprdname','SQLNCLI','servername,1433',NULL,NULL,NULL

sp_addlinkedsrvlogin 'lnkservername','false',NULL,'dbuser','dbuserpwd'

Query to drop an existing linked server

sp_dropserver 'lnkservername','droplogins'

ALTER TABLE {table-name} WITH NOCHECK 
ADD CONSTRAINT [{column-constraint-name}] DEFAULT (6) FOR {column-name}

select * from msdb..sysjobs

From the msdb..sysjobs, the required job_id for enable or disable to be taken.

T-SQL to dis-enable specific job in sql server

 EXEC msdb..sp_update_job @job_id = '770F175B-C8A0-4157-BACD-0AF129DF570C', @enabled = 0  

T-SQL to enable specific job in sql server

 EXEC msdb..sp_update_job @job_id = '770F175B-C8A0-4157-BACD-0AF129DF570C', @enabled = 1