Gopal, your password was successfully reset

Tuesday, 2 December 2014

You reset your password.

 
 
Hi Gopal,
You've successfully changed your LinkedIn password.
Thanks for using LinkedIn!
The LinkedIn Team
When and where this happened:
Date: December 2, 2014 11:55 AM
Browser: Chrome
Operating System: Windows
IP Address: 114.143.97.209
Approximate Location: Mumbai, Maharashtra, India
Didn't do this? Be sure to change your password right away.
This email was intended for Gopal Chettri (Sr. Software Developer). Learn why we included this.
©2014 LinkedIn Ireland, Gardner House, Wilton Plaza, Wilton Place, Dublin 2, Ireland

Gopal, your password was successfully reset

Wednesday, 17 September 2014

You reset your password.

 
 
Hi Gopal,
You've successfully changed your LinkedIn password.
Thanks for using LinkedIn!
The LinkedIn Team
When and where this happened:
Date: September 17, 2014 10:14 PM
Browser: Chrome
Operating System: Windows
IP Address: 122.179.177.17
Approximate Location: Mumbai, Maharashtra, India
Didn't do this? Be sure to change your password right away.
This email was intended for Gopal Chettri (Software Developer). Learn why we included this.
©2014 LinkedIn Ireland, Gardner House, Wilton Plaza, Wilton Place, Dublin 2, Ireland

Gopal, here's the link to reset your password

Info about changing your password

 
 
Hi Gopal,
You recently requested a password reset.
To change your LinkedIn password, click here or paste the following link into your browser: https://www.linkedin.com/e/rpp/65721660/mageshwaran%2Esubramanian%2Ethinksql%40blogger%2Ecom/6689409392919487395/?hs=true&tok=2WIGjFLK0DR6o1
The link will expire in 24 hours, so be sure to use it right away.
Thanks for using LinkedIn!
The LinkedIn Team
This email was intended for Gopal Chettri (Software Developer). Learn why we included this.
©2014 LinkedIn Ireland, Gardner House, Wilton Plaza, Wilton Place, Dublin 2, Ireland

I'd like to add you to my professional network on LinkedIn

Monday, 15 September 2014

 
Mageshwaran Subramanian
Mageshwaran Subramanian
Data Migration Consultant at Utopia
Bengaluru Area, India
I'd like to add you to my professional network on LinkedIn.
- Mageshwaran
Confirm that you know Mageshwaran
You received an invitation to connect. LinkedIn will use your email address to make suggestions to our members in features like People You May Know. Unsubscribe
Learn why we included this.
If you need assistance or have questions, please contact LinkedIn Customer Service.
© 2014, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA

creating an Identity column

Tuesday, 1 March 2011

This will create an identity column in the following table.
CREATE TABLE dbo.MyTable (    ID INT IDENTITY(1,1)    ,MyShortDesc varchar(20)     ,MyLongDesc varchar(500)    );

Data file locations

Thursday, 3 June 2010

Here's a query which displays the .mdf and .ldf location of all the databases in the server.



SELECT physical_name
FROM master.sys.master_files

Sequence number within a group

Saturday, 10 April 2010

The following query can be used to generate the sequence numbers within a group.

select 
 GROUP_ID
, GROUP_COUNTER= ROW_NUMBER()
                                      OVER (  PARTITION BY [GROUP_ID]
                                                    ORDER BY [GROUP_ID]
                                                   ) 
from GROUP_TABLE

This query can generate a output like the following.

GROUP_ID       GROUP_COUNTER
-------------------------------------------
AAA                   1
AAA                   2
AAA                   3
BBB                    1
BBB                    2
CCC                   1


SQL Server Video tutorials

Tuesday, 20 October 2009

There are some good video tutorials available here.Check it out.

An interesting article - Selecting Duplicate Rows in a table

Sunday, 18 October 2009

Hi All, we are back after a pause.Here's an interesting article which talks about the different ways of selecting the duplicate rows from a table.Hope it will be useful to you.


Article

Question of the day

Friday, 25 September 2009

Can you instantiate a COM object by using T-SQL?

1. True
2. False

T-SQL best practices - 4

Wednesday, 23 September 2009

- The dynamic SQL Performs slower because the optimizer has to create an execution plan for every execution.


-Use table aliasing, even if there is no joining in the query. Aliasing eliminates ambiguity, eases subsequent modification, and further reduces the chance of a typo not being recognized.

-When querying a table, prefix it with the owner (schema), typically dbo. There is a little performance improvement and query becomes more readable

Question of the Day


What are the disadvantages of cursors?


1. Cursor results in a network roundtrip
2. Cursor requires more resources and temporary storage
3. Cursor results in more IO operations
4. 1 & 2
5. 1, 2 & 3
6. None

T-SQL best practices - 3

Tuesday, 22 September 2009

Today's tips are not really related to T-SQL,but I hope these will improve the way you approach SQL SERVER.

Get Certified
Subscribe to News Groups and blogs to get regular updates
- Read White papers

T-SQL best practices - 2

Monday, 21 September 2009

Today's best practice techniques are


- NOLOCK helps in concurrency and performance but can be dangerous for data integrity

- Use XML datatype to pass table valued parameters to procedures.

- Use SQL Server Management Console with integrated Source Control to do the development


T-SQL best practices - 1

Sunday, 20 September 2009

Hi All!...we decided to write some posts on the best practices in writing T-SQL,which we think helpful to the newbies.We will list three best practices each day for the next seven days and hope this series will be helpful to all the readers.So today's best practices tips are,


Document your database
Use Extended properties of the table structures to document the database.
Use tools to generate the documentation and correct where necessary
Maintain the script for populating the extended properties.
Use Cursors only when
You cannot find a set based solution in 4 Hours
You want to utilize already existing logic in other SP
You are writing a database maintenance task
Use STATISTICS IO ON
–This will reduce the logical reads

We need your comments on this post and share the best practices that you are using in the script(related to the above 3 techniques).