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

Content with tag Development Rss

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

Column Size Checker

A T-SQL script that reveals how appropriate your choice of column sizes is.  Read more...
By Richard Doering 2010/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,326 reads

Decoupling the Database

Database refactoring is a difficult proposition at the best of times, but is rendered more or less impossible if the database is close-coupled to the application's other components. In a guest editorial, Mladen Prajdic stresses the importance of a native SQL Server abstraction layer.  Read more...
By MladenPrajdic 2010/11/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 320 reads

Column Size Checker

A T-SQL script that reveals how appropriate your choice of column sizes is.  Read more...
By Richard Doering 2010/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,326 reads

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,936 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 | 3,013 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,256 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,122 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,174 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,137 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,633 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,023 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,698 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,373 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 | 463 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,541 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
<< Newer    Items 21 to 40 of 255    Older >>
 
Tags
sql server 2005 (68)    
reporting services (ssrs) (46)    
t-sql (16)    
advanced querying (8)    
nums (8)    
sqlinsider scripts (8)    
table of numbers (8)    
tally (8)    
administration (7)    
counter (7)    
miscellaneous (6)    
arrays (5)    
delimited strings (5)    
parse (5)    
string manipulation (5)    
.net (4)    
programming (4)    
sql server 7 (4)    
data warehousing (3)    
deployment (3)    
security (3)    
stored procedures (3)    
2-dimensional arrays (2)    
database design (2)    
editorial (2)    
integration services (ssis) (2)    
sql server (2)    
sql server 2008 (2)    
sql server 2016 (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 weekly (1)    
datatypes (1)    
ddl_events (1)    
dependencies (1)    
design and theory (1)    
designing database solutions (1)    
developer (1)    
environment variables (1)    
eventnotification (1)    
events (1)    
exams (1)    
excel (1)    
internals (1)    
maintenance (1)    
mcitp (1)    
mcts (1)    
names (1)    
naming (1)    
notifications (1)    
other (1)    
package configuration (1)    
palalelism (1)    
parameterized connections (1)    
parameters (1)    
prime (1)    
prime number (1)    
project deployment model (1)    
provisioning (1)    
replication (1)    
schemas (1)    
scrum (1)    
sieve (1)    
sql clone (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server data tools (ssdt) (1)    
sqlservercentral (1)    
ssis catalog (1)    
staging (1)    
storage (1)    
stress test (1)    
studying (1)    
testing (1)    
transaction log (1)    
triggers (1)    
truncate table (1)    
utility (1)    
visual studio (1)    
xml (1)    
xsl (1)