Viewing 15 posts - 6,151 through 6,165 (of 13,469 total)
OK I'm thinking a *little* straighter on how to do it, but i'm not that close.
i can use a Tally table method to get the comments from the definition of...
January 1, 2012 at 6:12 am
there is a variant of SQL 2008 R2 called "parallel Data Warehouse", you can read a bit more about it here:
http://www.microsoft.com/sqlserver/en/us/solutions-technologies/data-warehousing/pdw.aspx
and it uses Massively Parallel processing, which is in theory...
January 1, 2012 at 5:32 am
DBA Rafi (12/31/2011)
My Query is:
what happened when changes are...
December 31, 2011 at 6:16 am
I see the same thing Gail does...that's looking like an ORACLE trigger;
SQL triggers handle all the rows at the same time,and not for each row via the specially materialized INSERTD...
December 31, 2011 at 6:10 am
ByronOne (12/30/2011)
Are there any SQL editions that don't come with SQL Agent? Specifically does it come with the Compact edition and if not can it be added in anyway?Cheers
Compact Edition...
December 30, 2011 at 8:36 am
i think this minor modification will do what you are asking; instead of returning a datatime, i changed it to returnt eh varchar(10);
inside it it's using convert twice, once to...
December 30, 2011 at 7:44 am
its not R2 that is the problem, its connecting to the instance.
since you can connect via name, we know you already allowed remote connections.
to get to an instance, instead of...
December 30, 2011 at 5:22 am
ok, now i am confused; i thought the insert was SELECT 0, 'test'
from Customer....but it's just SELECT 0, 'test'
for that, i'd expect an estimate of one row....
December 29, 2011 at 1:50 pm
well, first the two queries are not the same; one is a straight insert of static values for every row in the table , or 500K.
the other is a...
December 29, 2011 at 1:46 pm
you have this line
JOIN DimIteration
that is missing the join criteria..
ON sometable.column = DimIteration.column
December 29, 2011 at 12:37 pm
shouldn't it look something like this?
CREATE FUNCTION udf_ConvertDB2toSQL(@CSC_DATE varchar(7))
RETURNS DateTime
AS
BEGIN
DECLARE @SQLDate Datetime
...
December 29, 2011 at 9:21 am
i should add that if the procedure uses dynamic SQL instead of direct DDL commands, then the ownership chaining is not used, and the specific permissions, like SELECT or DELETE...
December 29, 2011 at 6:45 am
there is an ownership chaining assumption in SQL Server:
if you create a procedure ie dbo.myProc, and you grant a user EXECUTE rights to that proc, no matter what that...
December 29, 2011 at 6:18 am
hmbtx (12/27/2011)
Thank you for the detailed instructions. I have three questions if you have the time to answer them but if your time is limited an answer to question #1...
December 27, 2011 at 7:09 pm
Viewing 15 posts - 6,151 through 6,165 (of 13,469 total)