<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,394 DBAs, developers and SQL Server users
Headlines today
June 19, 2013
An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services
In this level of the Integration Services Stairway article, Andy Leonard examines SSIS variables.
Read more...
By
Andy Leonard
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
2,571 reads
Review: Stellar Phoenix SQL Database Recovery
Stellar Phoenix SQL Database Recovery Software Review
Read more...
By
Prett Sons
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
reviews
Rating:
|
Discuss
|
Briefcase
|
271 reads
Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.
Read more...
By
Additional Articles
2013/06/19
|
Source:
MSSQLTips.com
|
Category:
recovery model
Rating:
(not yet rated)
Rate this
|
Briefcase
|
800 reads
Show more
Previous headlines
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
|
11,082 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,849 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,392 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,606 reads
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
|
2,020 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,589 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,546 reads
From the SQLServerCentral Blogs
ORDER BY the numbers
Have you ever needed to order by a calculated column? You might have written it something like this: SELECT LoginID, YEAR(HireDate)...
Read more...
By
Kenneth Fisher
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,213 reads
Browse all
Question of the Day
SQL CHOOSE
By
Bill Lantz
2013/06/19
|
Category:
choose
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
866 reads
What would the following return?
create table #Employee
(
PositionId int,
Birthday datetime
)
insert into #Employee
select 0, '1995-01-01'
union all
select 1, '1983-08-01'
union all
select 2, '1948-07-31'
union all
select 3, '1932-02-29'
union all
select 4, '1980-06-15'
--Query 1
SELECT BirthMonth = CHOOSE(Month(Birthday), 'January', 'February',...
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
Oleg Kryzhanovsky
998
1007
Ten Centuries
2.
GilaMonster
423
38086
SSChampion
3.
Aadhar Joshi
409
1453
Ten Centuries
4.
Sean Lange
408
8967
SSCrazy Eights
5.
chihaia_ciprian
326
1079
Ten Centuries
Show more
Latest forum posts
layout question - how to get two tables to "span" the top ta...
By
SQLDCH
|
Jun 19, 2013
Posted to
Reporting Services 2005 Development
SQL CHOOSE
By
Revenant
|
Jun 19, 2013
Posted to
Discuss content posted by Bill Lantz
SQL Server Agent jobs running under SA
By
wolfkillj
|
Jun 19, 2013
Posted to
SQL Server 2008 Administration
How will work with(nolock) option in select queries
By
david.alcock
|
Jun 19, 2013
Posted to
SQL Server 2008 - General
Append characters in a sentence after certain length
By
Venkata-433090
|
Jun 19, 2013
Posted to
T-SQL (SS2K8)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
