neerajgusain.blogspot.com
T-SQL SolutionsThis Blog comprises different TSQL solutons and useful ways to optimize your queries.
http://neerajgusain.blogspot.com/
This Blog comprises different TSQL solutons and useful ways to optimize your queries.
http://neerajgusain.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.7 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
0
SITE IP
172.217.12.161
LOAD TIME
0.734 sec
SCORE
6.2
T-SQL Solutions | neerajgusain.blogspot.com Reviews
https://neerajgusain.blogspot.com
This Blog comprises different TSQL solutons and useful ways to optimize your queries.
neerajgusain.blogspot.com
T-SQL Solutions: April 2012
http://neerajgusain.blogspot.com/2012_04_01_archive.html
This Blog comprises different TSQL solutons and useful ways to optimize your queries. Monday, April 9, 2012. Difference beween Rank(), Dense Rank(), Row number(). DECLARE @OrderRanking AS TABLE. OrderID INT IDENTITY(1,1) NOT NULL,. INSERT into @OrderRanking (CustomerID, OrderTotal). SELECT 1, 1000. SELECT 1, 500. SELECT 1, 650. SELECT 1, 650. SELECT 1, 3000. SELECT 2, 1000. SELECT 2, 2000. SELECT 2, 500. SELECT 2, 500. SELECT 3, 500. SELECT 3, 20. SELECT * FROM @OrderRanking. Subscribe to: Posts (Atom).
T-SQL Solutions: July 2011
http://neerajgusain.blogspot.com/2011_07_01_archive.html
This Blog comprises different TSQL solutons and useful ways to optimize your queries. Friday, July 22, 2011. TSQL query to split full name into firstname and lastname. This script only works with combination of firstname ' ' lastname. SUBSTRING(fullname, 1, CHARINDEX(' ', fullname) - 1) as firstname. SUBSTRING(fullname, CHARINDEX(' ', fullname) 1, LEN(fullname) as lastname. Subscribe to: Posts (Atom). View my complete profile. TSQL query to split full name into firstname and l.
T-SQL Solutions: This is to get a list of Running Transactions.
http://neerajgusain.blogspot.com/2013/12/this-is-to-get-list-of-running.html
This Blog comprises different TSQL solutons and useful ways to optimize your queries. Monday, December 2, 2013. This is to get a list of Running Transactions. SELECT sqltext.TEXT,. FROM sys.dm exec requests req. CROSS APPLY sys.dm exec sql text(sql handle) AS sqltext. Where DB NAME(req.database id) = ‘master’. Subscribe to: Post Comments (Atom). View my complete profile. This is to get a list of Running Transactions. Simple template. Powered by Blogger.
T-SQL Solutions: August 2011
http://neerajgusain.blogspot.com/2011_08_01_archive.html
This Blog comprises different TSQL solutons and useful ways to optimize your queries. Friday, August 5, 2011. Introduced in SQL Server 2008 : DateTime and DateTime2. The datetime2 datatype was introduced in SQL Server 2008 along with the date and time datatypes. Unlike the datetime datatype in SQL Server, the datetime2 datatype can store time value down to. Microseconds and avoids the 3/1000 second rounding issue. The precision with a datetime2 is upto 100 nanoseconds. DECLARE @dt AS DATETIME. Simple tem...
T-SQL Solutions: December 2010
http://neerajgusain.blogspot.com/2010_12_01_archive.html
This Blog comprises different TSQL solutons and useful ways to optimize your queries. Thursday, December 23, 2010. SQL Server 2008 New DATETIME DataTypes. The DATETIME function’s major change in SQL Server 2008 is the four DATETIME data types introduced. They are. CREATE TABLE Table1 ( Column1 date. Default string literal format. January 1, 1 A.D. through December 31, 9999 A.D. YYYY is four digits from 0001 to 9999 that represent a year. 3 bytes, fixed. 1, 3-byte integer stores date. 8 positions minimum ...
TOTAL PAGES IN THIS WEBSITE
19
Family Mediator | Toronto Mediation | Lawyer | Toronto Collaborative Divorce
If you are Separating/Divorcing. Neeraj Goel: Your Toronto Family Lawyer for. Family Mediation, Collaboration and Negotiation. I offer three main process options for helping clients resolve their family law issues: family mediation. Practice hours at my downtown Toronto family law office are Monday to Friday, 9:00 am to 6:00 pm Evening and weekend appointments may also be available on request. To discuss your family law situation I’m here to help! 100 King Street West. Toronto, ON M5X 1C7.
neerajgoelcollaborativefamilylawyer.blogspot.com
Toronto Collaborative Family Lawyer and Family Mediator
Toronto Collaborative Family Lawyer and Family Mediator. I am a collaborative family lawyer and family mediator in Toronto. I work with clients who are seeking to separate/divorce in a respectful out-of-court process. I help clients to deal with issues of property division, support and parenting. This blog contains information and insights regarding my practice. Thursday, January 16, 2014. It's about the process you choose. These process choices are:. 4 Traditional Negotiation: Each party hires their own...
Neeraj Granites | Connect With Clarity
Granites Shades and Colors. Logistics & Exports. We have created great designs with unique styles. We have created great patterns and amazing designs for our customers. We always keep in mind our client’s requirements an work accordingly giving them satisfactory results. We work with the companies to give them a feel of elegance and luxury. Our range of Granite. Regale your surroundings with our exquisite collection of marble decoratives.Lend a spice of luxury to the exteriors of your building with o...
Grover's Law Studio
Advanced law research and opinion. Powered by InstantPage® from GoDaddy.com. Want one?
Neeraj Gulati, Neeraj Gulati Assotech, Neeraj Assotech
Managing Director – Assotech Realty (P) Ltd. As a managing director of the company, Mr. Gulati is responsible for developing the overall strategy for Assotech. Visit www.assotech.in. To know more about Assotech Realty.
T-SQL Solutions
This Blog comprises different TSQL solutons and useful ways to optimize your queries. Tuesday, March 27, 2018. New features of SQL Server 2016 - Developers. New Features of SQL Server 2016. SQL Server 2016 – Part 1. Getting Started with Stretch Database Functionality in SQL Server 2016 - Part 2. Row Level Security with SQL Server 2016: Part 1 – Allow Access to Only a Subset of Rows Using Row Level Security. Row Level Security with SQL Server 2016: Part 2 - Blocking Updates at the Row Level. WITH (SYSTEM ...
Neeraj and Prachi Wedding Invitation
Hi Dear ones welcome to our wedding invitation. Since most of you haven't seen us through our courting days, we think it is essential to keep you updated. ;-). Om Shri Ganeshaya Namaha. Smt Nisha and Shri Ummed Singh Gusain. Request the pleasure of your company on the auspicious occasion of the marriage ceremony of their son. Smt Saroj and Shri Surendra Singh Negi). On 10 Feb 2012 (Friday). Nine Palms Garden, Badripur,. Haridwar Road, Dehradun. Congratulations to you and your wife. May this day you share...
Gut Feeling
I write because it helps me to sort out my thoughts in my mind. What I write here is just "Gut feeling" and may not be 100% correct. It is "food for thought" which I plan to refine with your input. To appreciate my Gut power don't forget to check the ‘I told you so’ section under archive. Enter your email address:. View my complete profile. Neeraj.gutgutia@yahoo.co.in. My blogs where I predicted the currect financial crisis. Link between US slowdown and India's slowdown. Chidambaram - the bubble maker I.
Neeraj Handa
On life, love and code. Sunday, January 13, 2013. Well, I have been posting on my old/original blog The Road Most Travelled. For quite some time now, and plan to do so for quite some time in the future as well. This is until I figure out what keeps me posting there (and not here). It may either be the name (The Road Most Travelled), or just the sheer awesomeness of Wordpress. Friday, October 19, 2012. The Truth, by Bob Marley. Wednesday, May 16, 2012. Tuesday, September 14, 2010. 2 The Walk Back Home.
Neeraj | Herbal – Orgo Agro Tech
304 Hassanand Complex, Godha Street,Nanpura. 304 Hassanand Complex, Godha Street,Nanpura. We Are Neeraj Herbal. GROW GREEN – Herbal Growth With Greenery. Kam Dhenu – Food Supplements. Target – Herbal Termiticide With Growth. Neer Ankush – Herbal Pre-Emergent Weed Control. Neeraj Herbal 2017 Powered By Softieons.
neeraj hirani -
A mini-essay in praise of action. Assuming you have good intent, why are you stuck? A mini-essay in praise of action.
