T-SQL correlated queries

Azure Data Lake Analytics using U-SQL Queries

This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.

How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.

Send Query Result as HTML Mail

Send a SQL query result as HTML mail using cdosys

Report SQL SERVER 2005 Permissions

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.

RE: Import from XML to SQL Server 2000

Since you have to manipulate data, what you can do ( which I did too) TRANSFORM your XML files into smaller xml files and during transformation manipulate your data. Than use OPENXML to load your data directly or even can be BULKLOAD.

RE: Odd logs

Really bad. It means that once everybody is out of the database it closes itself. Which doesn't seem really bad, but if you have 200 of those on the same server and you open the database list in EM, you won't even be able to enter one of them because they will constantly open/close. It […]

RE: dimension level member count, cube aggregations and cube re-processing

correct if it's a statement, hard to answer if it's question