Viewing 15 posts - 526 through 540 (of 2,458 total)
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...
-- Itzik Ben-Gan 2001
August 18, 2016 at 2:13 pm
... 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 +...
-- Itzik Ben-Gan 2001
August 18, 2016 at 11:57 am
The NGRAMS tool you wrote is very cool. Don't blame you a bit. 🙂
😀
-- Itzik Ben-Gan 2001
August 18, 2016 at 11:32 am
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...
-- Itzik Ben-Gan 2001
August 17, 2016 at 2:49 pm
Jeff Moden (8/17/2016)
-- Itzik Ben-Gan 2001
August 17, 2016 at 2:21 pm
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...
-- Itzik Ben-Gan 2001
August 17, 2016 at 11:54 am
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,...
-- Itzik Ben-Gan 2001
August 17, 2016 at 11:43 am
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...
-- Itzik Ben-Gan 2001
August 17, 2016 at 11:11 am
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
-- Itzik Ben-Gan 2001
August 16, 2016 at 7:14 am
vsamantha35 (8/15/2016)
-- Itzik Ben-Gan 2001
August 16, 2016 at 7:06 am
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...
-- Itzik Ben-Gan 2001
August 12, 2016 at 11:59 am
nsadams87xx (8/12/2016)
So it really should only be used with columns that are not updated very often, have large amounts of data, and those columns are often used together?
Adding to what...
-- Itzik Ben-Gan 2001
August 12, 2016 at 10:46 am
HappyGeek (8/11/2016)
Iwas Bornready (7/25/2016)
Yet Another DBA (7/22/2016)
Time to leave?Hmm, with some companies its the day after I started.
That's sad you didn't know that before you started.
So how exactly do you...
-- Itzik Ben-Gan 2001
August 12, 2016 at 10:35 am
shambhavi13 (8/11/2016)
Have one another question in mind .. what if I want to search more than one one word in a single document but in...
-- Itzik Ben-Gan 2001
August 12, 2016 at 9:10 am
Suth (8/12/2016)
I currently need to make a number of schema changes to a database that is set up for replication (Transactional) the schema changes...
-- Itzik Ben-Gan 2001
August 12, 2016 at 8:01 am
Viewing 15 posts - 526 through 540 (of 2,458 total)