Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Content with tag SQL Rss

   Items 1 to 11 of 11   
 

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2013/05/08 | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 13,822 reads

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: sql
Rating: |  Discuss |   Briefcase | 2,863 reads

Manipulate Horizontal Hierarchy with UNPIVOT

Convert Horizontal Hierarchy to vertical Hierarchy.  Read more...
By Bernabe Diaz 2012/12/20 | Source: SQLServerCentral.com | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 729 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...
By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,232 reads

Routine Dependency Visualizer

This article contains a T-SQL script that can show you the dependency of all objects in your SQL Server database.  Read more...
By Angel Rapallo 2012/10/30 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 3,872 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: sql
Rating: |  Discuss |   Briefcase | 6,786 reads

Script to get an ordered list of all stored procedures with parameters

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.  Read more...
By Derek Colley 2012/08/14 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,873 reads

Delete old backup

Delete old backup files on a prespecified folder.   Read more...
By Matimba Maluleke 2012/07/03 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,068 reads

Change Tracking - 2008

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.  Read more...
By Nitesh Dedhia 2012/06/18 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 7,038 reads

10 tips on converting MS SQL queries to MySQL

The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.   Read more...
By Oleg Fedorov 2012/06/01 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 4,991 reads

How to query dBase .dbf from SQL 2012 64-bit

Query dBase .dbf Files From SQL 2012 64-bit.  Read more...
By James Ochsenfeld 2012/05/09 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 753 reads
   Items 1 to 11 of 11   
 
Tags
excel (2)    
reporting services (ssrs) (2)    
ace (1)    
advantage (1)    
affinity (1)    
assembly (1)    
automation (1)    
backup / restore (1)    
change tracking (1)    
clr (1)    
cpu (1)    
create index (1)    
data dictionary (1)    
data warehouse (1)    
dbase (1)    
dependency (1)    
fox (1)    
graphs (1)    
indexing (1)    
internals (1)    
list (1)    
map (1)    
monitoring (1)    
mysql (1)    
new feature of sql server 2008 (1)    
nitesh dedhia (1)    
parameter (1)    
pdf (1)    
performance tuning (1)    
pro (1)    
render (1)    
routine (1)    
schedulers (1)    
scripting (1)    
search (1)    
sp_sproc_columns (1)    
sql server (1)    
sql server 2008 (1)    
sqlclr (1)    
stored procedure (1)    
stream (1)    
sybase (1)    
syntax (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
udf (1)    
visualizer (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.