Viewing 15 posts - 556 through 570 (of 698 total)
Ah, definately true regarding the CTE not working for the INSERT ... hadn't considered that. That's annoying, because I'm told you're not supposed to use temp tables in triggers. Well,...
November 24, 2009 at 8:24 am
rajaneeshk (11/20/2009)
Now is that confirmed....May i know what the answer is...???
If it is 3.... then atleast say thanks na.... 🙂
The answer is 1 - there is only one record which...
November 20, 2009 at 9:29 am
Interesting. When I ran a REBUILD from the prompt, it worked. Before, I had done it from the properties tab, and it hadn't. Strange. Well, I suppose that answers my...
November 16, 2009 at 12:57 pm
I don't think auto shrink is on, how can I find out though?
As for the information, I'm not sure how to post it here in a readable fashion, so I'm...
November 16, 2009 at 9:37 am
Hm. Well, I just did a rebuild on it, and the fragmentation remains at 99% from the query. Any other ideas?
November 16, 2009 at 9:18 am
Alrighty, in that case, how about this one?
index_type_descindex_levelavg_fragmentation_in_percentfragment_countavg_fragment_size_in_pagespage_count
CLUSTERED INDEX099.250381832350531235053
This thing was done using the LIMITED option, and it does seem to indicate the level 0 leaf node fragmentation, saying it...
November 16, 2009 at 9:00 am
I take it then, that despite my original intuition, the leaf level is actually index level 0, not the highest index level? In that case, your explanation makes sense, as...
November 16, 2009 at 8:46 am
Thatt'l probably put a decent amount of strain on your server... you should be careful.
Why don't you instead just keep all of the stuff being used for post-processing on the...
November 13, 2009 at 11:23 am
Yeah you've misunderstood, sorry if I wasn't clear. The code:
DECLARE @newsletterType INT
DECLARE @newsletterSource INT
SET @newsletterType = 3
SET @newsletterSource = 2
EXEC sp_getNewsletterStatsFromStatsTable @newsletterType = @newsletterType, @newsletterSource = @newsletterSource
Is being run from...
November 12, 2009 at 7:41 am
perfect - that's what I wanted to hear. thanks!
and yeah - I know that I should always be using order by if it's necessary for the functionality of the query....
November 2, 2009 at 2:58 pm
bah. automatically assumed it was seeded with increments of 1. i've never used a non-1 increment personally :/
October 29, 2009 at 6:13 am
Well, the reason I'm using a comma-delimited list as opposed to a child table, is that I have no need for the values as individual entities.
As an example, I have...
October 23, 2009 at 7:21 am
Well, I would agree that for a field like telephone number, or zip code, or maybe even address, a fixed VARCHAR(x) value makes sense.
But what about for a field like,...
October 23, 2009 at 6:50 am
diamondgm (10/23/2009)
You could also do this:
SELECT LEFT(YourString, (CHARINDEX('-', YourString)-1))FROM dbo.YourTable
This wouldn't require alteration should the position of your delim character ever move to the 5th position or further.
Well, your solution...
October 23, 2009 at 5:51 am
Sweet. That's a cute solution, though I'm somewhat surprised that it works!
What does MAX() do when it encounters a VARCHAR field? Like, how does it evaluate between two different sets...
October 20, 2009 at 12:40 pm
Viewing 15 posts - 556 through 570 (of 698 total)