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

Content with tags T-SQL, Excel Rss

   Items 1 to 5 of 5   

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...
By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,779 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,477 reads

Set Up Grouping Intervals for Excel (SQL Spackle)

So you want to group your data for charting in Excel? Here's how, the easy way!  Read more...
By Dwain Camps 2012/07/31 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,248 reads

Import Excel Spreadsheet to Database Tables

Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.  Read more...
Rating: |  Discuss |   Briefcase | 17,783 reads

Use Excel to DIFF Your Query Outputs

Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.  Read more...
By David Ziffer 2008/12/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,322 reads
   Items 1 to 5 of 5   
reporting services (ssrs) (2)    
affinity (1)    
cpu (1)    
data warehouse (1)    
etl (extract, transform, and load) (1)    
graphs (1)    
histogram chart (1)    
internals (1)    
monitoring (1)    
performance tuning (1)    
schedulers (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)