SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-20 (first published: 2012-08-12)
8,566 reads
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-20 (first published: 2012-08-12)
8,566 reads
Some time there will be situation in application , where a
grid is populated with data and user has option to edit...
2012-08-09 (first published: 2012-08-01)
6,295 reads
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,476 reads
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,980 reads
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,270 reads
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,482 reads
In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...
2012-08-02
1,429 reads
Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...
2012-08-02
1,706 reads
Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...
2012-08-01 (first published: 2012-07-30)
3,724 reads
In my earlier post I have explained about various quorum settings available in Microsoft windows 2008 cluster environment. While we plan to...
2012-07-23
15,186 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers