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

Content with tag Development Rss

<< Newer    Items 21 to 40 of 244    Older >>
 

Delimited String Parsing Functions - Big2D set

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,080 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,596 reads

Delimited String Parsing Functions - 2D set

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,004 reads

Introduction to DML Triggers

This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.  Read more...
By Jack Corbett 2008/10/14 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 13,094 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,284 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 879 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 456 reads

Find Mismatched Views and Stored Procs

Find missing and mismatched views and stored procs between 2 Databases  Read more...
By Pratap Prabhu 2012/09/03 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 1,516 reads

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist  Read more...
By Wilfred van Dijk 2013/07/09 | Category: t-sql
Rating: |  Discuss |   Briefcase | 922 reads

usp_dependencytree

displays a graphical tree of dependencies of an object  Read more...
By Wilfred van Dijk 2008/06/25 | Source: SQLServerCentral.com | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 256 reads

Truncate All Tables

Script to Truncate all tables part1  Read more...
By Jorge Novo-@ETLDEVDBA 2011/06/02 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 7,643 reads

Recursive Queries in SQL Server 2005

Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.   Read more...
By Srinivas Sampath 2008/04/18 (first published: 2005/03/03) | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 92,353 reads

Dynamic Connection Strings in Reporting Services 2005

Reporting Services is one of the most popular features of SQL Server 2005 and there have been a tremendous number of enhancements to this subsystem. New author Bilal Khawaja brings us a look at dynamic connection strings and how you can have one report pulling data from different servers.   Read more...
By Bilal Khawaja 2007/05/03 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 19,039 reads

Reporting Services Makes Server Support Easier

Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers   Read more...
By Carolyn Richardson 2007/03/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,754 reads

Maximum Row Size in SQL Server 2005

What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.   Read more...
By Andy Warren 2007/02/27 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 24,946 reads

Data Driven Subscriptions for Reporting Services (2000 and 2005)

Reporting Services has proven to be one of the more useful subsystems of SQL Server. However the standard editions of both SQL Server 2000 and SQL Server 2005 have limitations with regard to the subscription features. Jason Selberg brings us an updated version of his code for extending the subscription feature.   Read more...
By Jason Selburg 2007/02/14 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 23,733 reads

Adding Custom Code To Reporting Services

Reporting Services has been greatly enhanced in SQL Server 2005 and become an integral tool in many SQL Server installations. Longtime autor Raj Vasant brings us an example of how you can enhance your reports with custom coded DLLs called from within the reporting engine.   Read more...
By Vasant Raj 2007/03/15 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 20,978 reads

Automatically generate SUID procs for any table

This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.  Read more...
By Cade Bryant 2008/01/02 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 1,218 reads

An Introduction to the Service Broker

One of the more interesting new features in SQL Server 2005 is the Service Broker. It's not something to help you manage your financial future, nor is it some new program that handles all the instances and their accounts. It's a message queue and SQL Server MVP Srinivas Sampath brings us a look at this new feature with some code to get you going.   Read more...
By Srinivas Sampath 2007/12/14 (first published: 2005/06/30) | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 31,190 reads

Source Control in SQL Server

One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.   Read more...
By Vasant Raj 2006/12/04 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 13,745 reads
<< Newer    Items 21 to 40 of 244    Older >>
 
Tags
sql server 2005 (68)    
reporting services (ssrs) (46)    
t-sql (15)    
advanced querying (8)    
nums (8)    
sqlinsider scripts (8)    
table of numbers (8)    
tally (8)    
administration (7)    
counter (7)    
arrays (5)    
delimited strings (5)    
miscellaneous (5)    
parse (5)    
string manipulation (5)    
programming (4)    
sql server 7 (4)    
.net (3)    
stored procedures (3)    
2-dimensional arrays (2)    
data warehousing (2)    
editorial (2)    
security (2)    
sql server 2008 (2)    
strategies (2)    
table (2)    
agile (1)    
audit (1)    
automation (1)    
blogs (1)    
books (1)    
c# (1)    
certifications (1)    
crystal clear (1)    
data mining (1)    
database weekly (1)    
ddl_events (1)    
dependencies (1)    
deployment (1)    
design and theory (1)    
designing database solutions (1)    
developer (1)    
eventnotification (1)    
events (1)    
exams (1)    
excel (1)    
integration services (ssis) (1)    
maintenance (1)    
mcitp (1)    
mcts (1)    
notifications (1)    
palalelism (1)    
prime (1)    
prime number (1)    
schemas (1)    
scrum (1)    
sieve (1)    
sql server (1)    
sql server 2008 r2 (1)    
sqlservercentral (1)    
staging (1)    
stress test (1)    
studying (1)    
triggers (1)    
truncate table (1)    
utility (1)    
xml (1)    
xsl (1)