Glenn Berry's scripts[/url] are often a useful starting point for this type of analysis.

When I first saw this type of usage I thought...

dwain.c (4/21/2015)

---

WITH Alphas AS

(

SELECT a

FROM (VALUES('A'),('B'),('C'),('D')) a (a) -- use 22 letters

),

Numbers AS

(

SELECT...

Wayne West (4/17/2015)

---

It's in Alpha testing right now and will release next year on...

Your table contains at least one row with either:

i) a non-digit after the first character in that column, or

ii) a column length less than 10.

If the second case, try...

The (very small) fly in the ointment is that the 114 date style code in the CONVERT function returns milliseconds preceded by a colon rather than a period (decimal point).

That's...

Michael Meierruth (5/28/2013)

---

Steven Willis (5/26/2013)

---

I'm late to this party, but here's my entirely TSQL offering to remove duplicate spaces. Most of the code below has been not so shamelessly borrowed...

Solomon Rutzky (9/4/2014)

---

Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of the space...

Thanks Grant, Gail

Unfortunately we're stuck on 2008 SP3 (not R2) so that trace flag (2371?) isn't available.

I think I'll have to schedule some UPDATE STATISTICS alongside our regular index reorg.

All...

There are ways to create or update a view without disturbing an existing version, but they involve using dynamic SQL to a greater or lesser extent.

If you're comfortable with that...

ALTER VIEW and CREATE VIEW need to be the first/only statements in a batch, so the IF..ELSE construct won't work here.

The usual way to do this is to drop the...

It's even safer to use "<> 0".

If @ConfigValue is a smallint, then when channel 15 is enabled the masked value of 0x8000 will be interpreted as a negative value.

If databases are being regularly dropped and restored, won't readcommitted access to their sys.filegroups view be blocked during those operations?

I'm sure your Profiler trace shows that queries on most databases...

I got bitten by the same problem a while ago, see MS Connect

It's nothing to do with cached temporary tables, just a "feature" of the way the query optimizer works.

The...

Google the (undocumented :ermm:) extended stored procedure xp_dirtree - Patrick Keisler has a useful blog post.