UPDATE Basics in SQL Server
SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts simply, and introduces the more complex forms painlessly.
High End or Low End
Steve Jones talks about the need to perhaps get more depth and breadth to the information that we present at events like SQL Saturday to help people learn at all levels.
Using Ranking Functions to Deduplicate Data
This article from Andrew Riley will show you how you can use the RANK and ROW_NUMBER Ranking Functions to deduplicate data in SQL Server 2005
Dynamic Data Driven Variable Hierarchical Structures in SQL
This article describes data driven variable structure generation in SQL. The controlling data can be located higher up on the hierarchical pathway or can be located further down on the pathway producing a look-ahead operation. Multiple pathways can independently produce dynamic data driven structures and these dynamic structures can be nested allowing a very flexible and powerful dynamic automatic data structure generation capability. These different controls of structure generation can be combined.
Instant File Initialization Speeds SQL Server
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
Issues with running DBCC SHRINKFILE on your data files
Why would database performance remain low and fragmentation high event though the entire database has been defragmented every night? In this tip we cover how SHRINKFILE works and some of the issues it might create.
Data Distribution - Part 1
The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.
Software Vendor Security
This week Steve Jones finds some issues with the security of third party vendor software.
Thinking Time
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
Top Ten Reasons to Attend the 2010 PASS Community Summit
There are some good reasons to think about attending the 2010 PASS Community Summit.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers