Viewing 15 posts - 1,351 through 1,365 (of 3,348 total)
mshparber (5/5/2015)
I am still missing something...
It my user whant to see a crosstab report of NetPrice Amount by Month by Product - how the Columnstore index...
May 7, 2015 at 3:01 am
henrik staun poulsen (5/5/2015)
So is this what is needed?ALTER TABLE dbo.Test ADD CONSTRAINT CK_Test_EndDateAfterStartDateAndNotNull CHECK (EndDate > StartDate AND EndDate IS NOT NULL);
GO
No, if you don't want null values, you...
May 7, 2015 at 2:52 am
Vijay.Govindan (4/30/2015)
You are welcome! Yes, I forgot about that, being read only limits its use in a Datawarehouse / ETL environment in our case. Thanks for the link, I...
April 30, 2015 at 4:09 pm
Vijay.Govindan (4/30/2015)
Thanks for the article pointing out the savings related to I/O and Batch mode. Have you done any tests on Updates / Deletes/ Inserts with and without a...
April 30, 2015 at 3:05 pm
Stewart "Arturius" Campbell (4/30/2015)
Interesting question, thanks...Now i'm wondering why this might be required, given the temporary nature of objects in tempdb...:-P
I am convinced that it will never be required.
When I...
April 30, 2015 at 5:49 am
Carlo Romagnano (4/29/2015)
Toreador (4/29/2015)
Only 54% correct? I was expecting close to 100%!It depends if one has enough time to read correctly the question of th day.
Yup! I *almost* answered wrong...
April 29, 2015 at 11:58 am
Eirikur Eiriksson (4/27/2015)
April 27, 2015 at 3:02 am
palotaiarpad (4/26/2015)
Hmm. According to BOL, if OVER used with a SUM, then an order by clause is required...
As others already said, BOL is wrong.
OVER() with normal aggregate functions (like SUM)...
April 27, 2015 at 2:55 am
Carlo Romagnano (4/22/2015)
Good question!I do not like "Filtered indexes", they are too much limited. I prefer indexed view.
They are different tools for different purposes. You should use each where appropriate.
Koen...
April 23, 2015 at 2:05 am
PHYData DBA (4/21/2015)
Did you read through all the posts here?
Did you read...
April 21, 2015 at 1:44 pm
PHYData DBA (4/21/2015)
Hugo Kornelis (4/21/2015)
quote]
As I said... Of your own...
April 21, 2015 at 8:51 am
PHYData DBA (4/21/2015)
Hugo Kornelis (4/21/2015)
PHYData DBA (4/21/2015)
Hugo Kornelis (4/21/2015)
This can be "fixed" by...
April 21, 2015 at 8:02 am
Ed Wagner (4/21/2015)
What if your code ran too fast and you wanted to slow it down? Between the pivot and the rcte, that should do the trick. 😛
XPath is...
April 21, 2015 at 7:49 am
PHYData DBA (4/21/2015)
Hugo Kornelis (4/21/2015)
This can be "fixed" by first storing the results...
April 21, 2015 at 7:47 am
I don't like the script, and I like the advice to use WHILE instead of CURSOR even less.
My take on this:
1. Set-based is (almost) always faster than iterative. Avoid both...
April 21, 2015 at 1:48 am
Viewing 15 posts - 1,351 through 1,365 (of 3,348 total)