<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,641,247 DBAs, developers and SQL Server users
Headlines today
June 18, 2013
Usage of CTE - Trick with Dates
This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.
Read more...
By
Suresh Maganti
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
cursor vs recursive cte
Rating:
|
Discuss
|
Briefcase
|
9,762 reads
Attention users running SQL Server 2008 & 2008 R2!
Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.
Read more...
By
Press Release
2013/06/18
|
Source:
SQL Blog
|
Category:
cumulative updates (cu)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
5,061 reads
PASS Data Architecture Virtual Chapter presents Steve Simon
On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.
Read more...
By
Press Release
2013/06/18
|
Source:
PASS
|
Category:
pass virtual chapters
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,045 reads
Managing Slowly Changing Dimension with MERGE Statement in SQL Server
Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.
Read more...
By
Additional Articles
2013/06/18
|
Source:
Database Journal
|
Category:
slowly changing dimension
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,375 reads
Show more
Previous headlines
PowerShell vs GUI Availability Group Rebuild
Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands
Read more...
By
Paul Brewer
2013/06/17
|
Source:
SQLServerCentral.com
|
Category:
windows cluster
Rating:
|
Discuss
|
Briefcase
|
1,935 reads
Getting Started with the SSAS Tabular Model
SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to provide a rapid and powerful way of providing self-service BI to client applications such as Microsoft Excel and Microsoft Power View. You’ve deployed SSAS in tabular mode, and deployed Adventureworks into it. What next? Rob Sheldon explains all.
Read more...
By
Additional Articles
2013/06/17
|
Source:
SimpleTalk
|
Category:
ssas
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,490 reads
SQL Saturday #229 - Dublin
SQL Saturday Dublin is hosting a two-day training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development. The free training event will be Saturday June 22 2013, and three preconference sessions (not free) will take place the 21st.
Read more...
By
Press Release
2013/06/17
|
Source:
SQLServerCentral.com
|
Category:
sql saturday
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,384 reads
Custom Sequence Numbering
This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function
Read more...
By
James Skipwith
2013/06/14 (first published: 2011/02/07)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
16,692 reads
SQL Server Integration Services Package Restartability
I've tried using SSIS checkpoints, but have found them to be difficult to configure and, on occasion, unpredictable. Is there a better way to build in restartability in my SSIS packages?
Read more...
By
Additional Articles
2013/06/14
|
Source:
MSSQLTips.com
|
Category:
ssis
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,792 reads
Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container
An SSIS ETL package created with the Import/Export Wizard uses a Data Flow Task to process one data file at a time. If the need arises, however, the Data Flow Task generated by the wizard can be embedded inside a Foreach Loop Container to batch-process a continuous stream of data files.
Read more...
By
Stan Kulp
2013/06/13
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
3,758 reads
From the SQLServerCentral Blogs
Pivoting weird data in SSIS – Sort of…
Sometimes we get data in some bad forms. For example look at the below table: The names and the amounts are...
Read more...
By
MikeDavis
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
763 reads
Browse all
Question of the Day
ALL clause in SQL Server
By
Chirag Patel
2013/06/18
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,023 reads
How many rows will the select statement return as a result?
CREATE TABLE Emptable
(Empid INT IDENTITY,
Departmentid INT,
Name VARCHAR(10),
Addr VARCHAR(10))
GO
INSERT INTO Emptable
VALUES
(2,'Name1','Addr1'),
(5,'Name2','Addr2'),
(6,'Name3','Addr3'),
(3,'Name4','Addr4'),
(2,'Name5','Addr5'),
(3,'Name6','Addr6'),
...
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
Oleg Kryzhanovsky
1005
1006
Ten Centuries
2.
chihaia_ciprian
438
1078
Ten Centuries
3.
GilaMonster
411
38062
SSChampion
4.
Sean Lange
410
8957
SSCrazy Eights
5.
Aadhar Joshi
409
1453
Ten Centuries
Show more
Latest forum posts
Detect missing db FULL backup and backup that db
By
sandtoad2
|
Jun 18, 2013
Posted to
SQL Server 2008 Administration
smart first name matching in TSQL
By
Jan Van der Eecken
|
Jun 18, 2013
Posted to
T-SQL (SS2K8)
Adding parameter to SqlCommand hides query from the profiler
By
ericjorg
|
Jun 18, 2013
Posted to
SQL 2012 - General
Split data column with comma into seperate columns
By
Jeff Moden
|
Jun 18, 2013
Posted to
SQL Server 2012 - T-SQL
adding line break changes execution plan
By
Jan Van der Eecken
|
Jun 18, 2013
Posted to
T-SQL (SS2K5)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
