My question is would it be better to create a Stage and House for each customer instead of the single method we are doing now? Some of our fact tables...

... and if we're talking about always doing 3 years behind/ahead of the current year you could even do this:

WITH currentYear AS (SELECT yr = YEAR(getdate()))

SELECT yr = yr +...

😀

The confusing thing about clustered indexes and primary keys is how, by default, SQL server uses the PK columns as the keys for the clustered index when you create a...

Jeff Moden (8/17/2016)

---

Just an opinion... you just about can't beat a Nested Replace, like what Scott wrote, for something like this. I say "just about" only because I don't...

Here's a good article by Gail Shaw that discusses Recovery Model internals and has some really good links about what's going on under the hood (if that's what you're looking...

A couple other ways:

1. Use NGrams8K[/url] like so:

DECLARE @price decimal(12,2) = 12345678.90;

SELECT NewPrice =

(

SELECT CASE WHEN token LIKE '[0-9]' THEN CHAR(ASCII(token)+17) ELSE token END

FROM dbo.NGrams8k(@price,...

It's likely that both versions will produce the same execution plan. I would probably go without the CTE because the first query is less complicated. That said, it may be...

This is a classic gaps/islands problem. Have a look at this article:

https://www.simple-talk.com/sql/t-sql-programming/the-sql-of-gaps-and-islands-in-sequences/%5B/url%5D

vsamantha35 (8/15/2016)

---

Is there a way using dmvs / trace to get know the the timeout set for a query? I can ask the application team but I am curious to...

That's a mighty big font you got there.

A complete solution will take some time but here's a couple techniques to break your input string into a seperate row for...

Adding to what...

HappyGeek (8/11/2016)

---

So how exactly do you...

shambhavi13 (8/11/2016)

---

Thank you so much .

Have one another question in mind .. what if I want to search more than one one word in a single document but in...

Suth (8/12/2016)

---

Hi,

I currently need to make a number of schema changes to a database that is set up for replication (Transactional) the schema changes...