Partitioning in SQL Server 2008
This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.
2010-10-01 (first published: 2009-04-29)
63,328 reads
Muhammad Shujaat Siddiqi
Resource Governor
This article is about Resource Governor. A new feature introduced in SQL Server 2008. Special focus is placed on the T-SQL implementation of the new feature.
2008-09-18
13,224 reads
Blogs
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
ExecutionLog3 table in Reportserver Database
I have a SSRS report for which users are complaining to be slow, but...
SQL Server Maintenance Plan Feedback
Hi I set this up today. I wanted to get some feedback. I have...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers