I am trying to determine which of the logical volumes on the shared disk are associated with each SQL Server instance. Is there a simple method in T-SQL to determine this without having to fire up Cluster Administrator?
2009-01-14
2,392 reads
Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.
2009-01-13
3,724 reads
T-SQL scripts and stored procedures don’t produce their PRINT statements and RAISERROR output in a way that keeps you informed of the code’s progress. You usually have to wait until the procedure is complete before seeing messages. How can I get insight into the code's progress?
2009-01-13
2,944 reads
SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.
2009-01-12
4,656 reads
Join MSAS Architect Bill Pearson as he leads the hands-on creation of a simple bar chart based upon an Analysis Service data source.
2009-01-09
2,644 reads
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.
2009-01-09
2,868 reads
We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?
2009-01-08
4,369 reads
SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.
2009-01-08
2,732 reads
2009-01-07
1,834 reads
The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures.
2009-01-07
5,779 reads
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Powershell script to generate SQL...
Comments posted to this topic are about the item Database Ledger in SQL Server...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers