Viewing 15 posts - 11,791 through 11,805 (of 13,469 total)
I googled ovl files, and i came up with dos based windows overlay files, or a saved file from Railroad tycoon..neither of which seem to be database related.
can you explain...
December 29, 2008 at 6:29 am
yes of course you can have multiple instances...and the instances can be different versions as well;
simply re-run the installation CD or msi...one of the steps is a prompt that asks...
December 29, 2008 at 6:06 am
sperry (12/26/2008)
I have changed the path from 'C:\severname\test\ExcelExport.xls' to '\\Servername\Test\ExcelExport.xls' and still the same issue. I can access that from both the server and the local...
December 26, 2008 at 5:35 pm
sp_refresh view will update the metadata of a view...so if you did a view that had select * in it, new columns will be added when refreshed;
here's a cursor that...
December 26, 2008 at 2:16 pm
DISTICT gets the distinct items for the columns you selected...if you look at your query results, the only itemt aht changes for the repeated persons that got selected is dbo.SKILLS_DATA.SKILLS_ID,,...
December 26, 2008 at 5:56 am
double post;
continued with suggestions Here:
http://www.sqlservercentral.com/Forums/Topic625801-1291-1.aspx
December 26, 2008 at 5:41 am
can you post the actual query? that would allow us to give an exact answer; for here, i think general suggestions will just lead to more questions and confusion.
December 26, 2008 at 5:38 am
stored procs and functions are a little harder to migrate; most of it is manually editing the procs, sorry.
things to look for:
10G uses the standard JOIN syntax, so that's a...
December 26, 2008 at 5:00 am
IF your table has a a datetime column with a default value of getdate(), you whould simply use a WHERE MYDateColumn BETWEEN date1 AND Date2; If there is not column...
December 25, 2008 at 8:32 am
Here's my first guess, and it's probably right:
when they are coming thru your UI, they are using a different login than when they connect vi SSMS....
if i connect with user...
December 25, 2008 at 8:26 am
i think it's Vista;
compared to XP, where every login was also an admin, didn't Vista remove some rights you might expect by default for security purposes? so your login...
December 25, 2008 at 8:10 am
do you mean something other than using sp_who or sp_who2?
December 25, 2008 at 8:06 am
post the query.
you might be suffering from parameter sniffing, where an execution plan is built on an assumption by the Query optimizer about one or more of the parameters;...
December 24, 2008 at 7:48 pm
i think what you are looking for is using a CASE and sum together to get the value you are after;
here's a the core example:
[font="Courier New"]SUM(CASE WHEN A.Trans_Type_ID IN ('Reversal',...
December 24, 2008 at 12:48 pm
15 seconds is a long time, unless it is fiddling with billions of records.
post the query itself so we can see, maybe a missing join or something is killing performance.
saving...
December 24, 2008 at 5:15 am
Viewing 15 posts - 11,791 through 11,805 (of 13,469 total)