Andy Warren

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

All authors

SQLServerCentral Article

Check Your SQL Server Identity

Retrieving the identity value from an inserted row should be a very simple task. But based on his survey at TechEd 2005 as well as some recent interviews, Andy Warren points out some of the wrong answers and turmoils he has faced in getting this question answered.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2006-10-27 (first published: )

32,599 reads

All authors

Blogs

Have a Plan for Your Personal Downtime

By

Most of us know that spending a lot of time on social media and...

Monday Monitor Tips: Lots of Postgres Options

By

Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...

Advice I Like: Experience and Aptitude

By

Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...

Read the latest Blogs

Forums

Table Index Size

By Sandir

Comments posted to this topic are about the item Table Index Size

Issues with SQL Server 2022 Server

By alisonwheeler

Hello, At my work place I recently migrated our test environment to SQL Server...

Remote query is taking 99% cost of local sp execution

By anoop.mig29

So we have local sp in which remote table is udpated.this remote query part...

Visit the forum

Question of the Day

Data API Builder APIs

What formats of API endpoints can the Data API Builder present to clients when exposing the database?

See possible answers