<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:
(not yet rated)
|
Discuss
|
Briefcase
|
815 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
|
87 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
|
367 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
|
10,555 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,548 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,289 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,524 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
|
1,987 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,542 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,483 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
|
412 reads
Browse all
Question of the Day
SQL CHOOSE
By
Bill Lantz
2013/06/19
|
Category:
choose
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
346 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
1005
1006
Ten Centuries
2.
GilaMonster
416
38074
SSChampion
3.
Sean Lange
410
8957
SSCrazy Eights
4.
Aadhar Joshi
409
1453
Ten Centuries
5.
chihaia_ciprian
365
1079
Ten Centuries
Show more
Latest forum posts
How To return Year & Month in this format: 2013-06
By
Teee
|
Jun 19, 2013
Posted to
T-SQL (SS2K8)
Grouping Related Rows in Same Table
By
tssopa
|
Jun 19, 2013
Posted to
SQL Server 2012 - T-SQL
Leave
By
immaduddinahmed
|
Jun 19, 2013
Posted to
SQL Server 2008 - General
What is Windows System Commands in SQL Server?
By
Beatrix Kiddo
|
Jun 19, 2013
Posted to
SQL Server Newbies
Database Engine becomes unresponsive
By
Denesh Naidoo
|
Jun 19, 2013
Posted to
Administering
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
