sys.dm_db_partition_stats DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms187737.aspx
Returns page and row-count information for every partition in the...
2013-09-09
974 reads
When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be...
2013-09-09
1,787 reads
Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...
2013-09-09
798 reads
I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the...
2013-09-09
1,036 reads
2013-09-09
5 reads
This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam....
2013-09-08
703 reads
The transaction log is a very important part of SQL Server. Every data modification operation is logged in the transaction...
2013-09-07
746 reads
I like most of the SQL Server people I meet. Most of you are polite, cheerful, friendly, and it’s nice...
2013-09-06
863 reads
#The following SID registry entry to be deleted across all mutiple Machines, SID is a user #who owns this user...
2013-09-06
2,664 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-09-06
843 reads
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers