SQLServerCentral: Content tagged Miscellaneous, T-SQL, SQL Server 2005

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm. Read more...

By Kevin Duan 2011/12/21 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 3,420 reads

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005. Read more...

By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 2,736 reads

BCP Format File Builder

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files. Read more...

By Paul Hunter 2009/08/14 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 1,982 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,177 reads

Yet Another Deleting Duplicate Records (in-place)

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column. Read more...

By Peter Petrov 2009/01/15 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 1,818 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 2013/06/19 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 865 reads

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005. Read more...

By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 2,736 reads

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm. Read more...

By Kevin Duan 2011/12/21 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 3,420 reads

Partitioning - Part 2

Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques. Read more...

By Andy Warren 2007/10/08 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 8,582 reads

Fixing SysDepends

Have you been burned by sysdepends at some point in your SQL Server DBA career? Steve Jones has many times, but a FREE new utility ends all that. Read more...

By Steve Jones 2005/09/22 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 9,636 reads

Content with tags Miscellaneous, T-SQL, SQL Server 2005