there are 1000 reasons to celebrate
As many of you know, I created a facebook group named 'Living For SQL Server' couple of months back.
SQL Server...
2013-08-05
1,375 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
Special Recognition For Top Community Leaders In India
I got a special recognition from Microsoft, India as one of the top community leaders.
My sincere thanks to SQLServerCentral (my...
2013-06-19
1,296 reads
Few thoughts and updates
Few of my regular readers may have noticed I am not actively blogging @ SSC at frequent interval.
There is a reason behind...
2013-06-14
1,163 reads
Mar'2013 Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Mar'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:00...
2013-03-11
1,354 reads
Chennai SQL Server User Group Looking For Sponsors
Chennai SQL Server Group (CSSUG), one of the most active UG in India planning to conduct major SQL Server event (Q2 this...
2013-03-08
1,624 reads
Feb'2013 Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Feb'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...
2013-02-05
1,227 reads
Few thoughts
I would like to share few thoughts/updates with our SQL Server community.
1. While checking my SSC blog posts, i realised that my...
2013-01-21
1,320 reads
Free SQL Server Learning Resources - Jan'2013
Database Normalization (some useful links)
http://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normstep.html
http://www.guru99.com/database-normalization.html
http://www.aliencoders.com/content/basics-normalization-examples
SQL Server Programming Fundamentals (some useful links)
http://www.blackwasp.co.uk/SQLProgrammingFundamentals.aspx
http://beginner-sql-tutorial.com/sql-select-statement.htm
SQL Server Database Administration
DBA Responsibilities
http://www.bradmcgehee.com/2011/12/the-day-to-day-tasks-of-the-average-dba/
DBA Best Practices
http://www.bradmcgehee.com/presentations/
Free eBooks (to...
2013-01-02
3,389 reads
SQLOS Basics - Chennai User Group Meet - Presentation File Download
Chennai SQL Server User Group (CSSUG) meet is happening tomorrow (15-Dec-2012) in Microsoft Training Centre, Chennai.
You can download presenation and demo scripts here
http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/CSSUG_SQLOS_Basics_15Dec2012/SQLOS_CSSUG_Meet_15Dec2012.zip
Tomorrow, I...
2012-12-14
2,212 reads
46756e2057697468205061756c2052616e64616c
49206a75737420747765657465642062656c6f7720656d6f74696f6e616c206d65737361676520746f205061756c2052616e64616c20696e204865782e202020
224a4d5057465a50565142564d53424f45424d22202020
54686f7567687420686520776f756c642067657420746865206d65737361676520616e64207265706c79206d6520696e203135206d696e757465732e202020
4775657373206865207761732076657279206275737920617420746861742074696d652e2048652067617665207570206166746572203220636c75657320616e642032
20617474656d7074732e202020
4861707079207468617420492073706f696c6564206869732076616c7561626c652035206d696e75746573203a2d29202020
4465616c20686572652069732068652068617320746f2066696e642074686520616e73776572206f6620686973206f776e206f7220656c7365
2068652068617320746f202020
6368616e676520686973206f70696e696f6e20616e6420737570706f727420746865206e656564206f6620646f63756d656e74696e67
20616e61746f6d6f79206f6620742d6c6f67202020
7265636f7264732e202020
497420746f6f6b206d6f7265207468616e20313020686f757273206a75737420746f20756e6465727374616e64
206c6974746c6520626974206f662073696d706c6520494e53455354202020
6c6f67207265636f72642e20202020
687474703a2f2f7777772e73716c73657276657263656e7472616c2e636f6d2f626c6f67732f6c6976696e67666f7273716c7365727665722f3230313
22f31312f32372f74696d652d706173732d776974682d7472616e73616374696f6e2d6c6f672d706172742d352d696e736572742f202020
5468696e6b2069747320696d706f737369626c6520746f20646f63756d656e7420616e61746f6d79206f6620616c6c207479706573206f66
20742d6c6f67207265636f7264732e202020
4275742069742063616e20626520646f6e6520746f20736f6d6520657874656e642e202020
496620796f75206172652072656164696e6720746869732c20646f6e7420666f7267657420746f20636f6d6d656e7420796f7572206e616d6520696e
204865782e1f1f
706c6561736520646f6e27742074616b65207468697320736572696f75736c792e204a75737420612066756e20617474656d70742e202020
2012-12-07
1,819 reads
Blogs
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
Forums
Building AI Governance and Policies- First Steps
Comments posted to this topic are about the item Building AI Governance and Policies-...
Simple delete causes table scan on other tables with foreign key
Why is sql doing a full scan VS seeking on the index? I've included...
Show/Hide number of rows in table
We have a report that has multiple tables that list the top 15 performers...
Question of the Day
Checking Identities
The DBCC CHECKIDENT command is used when working with identity values. I have a table with 10 rows in it that looks like this:
TravelLogID CityID StartDate EndDate 1 1 2025-01-11 2025-01-16 2 2 2025-01-11 2025-01-16 3 3 2025-01-11 2025-01-16 4 4 2025-01-11 2025-01-16 5 5 2025-01-11 2025-01-16 6 6 2025-01-11 2025-01-16 7 7 2025-01-11 2025-01-16 8 8 2025-01-11 2025-01-16 9 9 2025-01-11 2025-01-16 10 10 2025-01-11 2025-01-16The docs for DBCC CHECKIDENT say this if I run with only the table parameter: "If the current identity value for a table is less than the maximum identity value stored in the identity column, it is reset using the maximum value in the identity column. " I run this code:
DELETE dbo.TravelLog WHERE TravelLogID >= 9
GO
DBCC CHECKIDENT(TravelLog, RESEED)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-09-14', '2025-09-17')
GO
What is the identity value for the new row inserted by the insert statement above? See possible answers