<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,640,964 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
|
755 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
|
360 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
|
77 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
|
123 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,731 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,304 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,110 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,382 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,591 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,611 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
|
101 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
|
75 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
1004
1005
Ten Centuries
2.
chihaia_ciprian
438
1078
Ten Centuries
3.
Aadhar Joshi
409
1453
Ten Centuries
4.
Sean Lange
391
8938
SSCrazy Eights
5.
GilaMonster
388
38028
SSChampion
Show more
Latest forum posts
Stop particular event logging in SQL Server errorlog
By
Kumar-386306
|
Jun 18, 2013
Posted to
SQL Server 2008 Administration
How to prevent ANY use of xp_CmdShell?
By
Jeff Moden
|
Jun 18, 2013
Posted to
Security (SS2K8)
Usage of Null
By
sqlnaive
|
Jun 17, 2013
Posted to
Discuss content posted by Bhavpreet Singh Narang
SQL agent job fails when accessing the csv file
By
Sacheen
|
Jun 17, 2013
Posted to
Integration Services
Step fails, but job reports success.
By
ralphmayer12
|
Jun 17, 2013
Posted to
Administering
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
