15,576 reputation
44693
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 44
visits member for 3 years, 1 months
seen 5 hours ago

Apr
15
reviewed Leave Open Do I need to stop the service to back up the database?
Apr
15
comment Do I need to stop the service to back up the database?
@ShawnMelton Not necessarily. The question is not how to backup using each product, but whether stopping the services is required/sufficient to capture a consistent state using VSS. Whether this is advisable or not is certainly relevant, but interpreting the question as too broad does not necessarily make it so, IMO.
Apr
15
comment Location of #th iteration of a character or a word in a sql text field
@ZacG You're welcome. Is that solution suitable, or do you need another option? If so, please edit your question to provide additional detail.
Apr
14
reviewed Close How to increase application performance with Centralised SQL Server
Apr
14
reviewed Reviewed Postgresql not using GIN trigram index when performing non-ASCII LIKE query?
Apr
14
revised Inserting Serbian Latin and Cyrillic characters
Improved title, formatting, readability, tags
Apr
14
revised Display rows with no NULLs
Improved title and formatting
Apr
14
revised Listing indexes and constraints
Improved title, general readability, and formatting
Apr
14
answered Location of #th iteration of a character or a word in a sql text field
Apr
14
reviewed Leave Open Is it Ok to have one table with two relations?
Apr
14
reviewed No Action Needed A transport-level error has occurred when receiving results from the server. Semaphore timeout
Apr
14
reviewed Looks Good Display rows with no NULLs
Apr
14
answered Why do Indexed Views not permit non-unique clustered indexes?
Apr
14
answered Full text index search returns an unexpected result
Apr
14
reviewed No Action Needed How to create two same name databases in two different MySQL users?
Apr
14
reviewed No Action Needed Why does MySQL randomly display my databases?
Apr
14
reviewed Approve suggested edit on What's the best way to get data for sampling points within a timeframe
Apr
14
reviewed Leave Open PostgreSQL DB size increasing after restoring the same database backup
Apr
14
reviewed No Action Needed TSQL change column constraint between null and not null
Apr
14
reviewed Reject suggested edit on MYSQL 5.5 Fail start Fedora 16