Miscellaneous
Who is online?
0
guests and
3
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Create a new article
Home
»
Articles
» Miscellaneous
Communifire Articles
Topics
Most recent articles
Featured articles
.Net Development
Analysis Services
MDX and DMX
SSAS Administration
SSAS Development
Business
Data Mining
Data Warehouse Performance Tuning
Data Warehousing Design
Integration Services
SSIS Administration
SSIS Development
Miscellaneous
Press Releases
Product Reviews
Reporting Services
SSRS Administration
SSRS Development
Training and Certification
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: 475
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: 1705
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: 1359
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: 1568
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: 507
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: 1379
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: 474
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: 446
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: 1127
Page 1 of 1 (9 items)