Viewing 15 posts - 1 through 15 (of 27 total)
this is a further question along the same lines..
due to time phasing of upgrades, there will be a time gap in migrating all servers to SS2008 (on Windows Server 2008).
So,...
December 21, 2010 at 8:55 pm
ok..Gail, really, thanks..
but, the restriction that all xml output should go to a single file is really not that important because even if I create many files, I could write...
June 30, 2008 at 8:12 pm
in SSMS, I have the results going to a text file.
I bracket my query with the set showplan_xml on, and off
When I hit the F5, it asks me to...
June 29, 2008 at 3:39 pm
yes, Sir... I smile with you...And thank you for giving us your general quantification. Your categories go to the crux of the problem. I, and I'm sure, the rest...
February 4, 2008 at 7:16 pm
I have now tried the UNION that unionizes each row values and references a single table in the INSERT as suggested by one of you. This was a little improvement....
February 4, 2008 at 2:39 pm
I have some new information on this issue.
I went ahead and purchased Itzik Ben-Gan new book on T-SQL Querying (this is not a plug for his book but it...
February 3, 2008 at 8:20 am
thank you very much gentlemen...very good information
May 11, 2006 at 12:50 pm
Ken/Sharma, Thank you very much for your help.
And Sharma, your explanation on how to interpret the information was great!!!.
Phenomenal was your insight that too many rows are qualified by...
September 12, 2005 at 4:00 pm
Jagan,
Nothing conclusive can be said from the information you've provided. However, I think the issue may be that you're out of CPU. Do this to isolate. Check in task...
September 9, 2005 at 8:03 pm
We all know why views are great. In fact, I built a reporting system based on views upon views. The chains got four or five levels deep.
I knew it...
May 14, 2005 at 12:25 am
I think your query is wrong. I think what you want is this:
SELECT SiteHits.BotName,
COUNT(SiteHits.BotName) AS N,
COUNT(MGD_SiteHits.BotName) AS TTL
FROM SiteHits CROSS JOIN
MGD_SiteHits MGD_SiteHits
GROUP BY SiteHits.BotName
And I get the correct result...
March 18, 2005 at 1:00 am
I added the closing parenthesis to the CAST function....
I made it work by casting the text column to varchar.
I presume that you are dealing with url that are no longer than...
March 16, 2005 at 1:46 am
I made it work by casting the text column to varchar.
I presume that you are dealing with url that are no longer than 8000 bytes and so casting the text to...
March 16, 2005 at 1:42 am
The request is to aggregate based on the country column, and each row in the Order table will be counted as one. We can do this readily using the GROUP...
March 12, 2005 at 6:30 pm
Dennis,
try this:
IF EXISTS (SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = N'Spain_Orders')
DROP VIEW Spain_Orders
GO
CREATE VIEW Spain_Orders
AS
SELECT
[Order ID],
[Customer],
[Employee],
[Order Date],
[Required Date],
[Shipped Date],
[Ship Via],
[Freight],
[Ship Name],
[Ship Address],
[Ship City],
[Ship Region],
[Ship...
March 12, 2005 at 12:37 pm
Viewing 15 posts - 1 through 15 (of 27 total)