For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...
2010-07-23
5,025 reads
Articles
Oracle to SQL Server, Crossing the Great Divide, Part 3
We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.
2010-07-23
3,312 reads
Configuring Alerts for Policy-Based Management
How can I receive notifications when the policies I have implemented have been violated so I don't have to manually look at each server?
2010-07-22
2,954 reads
SQL CLR Data Types and Performance
Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.
2010-07-21
8,097 reads
Gathering Perfmon Data with Powershell
Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.
2010-07-21
3,220 reads
Turn on CHECKSUM after an upgrade
When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.
2010-07-20
7,213 reads
Binary Trees in SQL
A number of hierarchies and networks are most conveniently modelled as binary trees. So what is the best way of representing them in SQL? Joe Celko discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap
2010-07-20
4,764 reads
Setting All Tempdb Data Files to the Same Size
How to set all tempdb datafiles to same size to meet best practice.
2010-07-19
15,954 reads
Shared Datasets in SQL Server 2008 R2
Shared Datasets are one of the features introduced in SQL Server 2008 R2. This article demonstrates how to implement Shared Datasets as well their use-case scenarios.
2010-07-19
4,132 reads
ANSI PADDING, Trailing Whitespace, and Variable Character Columns
What does ANSI_PADDING mean and how does it affect my SQL Server database?
2010-07-17 (first published: 2008-09-12)
25,396 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU KEBAYORAN BARU HUB Tlpn.0821•3111•185
BCA KCU KEBAYORAN BARU HUB Tlpn.0821•3111•185 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela,...
BCA KCU BLOK A CIPETE HUB Tlpn.0821•3111•185
BCA KCU BLOK A CIPETE HUB Tlpn.0821•3111•185 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5,...
BCA KCP Jalan Panjang TLP/WA 08216977749
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers