Viewing 15 posts - 15,316 through 15,330 (of 39,970 total)
syen (9/9/2011)
September 9, 2011 at 10:21 am
djackson 22568 (9/9/2011)
September 9, 2011 at 10:16 am
My company, Red Gate Software, sells a product that does comparisons. It will give you the schema differences. They have a product for data differences as well.
Are you looking for...
September 8, 2011 at 3:45 pm
Let us know if it works. I was thinking that OUTPUT might help here, but couldn't figure out how it would work in one statement. This should be good for...
September 8, 2011 at 10:00 am
You have to click the My Posts link above. The postback won't work.
September 8, 2011 at 9:59 am
My guess is the virtual disk is a layer on the array, but hard to know. Sounds like what SAN people do sometimes.
Post back if you learn something. Curious to...
September 8, 2011 at 9:58 am
It depends on the size of the load, number of indexes, etc. I've seen it be faster (significantly) on the drop indexes at times. However not always.
Test
September 8, 2011 at 8:59 am
You can see all the topics you've posted to using the "My Posts" above (__doPostBack('butShowMemberPosts',%20'4');)
For the subscriptions, the control panel link above (below your name) takes you to a menu....
September 8, 2011 at 8:49 am
Apart from individual DDL and test data, your logic seems incomplete. I would revisit this and better explain what the process is for computation.
You can use CASE for some of...
September 8, 2011 at 8:47 am
There's no GUI support right now.
Make sure you've created the filestream filegroup first, then you can set this in the T-SQL for the table.
September 8, 2011 at 8:45 am
For subscribers, MSubscriber_Info seems to be what you want: http://msdn.microsoft.com/en-us/library/ms179868.aspx
No idea on the distributor.
September 8, 2011 at 8:42 am
SQL Server instances take the name of the windows host. That could be a real host, or the Windows cluster.
A 2 node cluster has 3 names. SQL Server responds to...
September 8, 2011 at 8:38 am
If the data and logs aren't separated physically, then you could have an issue. I haven't worked with virtual drives. Typically you would have two arrays from one controller (or...
September 8, 2011 at 8:38 am
Confused. Why do you not insert the values into TableB first?
September 8, 2011 at 8:33 am
Developer Edition has all the Enterprise features. Use that on workstations.
I believe the EULA prohibits running a production system on Developer, so please don't plan on that. If you have...
September 8, 2011 at 8:31 am
Viewing 15 posts - 15,316 through 15,330 (of 39,970 total)