Miscellaneous

Miscellaneous

• • Email
  
  Script to generate testing database tables and dummy records
  This sample script will generate testing database with hundreds of tables, columns, views and procs with sample data.
  tags : database testing script, sample data generation script
  NayanPatel   -  7/13/2011   -  Comments: 4  -  Views: 666
• • Email
  
  Joins From A Common Sense Perspective
  In this article, Sherri McDonald gives an overview of the common Join commands and has also included examples and diagrams.
  tags : Sherri McDonald, Pragmatic Works, SQL Joins
  SMcDonald   -  11/28/2010   -  Comments: 1  -  Views: 2078
• • Email
  
  Disecting the Self Referencing Hierarchy
  In this article Brad will discuss how to flatten a table that is built on a self referencing hierarchy using DimEmployee as an example from the AdventureWorksDW database.
  tags : SQL, Hierarchy
  BradSchacht   -  10/21/2010   -  Comments: 1  -  Views: 1453
• • Email
  
  Edit/Select Top N Rows in SQL Server Management Studio
  In this article, Brian will show you how to quickly modify the default settings of SQL Server Management Studio (SSMS) to enable editing of more than top 200 rows. He will also show you how you can set the results to return more than the default 1000 rows...
  tags : SQL Server Management Studio, Edit top , Select Top
  briankmcdonald   -  7/29/2010   -  Comments: 0  -  Views: 1870
• • Email
  
  Local SQL Server Logins
  In this article, I explain how to troubleshoot permissioning issues when you create SQL Server Logins and are unable to log into the SQL Server instance.
  tags : SQL Server Logins, Security
  briankmcdonald   -  5/4/2010   -  Comments: 0  -  Views: 560
• • Email
  MetaData Driven ETL (MDDE) System
  Interesting approach to tedious ETL development for systems with large amounts of source data - only accessible via ODBC
  tags : MDDE ETL MERGE
  howarddiesel   -  1/16/2010   -  Comments: 2  -  Views: 1570
• • Email
  Vote for new Service Packs for SQL 2005 and 2008
  We need new Service Packs for Sql 2005 and 2008.
  sqlscottgleason   -  12/31/2009   -  Comments: 2  -  Views: 530
• • Email
  Don't be too quick to use a cursor
  A quick explanation and example of using the OUTPUT clause of a T-SQL Insert statement to capture an Identity column value for further processing
  tags : Cursor, Output clause, identity
  jtarnott   -  12/22/2009   -  Comments: 1  -  Views: 503
• • Email
  Populating AutoComplete List in outlook with all contacts (Rebuild Outlook NS2 File)
  This article will show you how to populate auto complete list of Outlook so when you send email to someone you always have email address visible in the auto complete list.
  tags : Outlook Tips
  NayanPatel   -  12/2/2009   -  Comments: 0  -  Views: 1345