Viewing 15 posts - 28,261 through 28,275 (of 39,771 total)
OK, attempted to correct the answers to include A and B. The old style question and new interface make this an iffy proposition.
Everyone awarded points for this one.
June 6, 2008 at 11:00 am
Lux (6/6/2008)
Rockets are easy. Just make sure Thrust > Mass. The rest is steering.
What happens on the way down? I think I'm glad you're not building them either,...
June 6, 2008 at 10:52 am
User
----
ID
Name
IsVendor
IsCustomer
IsEmp
Not the best solution, but it works.
Or you have
User
------
ID
Name
UserLink
--------
ID
IsVendor
IsCustomer
IsEmp
June 6, 2008 at 10:38 am
Sorry, I meant internal, meaning you don't need variables that you use in the SELECT. Guess it could apply for interval variables.
You could use a CTE if it makes things...
June 6, 2008 at 10:37 am
I've heard good things about NetApp products, but haven't really worked with them, so no firsthand experience.
The vendor wants to sell the thing. They'll always say performance isn't a problem,...
June 6, 2008 at 10:33 am
What's the provider and what were you doing? Not sure either, but looking for more clues.
June 6, 2008 at 10:25 am
Don't think there's a Red Gate tool to do this. Not sure you want to script server settings (sp_configure) to new servers. Maybe, but there are differences between servers you...
June 6, 2008 at 10:24 am
xp_cmdshell opens a shell, or command prompt, from inside SQL Server. You can't see it, and it can't need user input, but it works like a batch file, allowing you...
June 6, 2008 at 10:18 am
But wouldn't some transactions in merge be applied if they committed? It wouldn't necessarily roll back everything because the network dropped. My understanding is that merge is transactional two-way, but...
June 6, 2008 at 10:15 am
I think you might need to loop here, and you need to be sure that there's an order that ensures that records that could be duplicated appear together so you...
June 6, 2008 at 10:12 am
I would avoid storing formatting. Things often change, people don't enter them the same way, and it's easier to strip formatting to ensure consistency than add it in later. Phone...
June 6, 2008 at 10:10 am
Also, if you have more than one subscriber, the commands don't go down until ALL subscribers have gotten them.
June 6, 2008 at 9:12 am
I wouldn't mess with this. Uninstalling things from a cluster can be tricky, and I'm not sure it's worth messing with.
You don't want things enabled that you don't need, or...
June 6, 2008 at 9:11 am
You can see if it's enabled and check for jobs running, look in SSMS for publications defined.
June 6, 2008 at 9:09 am
With the rate of changes in some technology, even SQL Server, I feel like I've got 1 year of experience many times over in some areas (SSIS, Service Broker, etc).
June 6, 2008 at 9:06 am
Viewing 15 posts - 28,261 through 28,275 (of 39,771 total)