Get the last date of the month for the given date. Algorithm is:1. Transform given date in “first day of the month” 2. Add a month to result 3. Subtract a day from second result
2007-02-27 (first published: 2004-09-30)
234 reads
This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.
2007-02-27
5,180 reads
In SQL Server 2005, there is a new feature called Plan Guides that can help out in some cases where you discover poorly performing queries that you don't have direct control over. Essentially, a Plan Guide allows you to add or modify query hints to queries on the fly, just before they are executed.
2007-02-26
2,178 reads
All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.
2007-02-23
3,672 reads
XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.
2007-02-22
4,779 reads
2007-02-21
3,644 reads
Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains.
2007-02-20
3,813 reads
Marcin Policht continues his discussion of various types of actions that can be performed using XML Control Flow task, focusing this month on the operation type called XPATH.
2007-02-19
2,476 reads
Gregory Larsen demonstrates several examples of how to deal with different situations related to the case of character strings.
2007-02-16
2,757 reads
Use IsAncestor() to support conditional logic within calculations. BI Architect Bill Pearson introduces IsAncestor(), and then leads a hands-on practice session with this valuable MDX function.
2007-02-15
2,480 reads
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
Security has long been a problem for me. Every time I think I understand...
Comments posted to this topic are about the item BIT_COUNT() V
Comments posted to this topic are about the item How We Reduced SQL Server...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers