If you want to create pivoted tables but found the PIVOT operator syntax in SQL Server Books Online (BOL) confusing, try this three-step approach to creating a PIVOT query. This query uses a common table expression (CTE).
Control access to SharePoint’s functionality and external systems by defining Active Directory service accounts and assigning administrative permissions to users and groups on SharePoint’s internal security layers.
In two previous articles, I've discussed SQL Server 2005 waits and showed you some of the more common ones. Now, let's dive down for a deeper view of what each connection or even thread in the SQL Server instance is waiting on.
A recent project I’ve been working on involves powering advanced Silverlight 2 interfaces with data coming from Analysis Services cubes via Windows Communication Foundation (WCF).
Some refinements to Index_Evaluation_USP make this T-SQL stored procedure more effective and easier to use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.
Although set-based solutions to running aggregations have many advantages over cursor-based solutions, cursor-based solutions can provide better performance in certain cases, such as when dealing with very large partitions.
Deleting all the records in a database can be tricky when it includes tables with foreign keys. Here's a script you can use if you have ALTER TABLE permission and a stored procedure you can use if you don't.
Stored procedures, user-defined functions, views, and triggers can fail to execute when the objects they reference have been changed. Here's a tool you can use to detect broken objects before they cause problems.
Using a looping algorithm to determine the average number of days between orders can be painfully slow code to write and run. A better approach is to use the ROW_NUMBER function.
The QuickClick Library in Idera's PowerShellPlus 3.0 features around 100 prepackaged scripts and commands for performing tasks in Windows, Active Directory, SharePoint, VMware, and other areas.
After discovering a useful T-SQL stored procedure, a reader and his coworkers adapt it so it can perform more types of searches and more refined searches when needed.
