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

Regular Columnist: Jacob Sebastian

SQLServerCentral.com profile

   Items 1 to 20 of 95    Older >>
 

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.  Read more...
By Jacob Sebastian, Sven Aelterman 2012/11/12 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 320 reads

TSQL Challenge 83 - Compare rows in the same table and group the data

The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.   Read more...
By Jacob Sebastian 2012/10/08 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,577 reads

TSQL Challenge 82 - Find elements that uniquely make up a group

The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.   Read more...
By Jacob Sebastian 2012/09/17 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,180 reads

TSQL Challenge 81 - Create a Game schedule generator in TSQL

This challenge is to generate a game scheduler based on the Teams given in a table.   Read more...
By Jacob Sebastian 2012/07/04 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,391 reads

TSQL Challenge 80 - Find the minimal set of intervals without gaps

The challenge is to find the minimal set of intervals without creating gaps.  Read more...
By Jacob Sebastian 2012/04/16 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,462 reads

TSQL Challenge 79 - Finding the Islands

The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.   Read more...
By Jacob Sebastian 2012/04/02 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 704 reads

TSQL Challenge 78 - Parse single field into multiple fields

The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.   Read more...
By Jacob Sebastian 2012/03/19 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 2,478 reads

TSQL Challenge 77-Transform monthly resource efforts to weekly actuals

The challenge is to transform monthly resource efforts into weekly actuals.  Read more...
By Jacob Sebastian 2012/03/05 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 672 reads

TSQL Challenge 76 - Identify the sequence of accounting transactions

The challenge is to identify the sequence of accounting transactions.   Read more...
By Jacob Sebastian 2012/02/20 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,570 reads

TSQL Challenge 75 - Find the Episode and Sequence based on interval

The challenge is to find the Episode and Sequence based on interval.   Read more...
By Jacob Sebastian 2012/02/06 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,233 reads

TSQL Challenge 74 - Find the expiring quantity of material

The challenge is to create a query for a report that show expiring material  Read more...
By Jacob Sebastian 2012/01/23 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 874 reads

TSQL Challenge 72 - Calculate the Payroll Hours of Employees

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.  Read more...
By Jacob Sebastian 2011/12/26 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,649 reads

TSQL Challenge 71 - Play mangled words game in TSQL

Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.  Read more...
By Jacob Sebastian 2011/12/12 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,354 reads

TSQL Challenge 70 - Find the longest sequence of alphabets in a string

This challenge invites you to identify the longest sequence of alphabets from a string.  Read more...
By Jacob Sebastian 2011/11/28 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 937 reads

TSQL Challenge 69 - Find the most relevant advertisement based on keyw

Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.  Read more...
By Jacob Sebastian 2011/11/14 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 577 reads

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers

This challenge invites you to Generate kaprekar kernel or series from numbers.  Read more...
By Jacob Sebastian 2011/10/31 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 854 reads

TSQL Challenge 67 - Find the longest sequence of alphabets in a string

This challenge invites you to identify the largest sequence of alphabets from a string.  Read more...
By Jacob Sebastian 2011/10/17 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 894 reads

TSQL Challenge 66 - Find the most relevant advertisement based on keyw

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.   Read more...
By Jacob Sebastian 2011/10/03 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 541 reads

TSQL Challenge 65 - Solving the Running Total Problem

This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.  Read more...
By Jacob Sebastian 2011/09/19 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,594 reads

TSQL Challenge 64 - A Payroll calculation Challenge

This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays  Read more...
By Jacob Sebastian 2011/09/05 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 1,297 reads
   Items 1 to 20 of 95    Older >>