This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
2012-03-07
7,756 reads
Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.
2010-06-29
9,617 reads
Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.
2009-05-03 (first published: 2008-08-01)
2,098 reads
Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.
2008-10-17 (first published: 2008-08-01)
3,103 reads
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
2012-12-27 (first published: 2008-08-01)
7,756 reads
Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.
2009-01-19 (first published: 2008-08-01)
2,458 reads
In addition to the fact that it takes less time to spin up on the Reporting Services, I trust the Database Driver for SQL to release connections (which I've been having no end to problems with Crystal), more of our people are familiar with the Visual Studio environment, etc, etc. Makes it more cost effective […]
2004-07-23
2 reads
Can i do some thing like this?. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE EXPORT_IMPORT_DATA(@direction CHAR(20)) AS DECLARE @Table_Name CHAR(100) DECLARE @sql CHAR(200) DECLARE tablename_cursor CURSOR FOR SELECT name FROM sysobjects WHERE xtype = 'U' OPEN tablename_cursor FETCH FROM tablename_cursor INTO @Table_Name WHILE @@fetch_status = 0 BEGIN BEGIN TRANSACTION IF @direction = […]
2003-11-21
1 reads
quote: I have had this problem before and the solution was to create the procedure from QA not EM. Do you have to create the proc from DTS? Could you not call the procedure from DTS? The point is to create the view dynamically and this is only one step in a very complex DTS […]
2003-11-19
1 reads
No problems, Frank. I'm back from a vacation in Boston. I'll be posting again this week. Thanks for missing me. This looked like a good thread. I'm with you on the Books Online thing. That's exactly how I learned SQL and felt it was more thorough than taking a training class 'cause I had to […]
2003-07-23
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers