Security Audit Db_DataReader
Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.
2011-04-14 (first published: 2011-03-29)
1,080 reads
Scripts
Extend CHARINDEX with occurance matching
Retrieve the charindex of matching string for the desired occurrence
2011-04-13 (first published: 2011-04-06)
1,491 reads
date convertion to different time zone covering multiple location
converting a date from existing timezone to some different time zone covering multiple location
2011-04-05 (first published: 2011-03-24)
1,170 reads
2011-04-01 (first published: 2008-02-23)
3,771 reads
Comparing Stored Procedures, Part 3
Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-30 (first published: 2009-02-16)
2,425 reads
Comparing Stored Procedures, Part 2
Second in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-29 (first published: 2009-02-09)
2,499 reads
2011-03-28 (first published: 2009-02-06)
8,090 reads
SQL 2005 Rebuild\Reorganize Indexes with Reports
This custom sp rebuilds \ reorganizes indexes for SQL 2005 databases and logs results for further analysis.
2011-03-25 (first published: 2009-02-16)
7,185 reads
My favorite way to access Excel files
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,848 reads
2011-03-18 (first published: 2010-09-21)
2,822 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
FARE LABS Pvt. Ltd. is an Indian proficiency testing laboratory.
India's top proficiency testing facility is Fare Labs. We employ particular metrics or evaluations...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
Question of the Day
The Maximum Value in the Identity Column
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')
I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON
INSERT dbo.TravelLog
(
TravelLogID,
CityID,
StartDate,
EndDate
)
VALUES
(25, 5, '2025-09-12', '2025-09-17')
SET IDENTITY_INSERT dbo.TravelLog OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers