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
277 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
6 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
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...
2017-01-10
179 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
6 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
5 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,380 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
275 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
9 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
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers