Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Development Rss

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

Database defintion from an Excel Spec?

Have you ever been required to create a database with nothing but a specification in Excel?  Read more...
By Ian Hadlington 2009/11/12 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 7,308 reads

Execute SQL Scripts in paralel for real performance tests

Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.  Read more...
By Gustavo Maia 2009/09/30 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 1,933 reads

Guide to MCITP: SQL Server 2008 Developer

An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.  Read more...
By Mike McQuillan 2009/08/21 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 10,175 reads

Agile Practices Meet Database Development: Intro

I think the database developer role is on the rise and that it's better suited for agile practices - but guidance...  Read more...
By Bill Nicolich 2009/08/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,855 reads

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.  Read more...
By Jesse Roberge 2009/07/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 1,245 reads

SQL Server XML Schemas

When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. Jacob Sebastian's book explains all.  Read more...
By Jacob Sebastian 2009/02/10 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 5,114 reads

Guest Editorial: That ain't a Database, it's a Spreadsheet

Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.  Read more...
By Phil Factor 2008/12/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 418 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,171 reads

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,133 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,626 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,022 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,689 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,368 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 | 894 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 | 461 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,539 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 | 931 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 | 277 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,862 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,483 reads
<< Newer    Items 21 to 40 of 252    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)    
.net (4)    
programming (4)    
sql server 7 (4)    
security (3)    
stored procedures (3)    
2-dimensional arrays (2)    
data warehousing (2)    
deployment (2)    
editorial (2)    
sql server 2008 (2)    
strategies (2)    
table (2)    
agile (1)    
auditing (1)    
automation (1)    
blogs (1)    
books (1)    
c# (1)    
certifications (1)    
crystal clear (1)    
customer service (1)    
data mining (1)    
data modeling (1)    
database (1)    
database design (1)    
database weekly (1)    
datatypes (1)    
ddl_events (1)    
dependencies (1)    
design and theory (1)    
designing database solutions (1)    
developer (1)    
eventnotification (1)    
events (1)    
exams (1)    
excel (1)    
integration services (ssis) (1)    
internals (1)    
maintenance (1)    
mcitp (1)    
mcts (1)    
names (1)    
naming (1)    
notifications (1)    
palalelism (1)    
prime (1)    
prime number (1)    
replication (1)    
schemas (1)    
scrum (1)    
sieve (1)    
sql server (1)    
sql server 2008 r2 (1)    
sql server 2016 (1)    
sqlservercentral (1)    
staging (1)    
storage (1)    
stress test (1)    
studying (1)    
transaction log (1)    
triggers (1)    
truncate table (1)    
utility (1)    
xml (1)    
xsl (1)