Viewing 15 posts - 451 through 465 (of 1,354 total)
That isn't actually what you *said*, though? You said that a (well written) cursor will never, ever beat a WHILE loop, which implies the WHILE is faster?
We all need...
September 12, 2016 at 8:17 am
Added a cursor just the other week when a recursive CTE used in a cross apply was causing a query to take over the .NET default 30 second timeout -...
September 12, 2016 at 6:54 am
Seemed easy, but being incorrect really does teach you more sometimes...
September 9, 2016 at 7:46 am
I agree with most of the points, even those that seem to contradict. NULL is not a value, it is the absence of information. With regards to the...
September 7, 2016 at 7:48 am
I reject entirely the notion that there is such a thing as a "default" clustering key.
The numbers of times I've advocated this kind of thing, and people just look at...
September 6, 2016 at 10:57 am
Except that MS SQL Server adds a uniqueifier to the index of a clustered index if the index is not unique.
This can't be a showstopper, can it? This...
September 6, 2016 at 9:21 am
Daylight Savings, presumably? EDT is UTC - 4.
That could be the answer, which means SQL is smart enough to know when to apply daylight savings. The question does...
September 6, 2016 at 7:54 am
What could have thrown me was that I though ET was 5 hours off GMT. ET is five hours behind time in England and 6 in central Europe. ...
September 6, 2016 at 7:41 am
If there is a valid natural key present, use it. As an extreme example, tables that have an ID, state code, and state name, when state code and state...
September 5, 2016 at 6:31 pm
But, you say, I'd know which services were using that account, so it shouldn't matter, right?
Actually, I wouldn't have said that. I agree that is a downside to...
August 29, 2016 at 1:26 pm
RonKyle (8/29/2016)
Don't the service accounts make this issue moot? I think they came about in 2012. I've used them in a couple of SQL 2014 setups now. They don't need...
August 29, 2016 at 12:57 pm
Don't the service accounts make this issue moot? I think they came about in 2012. I've used them in a couple of SQL 2014 setups now. They...
August 29, 2016 at 7:38 am
Well, reporting only on what is used is the same as using independent dimensions again.
No, it's not. Chances are independent dimensions when the items would be an attribute of...
August 25, 2016 at 6:10 am
even tho it will double the rows to load
We can provide general guidelines, but you're the one with the data, so you have to make some judgements. You...
August 25, 2016 at 5:36 am
These members should not form their own dimension.
Seconded. Do not go down that route. The size, and lack of size, is an attribute of the product, not the...
August 24, 2016 at 12:27 pm
Viewing 15 posts - 451 through 465 (of 1,354 total)