SQL Server Storage Internals Part 3 - Architecture of Heaps
In this article I have explained below topics
1. key points on HEAP tables.
2. What happens when a table is created.
3. How to list...
2010-12-19
5,563 reads
In this article I have explained below topics
1. key points on HEAP tables.
2. What happens when a table is created.
3. How to list...
2010-12-19
5,563 reads
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-16
15,071 reads
While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels...
2010-12-13
6,791 reads
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-08
3,073 reads
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-05
5,416 reads
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers