Dwain Camps | SQLServerCentral

Dwain Camps

Forum Topics Started

Viewing 15 topics - 1 through 15 (of 38 total)

Topics

Posts

Last post
Calculating Elapsed Times (SQL Spackle)

11 replies

2 months ago

By: Jeff Moden
An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

46 replies

3 years, 11 months ago

By: Jeff Moden
Generating Non-uniform Random Numbers with SQL

32 replies

7 years, 4 months ago

By: Jeff Moden
Performance of the SQL MERGE vs. INSERT/UPDATE

53 replies

7 years, 9 months ago

By: N_Muller
Identify Bad Characters in a Table Column

6 replies

8 years, 6 months ago

By: akljfhnlaflkj
Copy Triggers from One DB to Another

1 replies

8 years, 6 months ago

By: akljfhnlaflkj
Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

38 replies

8 years, 8 months ago

By: akljfhnlaflkj
Logging and Error Handling for SQL Stored Procedures

28 replies

9 years, 2 months ago

By: akljfhnlaflkj
The Case for Scalar-valued, User-defined Functions in T-SQL

13 replies

9 years, 6 months ago

By: Sporidium
Splitting Strings Based on Patterns

52 replies

9 years, 7 months ago

By: Felix Pamittan
The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

19 replies

9 years, 7 months ago

By: Solomon Rutzky
A Hazard of Using the SQL Update Statement

56 replies

9 years, 7 months ago

By: Dwain Camps
How to Design, Build and Test a Dynamic Search Stored Procedure

45 replies

9 years, 7 months ago

By: Dwain Camps
Adding a Query Governor to Dynamic-Search Stored Procedures

14 replies

9 years, 7 months ago

By: fregatepllada
Identifying Start Dates not Aligned with End Dates on a Prior Row

13 replies

9 years, 8 months ago

By: Peter Heller

Viewing 15 topics - 1 through 15 (of 38 total)