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,560 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,560 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
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,269 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
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,480 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
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
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,177 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers