SQL - Difference between CAST,CONVERT and PARSE

TODO--- 

Read JSON Array with Swing iOS

--TODO--

Lost all SQL Admin logins -- this command comes to my rescue.

PsExec -s -i "C:\Program Files (x86)\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

This will use Network Service to Login and you can add new login one you logged in through,

​Note: SSMS.exe path may differ, please check on your drive for SQL Installed Binn.​

Deleting performance Category via Power shell.

​Its worked perfectly fine for me.

​[Diagnostics.PerformanceCounterCategory]::Delete( "Perf Category Name" )

Whether Winhttpcertcfg will work with Windows 2012 Server

I am back now :)

After a long time, I am thinking to write again.. Hope I can continue writing :)

Best Practice for deleting large records from a table

Request Timed out for Large Table records delaetion.

Even sometime it sayes Transaction Logs Full, or sometime Memory Issues...

So here i get the Best Practice for deleting large records from a table...

WHILE (SELECT COUNT(*) FROM <table name> WHERE [Filter Condition] > 0
BEGIN
DELETE TOP 10 FROM <table name> WHERE [Filter Condition]
END