SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation...
2017-01-27
274 reads
Igor Micev
SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
3 reads
SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
3 reads
My first Microsoft MVP Award!
Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing...
2017-01-10
177 reads
My first Microsoft MVP Award!
Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...
2017-01-10
4 reads
My first Microsoft MVP Award!
Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...
2017-01-10
3 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important too. The system tables also have indexes...
2016-12-23
1,367 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and...
2016-12-23
266 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
3 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
2 reads
Blogs
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
Forums
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers