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
282 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
11 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
7 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
183 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
9 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
7 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,386 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
276 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
13 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
5 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers