SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Stairway Series Rss

   Items 1 to 20 of 365    Older >>
 

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?  Read more...
By Hugo Kornelis 2017/05/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 313 reads

Stairway to DAX and Power BI - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/05/03 (first published: 2014/09/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,055 reads

Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2017/04/21 (first published: 2015/04/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,871 reads

SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.   Read more...
By Phil Factor 2017/02/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 845 reads

Stairway to Server Management Objects (SMO) Level 3: The Database Class

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2017/02/01 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 950 reads

Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)

Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit.  Read more...
By Hugo Kornelis 2017/01/04 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 739 reads

Stairway to Biml Level 1: What is Biml?

An introduction to the Biml language from Andy Leonard that helps  Read more...
By Andy Leonard 2017/01/02 (first published: 2013/07/17) | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 38,090 reads

Level 3 - Building the Ideal VMware-based SQL Server Virtual Machine

In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware.  Read more...
By David Klee 2016/12/23 (first published: 2015/05/20) | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 9,512 reads

Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.  Read more...
By Phil Factor 2016/12/21 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 928 reads

Exploring Facts About SQL Server Tables: Stairway to Exploring Database Metadata Level 5

Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.  Read more...
By Phil Factor 2016/12/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,191 reads

Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)

In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.  Read more...
By Hugo Kornelis 2016/11/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,193 reads

Stairway to Biml Level 6 - Programming with Metadata

In this next level of the Stairway to Biml, learn how metadata makes your Biml code more efficient and helpful in generating packages.  Read more...
By Reeves Smith 2016/11/09 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 1,114 reads

Level 2 - The Ideal SQL Server Virtual Machine Architecture

In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.  Read more...
By David Klee 2016/10/14 (first published: 2015/05/13) | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 15,283 reads

Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.  Read more...
By Phil Factor 2016/09/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,576 reads

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2016/09/23 (first published: 2015/05/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,551 reads

Using SQL Server Dynamic Online Catalog to Solve Problems: Stairway to Exploring Database Metadata Level 2

In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.  Read more...
By Phil Factor 2016/09/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,256 reads

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.  Read more...
By Hugo Kornelis 2016/08/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,100 reads

Stairway to SQL Server Extended Events Level 4: Extended Events Engine - Essential Concepts

In this level, we're going to dig a little deeper into the Extended Events engine, its architecture, and fundamental components. It will give you a deeper understanding of why, in general, an Extended Events session is inherently lower in overhead than an equivalent SQL Trace. We'll also investigate how to design our event sessions to minimize any unnecessary overhead during event data collection, even when we need to create relatively complex event sessions to investigate difficult performance problems.  Read more...
By Erin Stellato 2016/08/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,094 reads

SQL Server Dynamic Online Catalog: Why Should You Care? Stairway to Exploring Database Metadata Level 1

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.  Read more...
By Phil Factor 2016/08/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,288 reads
   Items 1 to 20 of 365    Older >>
 
Tags
integration services (ssis) (23)    
t-sql (22)    
indexing (16)    
mdx (15)    
columnstore index (14)    
powershell (14)    
database design (13)    
sql trace (12)    
dax (11)    
replication (11)    
reporting services (ssrs) (11)    
sql server agent (11)    
xml (11)    
transaction log (10)    
advanced t-sql (9)    
powerpivot (9)    
sqlclr (9)    
data (8)    
pivottable (8)    
power bi (8)    
productx (8)    
metadata (7)    
biml (6)    
security (6)    
source control (6)    
extended events (5)    
streaminsight (5)    
u-sql (5)    
azure (4)    
big data (4)    
data lake (4)    
smo (4)    
sql dialects (4)    
virtualization (4)    
always on (3)    
complex event processing (3)    
ssas (3)    
continuous integration (ci) (2)    
cross join (2)    
dlm dashboard (2)    
dml (2)    
etl (2)    
failover clustered instance (fci) (2)    
insert (2)    
logging (2)    
math (2)    
optimization (2)    
schemas (2)    
server security (2)    
sql agent (2)    
test automation (2)    
test driven development (tdd) (2)    
.currentmember (1)    
.nextmember (1)    
.prevmember (1)    
administration (1)    
agent jobs (1)    
algorithmic trading (1)    
apply (1)    
auditing (1)    
authentication (1)    
batch mode (1)    
bi (1)    
books (1)    
bulk logged (1)    
business intelligence (1)    
case expression (1)    
catalog views (1)    
centralized repository (1)    
ci (1)    
closingperiod() (1)    
cluster (1)    
clustered index (1)    
code signing (1)    
common table expressions (cte) (1)    
continuous delivery (1)    
correlated subqueries (1)    
count() (1)    
countx() (1)    
cross-database ownership chaining (1)    
cube (1)    
cursors (1)    
data encryption (1)    
date (1)    
ddl (1)    
delete rows (1)    
derivative shortcut functions (1)    
diagnostics (1)    
distributed repository (1)    
dvcs (1)    
dynamic data masking (1)    
dynamic t-sql code (1)    
event driven architecture (1)    
event stream processing (1)    
excel (1)    
execution context (1)    
format_string (1)    
functions (1)    
grouping sets (1)    
head() (1)    
high availability (ha) (1)    
history (1)    
hyper-v (1)    
iif (transact-sql) (1)    
join (1)    
lastperiods() (1)    
log growth (1)    
log throughput (1)    
maintenance (1)    
max() (1)    
maxx() (1)    
mdx time/date series functions (1)    
merge (1)    
metdata (1)    
monitoring (1)    
mysql (1)    
nonclustered index (1)    
objects (1)    
openingperiod() (1)    
order by (1)    
ordering (1)    
parallelperiod() (1)    
periodstodate() (1)    
permissions (1)    
pivot (1)    
power pivot (1)    
ranking functions (1)    
relational (1)    
rollup (1)    
row-level security (rls) (1)    
select (1)    
server monitoring (1)    
server side trace (1)    
set functions (1)    
sql server 2008 r2 (1)    
sql server security (1)    
subqueries (1)    
sum() (1)    
sumx() (1)    
svn (1)    
tail() function (1)    
temp tables (1)    
test-driven development (1)    
time (1)    
t-log (1)    
top (1)    
transparent data encryption (tde) (1)    
twitter (1)    
unpivot (1)    
update (1)    
upgrading (1)    
views (1)    
visual studio (1)    
wsfc (1)