Viewing 15 posts - 5,956 through 5,970 (of 8,416 total)
If Jeff's comment doesn't resolve all your problems, please do post the sample data, as I am still keen to take a look at this.
Paul
February 21, 2010 at 10:20 pm
RBarryYoung (2/21/2010)
vaibhav.tiwari (2/20/2010)
I want to get the best example of group by with cube rollupto understand as i m very confused between two ot them
What do you mean by "best"?...
February 21, 2010 at 10:09 pm
RBarryYoung (2/21/2010)
You could'nt find one here? Sure the CLR solutions are generally faster, but some of the SQL solutions are pretty good too.
That's the super-long thread that prompted both...
February 21, 2010 at 10:07 pm
I do love a happy ending 😀
And yes, ANSI_NULLS OFF is entirely evil and must die.
Paul
February 21, 2010 at 10:03 pm
Jeff Moden (2/21/2010)
Speaking of killing things... I can't believe that anyone would put a default on a password column unless it's meant to daze and confuse. 😉
The original posted...
February 21, 2010 at 9:53 pm
The reason I asked for details was because the best solution often depends on the details.
All you've done really is ask me to trust you, and that there really is...
February 21, 2010 at 9:45 pm
mbender (2/21/2010)
Yes we would need to assign a pkey, it would not be PartNumber or location because those are not always unique.
Sigh. My suggestion was for a compound primary...
February 21, 2010 at 9:39 pm
Performing the data conversion before it hits the database at all is still cleaner and more efficient in my view.
As far as existing data is concerned, bulk copy out, convert,...
February 21, 2010 at 9:37 pm
lmu92 (2/21/2010)
When using DATEPART(WEEKDAY, AsofDate) you need to make sure to have DATEFIRST set to 7. Otherwise you'll get incorrect results.
Lutz,
You sure about that?
Monday is the first day of the...
February 21, 2010 at 9:35 pm
Barry,
How would reversing the statements work? An INSERT might throw an exception if a key value already exists. Wrapping it in TRY...CATCH would work, but you still have...
February 21, 2010 at 9:31 pm
Let me know if you have any trouble understanding and aspect of it.
The key point is probably to appreciate the APPLY just calls a table-valued function for every row of...
February 21, 2010 at 9:20 pm
gail_liberty (2/21/2010)
February 21, 2010 at 9:18 pm
Barry,
I'm not sure about that equation! Where do I place waits due to a lack of an available scheduler? Where do waits on memory access appear?
For my...
February 21, 2010 at 9:13 pm
bhushanvinay (2/21/2010)
https://connect.microsoft.com/SQLServer/feedback/details/531260/datapage-difference-in-2005-vs-2008
That seems to be a connect item trying to report a display anomaly in the undocumented and unsupported DBCC PAGE command.
It doesn't show data corruption at all...?!
February 21, 2010 at 8:16 pm
Matt Miller (#4) (2/15/2010)
NULL is not a value, so as such, NULL is neither equal nor not equal to any value.
So, let me try again :w00t:
This above quoted statement is...
February 21, 2010 at 8:07 pm
Viewing 15 posts - 5,956 through 5,970 (of 8,416 total)