SQL Server Myth on Clustered Index page allocation or B-Tree formation
Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...
2011-07-11
2,348 reads
Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...
2011-07-11
2,348 reads
It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management...
2011-06-28
3,794 reads
I got a report from development team that section of BizTalk communicating with SQL Server to update status
is frequently...
2011-02-24
1,186 reads
I got a chance to evaluate performance of both views and stored procedure for high level decision making.
As all of Us knows that purpose/scope...
2011-02-13
11,559 reads
Anyone who can interpret data and index pages will surely think about interpreting PFS, GAM and SGAM pages. I am...
2011-02-13
5,583 reads
In this article we are going to see how index pages are organized with data pages and how to read different...
2010-12-29
7,587 reads
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-29
5,713 reads
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-27
9,477 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-27
4,468 reads
I like to share 4 updates before moving on to this section:
1. I 've updated my profile to know more about...
2010-12-21
7,716 reads
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
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...
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