Viewing 15 posts - 8,611 through 8,625 (of 26,490 total)
So what is happening on the server? have you checked the SQL Server and Windows log files?
March 6, 2013 at 11:53 am
Post the code for the function(s) used as well. They can be part of the problem.
March 6, 2013 at 11:41 am
Can you provide the complete and uneditted error message?
March 6, 2013 at 9:27 am
What more do you want? If you think it is a bug report it on Connect.
March 6, 2013 at 7:24 am
Gail beat me to that one. Oh well.
March 6, 2013 at 7:23 am
Here is one link: http://msdn.microsoft.com/en-us/library/dd894051(v=SQL.100).aspx.
March 6, 2013 at 7:22 am
abhisheksharmacnn (3/6/2013)
Error/Warning Message is :-
Warning! The maximum key length is 900 bytes. The index 'IDX_TERMX' has maximum length of 8000 bytes. For...
March 6, 2013 at 7:04 am
Steve Malley (3/6/2013)
I should have mentioned in my initial post that I was speaking of a Primary Key *Clustered* constraint. This creates a corresponding index.
And that index is the data...
March 6, 2013 at 6:57 am
winmansoft (3/5/2013)
I can't change the datatype from datetime to date.So is there any method like cast or anything?
Then think of this like the datetime data type in SQL. You...
March 6, 2013 at 4:41 am
dwain.c (3/5/2013)
Lynn Pettis (3/5/2013)
You know Dwain, now if we could just get you to use the semicolon as a terminator instead of a begininator! 😛
Lynn - I'm 100% with...
March 5, 2013 at 9:04 pm
Save your actual execution plan as a .sqlplan file and upload that to this thread. Sorry, but I don't know what you are talking about and I don't have...
March 5, 2013 at 8:44 pm
itlk (3/5/2013)
I see. I thought that the rank is calculated based on column(s) in a partition and not in the 'order by' clause.Thank you for help.
I think you are...
March 5, 2013 at 8:31 pm
DDL for the table(s), sample data for the table(s), expected results based on the sample data.
Sorry, I know I'm good, but I can't see what you see so I have...
March 5, 2013 at 8:26 pm
dwain.c (3/5/2013)
Steven Willis (3/5/2013)
SELECT
...
March 5, 2013 at 8:24 pm
Viewing 15 posts - 8,611 through 8,625 (of 26,490 total)