Viewing 15 posts - 1,441 through 1,455 (of 2,008 total)
Jeff Moden (11/19/2011)
Dev (11/19/2011)
SSIS would be a very simple setup:
And this is why I don't like it. It stops the learning curve for DB Developer.
The ONLY argument in...
November 20, 2011 at 3:35 am
Don't miss the sequel of this thread... 😀
Last 5 rows - Part II aka Insertion order - GETDATE(), IDENTITY_INSERT, and others...
http://www.sqlservercentral.com/Forums/Topic1207526-391-1.aspx
November 19, 2011 at 9:34 am
SSIS would be a very simple setup:
And this is why I don't like it. It stops the learning curve for DB Developer.
The ONLY argument in favour of SSIS is "Why...
November 19, 2011 at 8:58 am
Pros: the sample reading is held together in the database.
It’s possible with Wide Tables.
A wide table is a table that has defined a column set. Wide tables use...
November 19, 2011 at 8:53 am
yes because source and destination are in the same database is it still ok?
It should not be a problem but I am not sure. I don't see any harm in...
November 19, 2011 at 8:29 am
Ah! That is exactly what I have done and sure enough the index is being picked up with no hints (someone here will be happy...).
It's not only Remi (correct me...
November 19, 2011 at 6:59 am
GilaMonster (11/18/2011)
Dev (11/18/2011)
Expensive:SAN requirement
Microsoft Cluster Server (MSCS) licences
Whereas mirroring requires 2 sets of storage (clustering is one), so unless using direct attached storage for the mirrors as...
November 19, 2011 at 6:47 am
Tara-1044200 (11/19/2011)
but i am loading data from a view to a table with in same database.
I didn’t get you.
Is it stopping you from using OPENROWSET?
Or
Your question is...
November 19, 2011 at 6:01 am
I'm not disagreeing with you. I use the car example. It's just hard to push that over to people and everything that you say is part of a human.
It's not...
November 19, 2011 at 5:56 am
I am giving here one example to help you in understanding the issue.
PRINT @@TRANCOUNT
-- The BEGIN TRAN statement will increment the
-- transaction count by 1.
BEGIN TRAN
...
November 19, 2011 at 5:33 am
Tara-1044200 (11/19/2011)
DEv, could you please tell what components i have to use for this simple process.
I am not sure for SSIS but I can help you in starting with 2nd...
November 19, 2011 at 5:21 am
Personally, I find it a shame that Microsoft removed the networking/server requirement from the SQL Server Certification with SQL Server 2005.
I am thankful to MS for the same. Who knows...
November 19, 2011 at 5:02 am
Also when I start this procedure as user 'DMView', it fails (normal).Even when I logon as sa and execute the procedure, it fails with this error.
Can you please explain...
November 19, 2011 at 4:20 am
p-nut (11/18/2011)
Steve Malley (11/18/2011)
OPENROWSET
( { 'provider_name' , { 'datasource' ; 'user_id' ; 'password'
| 'provider_string' }
...
November 19, 2011 at 4:05 am
Viewing 15 posts - 1,441 through 1,455 (of 2,008 total)