Mark Dalley | SQLServerCentral

Mark Dalley

Forum Topics Started

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

Topics

Posts

Last post
Deduplicating rows by choosing the row with the shortest string

8 replies

3 weeks, 1 day ago

By: Eirikur Eiriksson
Applying COLLATION Clause to string expressions

2 replies

2 years, 2 months ago

By: Mark Dalley
Behaviour of SSMS when scripting SPs has suddenly changed

2 replies

2 years, 9 months ago

By: Michael L John
Attempted foreign key constraint creation involving multiple fields fails

7 replies

2 years, 9 months ago

By: Mark Dalley
Pulling stats for multiple columns out of a table efficiently

3 replies

3 years, 11 months ago

By: Mark Dalley
Debug SSIS import from Excel to SQL Server

16 replies

4 years, 4 months ago

By: Mark Dalley
How do I post a table as part of a forum question?

8 replies

4 years, 5 months ago

By: Mark Dalley
Find out the number of records in all those tables where a given field appears

5 replies

7 years, 2 months ago

By: Mark Dalley
Semantics of simple-seeming UPDATE statement with FROM clause

17 replies

7 years, 10 months ago

By: Mark Dalley
Can it help to index a field that is part of a multi-field primary key?

5 replies

8 years, 1 month ago

By: Mark Dalley
BULK INSERT seems not to recognise line terminators

14 replies

8 years, 7 months ago

By: Luis Cazares
Selecting the record with the “nearest” date

19 replies

8 years, 12 months ago

By: Kim Crosser
Interaction between the DB size, DB log size, tempdb size and tempdb log size

8 replies

9 years, 5 months ago

By: Jeff Moden
Renumbering the remaining records in a table after some recs have been deleted

5 replies

10 years ago

By: Andrew Kernodle
Are embedded spaces ever valid in non-delimited names?

4 replies

10 years, 3 months ago

By: Mark Dalley

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